Oracle® OLAP DML Reference 10g Release 2 (10.2) Part Number B14346-03 |
|
|
PDF · Mobi · ePub |
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.
LISTFILES
Example 18-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