Home » SQL & PL/SQL » SQL & PL/SQL » pl/sql help
pl/sql help [message #215798] Tue, 23 January 2007 23:23 Go to next message
gautamsutar
Messages: 14
Registered: January 2007
Location: india
Junior Member
Hi

In my procedure I used cursor to fetch data from some table.
I am taking emp table for example
In a string l_sql I concatinate data of emp table by putting for loop. There are so many records in the table and i want to to concatinate all the records in one large string e.g.
l_total_string := l_total_string || l_sql
and after coming out of loop I want to write the string to some text file using utl package

Please help me

Gautam Sutar
Re: pl/sql help [message #215806 is a reply to message #215798] Tue, 23 January 2007 23:58 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
>after coming out of loop I want to write the string to some text file using utl package
OK, proceed & do so.
Re: pl/sql help [message #215814 is a reply to message #215798] Wed, 24 January 2007 00:13 Go to previous message
gautamsutar
Messages: 14
Registered: January 2007
Location: india
Junior Member
Hi anacedent

I am declaring total_string as clob data type because of so many records in a table.

I tried with utl package but text file is not created.

gautam
Previous Topic: Data Sanitization
Next Topic: prob in selecting from type(collection)
Goto Forum:
  


Current Time: Fri Dec 02 14:25:58 CST 2016

Total time taken to generate the page: 0.21493 seconds