Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How to insert multi line message into long datatype
Hi My company has an old oracle database table which use long datatype to store short news article. I need to insert a few short article into that table. However in sqlplus when I tried : create table article ( id int, text long, ....); insert into article (id, text, ...) values (407, ' Our...- damonpin
- Thread
- Replies: 3
- Forum: Oracle: All versions
-
how to generate insert statement from existing database
hi, I have a sample database which I know how to create the schema. I want to generate a sql script containing insert data statement from this sample database. I want to give the sql script containing insert statement to client so they could regenerate the sample database. Is there an...- damonpin
- Thread
- Replies: 3
- Forum: Sybase: Adaptive (SQL) Server
