Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

unload

580343Jul 7 2007 — edited Aug 31 2007
hi all,
I am using oracle 10g.How to unload ( create command and data ) from table to file.using any command.
Is it possible to load like this:

CREATE TABLE TABLE1( COL1 NUMBER, COL2 VARCHAR(10) )
/
INSERT INTO TABLE1 VALUES (
:1,
:2)
\
$DATATYPES NUMBER, CHARACTER
1,"ASD",
2,"ASDF"


Thanks in advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 28 2007
Added on Jul 7 2007
8 comments
780 views