Oracle® OLAP DML Reference 10g Release 2 (10.2) Part Number B14346-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 16-28 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