OraFAQ Forum: Server Administration » Re: How to insert single quote (') in the row of table

Home » RDBMS Server » Server Administration » Re: How to insert single quote (') in the row of table

Tue, 05 June 2001 07:25

Cindy
Messages: 88
Registered: November 1999

Member

Try this:

1* select 'John''s job' "TEST" from dual
SQL> /

TEST
----------
John's job

Previous Topic:	sql query
Next Topic:	synonymns

Goto Forum:

]

Current Time: Fri Jul 05 07:18:45 CDT 2024