Home » SQL & PL/SQL » SQL & PL/SQL » how do i insert a value like 'Help'm pls' into a varchar column
how do i insert a value like 'Help'm pls' into a varchar column [message #18394] Wed, 30 January 2002 04:56 Go to next message
ksr
Messages: 112
Registered: January 2002
Senior Member
Hi,
I have a col called name varchar2(100).
how do i insert a value like Help'mpls into this column throug insert statement

note that there is a ' between the value
Re: how do i insert a value like 'Help'm pls' into a varchar column [message #18397 is a reply to message #18394] Wed, 30 January 2002 05:06 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
try

insert into your_table values('Help''mpls');
Previous Topic: numeric to sring
Next Topic: PLS-00103: Encountered
Goto Forum:
  


Current Time: Fri Mar 29 04:59:50 CDT 2024