Home » SQL & PL/SQL » SQL & PL/SQL » SQLPLUS > inserting multiple lines
SQLPLUS > inserting multiple lines [message #35898] Tue, 23 October 2001 00:21 Go to next message
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 Go to previous messageGo to next message
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

----------------------------------------------------------------------
Re: SQLPLUS > inserting multiple lines [message #35905 is a reply to message #35900] Tue, 23 October 2001 02:11 Go to previous message
Wisnu
Messages: 2
Registered: October 2001
Junior Member
IT WORKS !!
IT WORKS !!
THANK YOU SO MUCH

----------------------------------------------------------------------
Previous Topic: Re: converting a pl/sql rocedure into an exe file or any OS file
Next Topic: Insert statements from Stored Function
Goto Forum:
  


Current Time: Thu Mar 28 10:11:11 CDT 2024