Oracle® OLAP DML Reference 11g Release 1 (11.1) Part Number B28126-01 |
|
|
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 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