|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
May 4th, 2005, 05:43 AM
|
|||
|
|||
Fetch Cursor value to a file rather that a variable
How can we fetch a cursor to a file ( redirect the value to a file ) rather than to a variable .
|
|
#2
May 4th, 2005, 07:41 AM
|
||||
|
||||
|
You need to fetch to a variable and then write to file.
Here are two examples Pl/SQL procedure to write to excel file and read/write files from Pl/SQL.
__________________
My blog Tutorials about OSS databases, DBMonster ... Contribute to OSS Development, fill bug reports! Developer Shed eSupport Commented my.ini/my.cnf (ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins Random data (with a bias)
|
|
| Viewing: Dev Shed Forums > Databases > Oracle Development > Fetch Cursor value to a file rather that a variable |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
