Re: how to insert a single quotes in to a table using SQL?

Assuming you want to do it in SQL*Plus: use a ' twice to keep a '

SQL> create table quote (col1 varchar2(20));

Table created.

SQL> insert into quote values ('don''t');

1 row created.

SQL> select * from quote;

COL1

SQL> drop table quote;

Table dropped.

vismay <vismaymandloi_at_hotmail.com> schreef in berichtnieuws 2954112e.0208240706.1584b75a_at_posting.google.com...
| well this (''' ) doesn't work either. and ' " ' this is also not
| working. so please tell me how to enter a single quote in oracle
| e.g. string "don't" .
|
|
| vismay
Received on Sat Aug 24 2002 - 10:24:58 CDT