.Net Interview Questions, Resources, Tips & Tricks.

Generally in the SQL command prompt of the oracle the result will show when we are writing any query. If we want to save the result of any query into the file then we are using spooling.

for an example:
You can spool out to a flat file per person using the customer name, for example.

Using PL/SQL you can do something like this:

COLUMN CUSTOMER_NUM NOPRINT NEW_VALUE CUSTOMER_NUM;

SELECT CUSTNO CUSTOMER_NUM FROM CUSTOMER

SPOOL \&&CUSTOMER_NUM.txt;