interviews.dotnetthread.com

↑ Grab this Headline Animator

Friday, October 24, 2008

What is spooling in oracle?

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;

Submit this story to DotNetKicks

No comments:

Post a Comment

Post your comments/questions/feedback for this Article.

 

Latest Articles