How to use "for" statements in oracle?

827

I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance

2104

What is the use of file param in imp command?

928

How to calculate date and time differences in oracle?

792

How to experiment a data lock in oracle?

826

Explain about your project and its relation to the current job position you are applying to?

793

What are the differences between interval year to month and interval day to second?

795

How to fetch the row which has the max value for a column?

773

How to view existing locks on the database?

800

Is there any function in oracle similar like group_concat of mysql?

831

What are the differences between primary key and unique key?

764

What privilege is needed for a user to insert rows to tables in another schema?

817

How to call a sub procedure?

842

What is difference between cartesian join and cross join?

822

When do you get a .pll extension in oracle? Explain its importance

807