| Oracle® OLAP DML Reference 11g Release 2 (11.2) E17122-07 | 
 | 
| 
 | PDF · Mobi · ePub | 
The LISTFILES command lists all the open files that can be referenced by the FILEQUERY function which includes all files opened by FILEOPEN, OUTFILE, and LOG command.
LISTFILES
Example 10-32 Listing Open Files
The following example shows how to use LISTFILES 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