Oracle® OLAP DML Reference 10g Release 1 (10.1) Part Number B10339-02 |
|
|
View PDF |
The LISTFILES command lists all the open files that can be referenced by the FILEQUERY function. This includes all files opened by FILEOPEN, OUTFILE, and LOG command.
Syntax
LISTFILES
Examples
Example 16-26 Listing Open Files
The following example shows how to use the LISTFILES command to see which open files can be referenced by the FILEQUERY function.
DEFINE fil.unit VARIABLE INTEGER fil.unit = FILEOPEN('report' WRITE) LISTFILES
These statements produce the following output.
10 w D:\WINNT35\SYSTEM32\report