Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
JuzDream
Starting Member
7 Posts |
 Posted - 2008-08-26 : 22:22:11
|
| I have this PL/SQL that I will want to generate a CSV file.[CODE]SET SERVEROUTPUT ON;SET TIMING ON;DECLARE CURSOR C1 IS select balance from contract ; BEGIN FOR i IN C1 LOOP IF i.balance <> '0' THEN DBMS_OUTPUT.PUT_LINE('Amount is not 0 '); I will like to put the statement 'Amount is not 0 ' in a CSV file here else DBMS_OUTPUT.PUT_LINE('Amount is 0 '); END IF; end loop;END;/[/CODE]How am I suppose to do this? |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-08-26 : 22:30:08
|
What do you want actually ? An equivalent code for MS SQL Server ?
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
JuzDream
Starting Member
7 Posts |
Posted - 2008-08-26 : 22:35:18
|
| No, for PL/SQL, I want to generate a csv file that will have all the values whenever it enters that if statement. |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2008-08-26 : 22:44:07
|
this forum is for SQL Server questions. try asking on www.orafaq.com or similar.
elsasoft.org |
|
|
|
joe.inom
Starting Member
9 Posts |
Posted - 2008-09-01 : 10:49:27
|
| hey , i have visited orafaq , i mean i used to when i was a student at teh NIIt courses , it is rubbish , better serach for beter forums in google.joe Alexender |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-09-01 : 11:24:27
|
| trydbforums.com or sitepoint.com |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-09-01 : 11:46:27
|
So visiting orafaq instead of paying attention in class didn't make you more experienced nor more learned?
E 12°55'05.63"N 56°04'39.26" |
|
|
|
|
|
|
PL/SQL Generate CSV file