Home » SQL & PL/SQL » SQL & PL/SQL » Re: Names with single quotation marks
Re: Names with single quotation marks [message #2805] Wed, 14 August 2002 05:05
Gilbey
Messages: 87
Registered: March 2002
Member
Try this...
SQL> select * from local;

ID NAME
---------- ----------
pk01 prabh's
pk02 prabh2's
pk03 prabh3's
pk04 prabh4's
pk05 prabh5's

You just have to qualify the apostrophe with one more apostrophe.
SQL> select id from local where name='prabh''s';

ID
----------
pk01

SQL>

Report message to a moderator

Previous Topic: Can an insert trigger add a row to the same table?
Next Topic: Re: Summing up data by quarters
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 24 23:20:05 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.