OraFAQ Forum: SQL & PL/SQL » searching for a ' quote through SQL

Home » SQL & PL/SQL » SQL & PL/SQL » searching for a ' quote through SQL

Tue, 19 February 2002 02:47

satish r
Messages: 1
Registered: February 2002

Junior Member

How do we search for a single quote in a particular column through SQL.

Tue, 19 February 2002 03:32

Suresh Vemulapalli
Messages: 624
Registered: August 2000

Senior Member

select col1 from table1 where instr(col1,chr(39))>0;

Previous Topic:	Create Table Dynamically
Next Topic:	Database links

Goto Forum:

]

Current Time: Wed Apr 17 20:41:01 CDT 2024