OraFAQ Forum: SQL & PL/SQL » how do i insert a value like 'Help'm pls' into a varchar column

Home » SQL & PL/SQL » SQL & PL/SQL » how do i insert a value like 'Help'm pls' into a varchar column

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how do i insert a value like 'Help'm pls' into a varchar column [message #18394]

Wed, 30 January 2002 04:56

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

Report message to a moderator

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

pratap kumar tripathy
Messages: 660
Registered: January 2002

Senior Member

try

insert into your_table values('Help''mpls');

Report message to a moderator

Previous Topic:	numeric to sring
Next Topic:	PLS-00103: Encountered

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 20 12:45:49 CDT 2025