SQL> select trigger_name ,trigger_body from user_triggers where rownum=1
2 ;
TRIGGER_NAME ,TRIGGER_BODY
------------------------------,------------------------------
AURORA$SERVER$SHUTDOWN ,dbms_java.server_shutdown;
It will work for LONG right???
Thanks and Regards,
Satheesh Babu.S
-----Original Message-----
From: tpepling
[mailto:oracledba-ezmlmshield-x70006245.[Email address protected]
Sent: Tuesday, August 03, 2004 4:36 PM
To: LazyDBA Discussion
Subject: RE: Exporting data from tables into a CSV delimited file
Doesn't work if table ("EMP" in this case) has LONGs or LOBs. I'm sure
Ed
knows that, but I just wanted to point that out to those who don't.
-----Original Message-----
From: Edwards Ed
[mailto:oracledba-ezmlmshield-x20186145.[Email address protected]
Sent: Tuesday, August 03, 2004 6:49 AM
To: LazyDBA Discussion
Subject: RE: Exporting data from tables into a CSV delimited file
set colsep ','
set heading off
set feedback off
set flush off
set termout off
spool emp.txt
select empno, '''' || ename || '''', sal from emp;
spool off
-----Original Message-----
From: Nick Cowe
[mailto:oracledba-ezmlmshield-x5643496.[Email address protected]
Sent: Tuesday, August 03, 2004 6:41 AM
To: LazyDBA Discussion
Subject: RE: Exporting data from tables into a CSV delimited file
how would you wrap quotes around text columns so that commas in the data
don't get misinterpreted?
-----Original Message-----
From: Edwards Ed
[mailto:oracledba-ezmlmshield-x14986977.[Email address protected]
Sent: 03 August 2004 11:38
To: LazyDBA Discussion
Subject: RE: Exporting data from tables into a CSV delimited file
set colsep ','
set heading off
set feedback off
set flush off
set termout off
spool emp.txt
select * from emp;
spool off
-----Original Message-----
From: Satheesh
[mailto:oracledba-ezmlmshield-x42257972.[Email address protected]
Sent: Tuesday, August 03, 2004 5:27 AM
To: LazyDBA Discussion
Subject: RE: Exporting data from tables into a CSV delimited file
What about this?,
Set colsep ','
Spool tname.csv
Select * from table;
Spool off;
Thanks and Regards,
Satheesh Babu.S
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. If the reader of this message is not the intended recipient,
you are hereby notified that your access is unauthorized, and any
review,
dissemination, distribution or copying of this message including any
attachments is strictly prohibited. If you are not the intended
recipient, please contact the sender and delete the material from any
computer.
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page