SQLPLUS > inserting multiple lines [message #35898] |
Tue, 23 October 2001 00:21 |
Wisnu
Messages: 2 Registered: October 2001
|
Junior Member |
|
|
hai, does anybody know how to insert multiple lines data into a table ????
i can insert this data :
---------------------------
data data data
data data tda
data data data
---------------------------
but i can't insert this kind of data :
---------------------------
datadata data
datadatadata
data datadatadata
datadatadata
---------------------------
i cant insert it because of the blank line
please help me ......
----------------------------------------------------------------------
|
|
|
Re: SQLPLUS > inserting multiple lines [message #35900 is a reply to message #35898] |
Tue, 23 October 2001 01:15 |
Milan Kumar Barui
Messages: 16 Registered: October 2001
|
Junior Member |
|
|
Hi,
For inserting :
data data data
data data data
command :
insert into table_name(col_name)
values('data data data
data data data');
For inserting :
data data data
data data data
command :
insert into table_name(col_name)
values('
data data data
'
||
'
data data data');
Try with this, it will work. Let me know thr feedback.
Thanks
Milan
Oracle DBA
----------------------------------------------------------------------
|
|
|
|