RE: Replacing the pesky '

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Mon, 22 Oct 2001 10:37:49 -0700
Message-ID: <F001.003B1851.20011022102429@fatcity.com>

> -----Original Message-----
> From: Thater, William [mailto:ThaterW_at_telergy.net]
>
> try replace(lastname, ' '' ')

In the same way, if you want to create an object (e.g. table or username) with double quotes in the name, you have to use two double quotes.

SQL> create table "my ""favourite"" table" ("my ""favourite"" column" date) ;

Table créée.

SQL> select table_name, column_name from user_tab_columns ;

TABLE_NAME                     COLUMN_NAME
------------------------------ ------------------------------

my "favourite" table           my "favourite" column Received on Mon Oct 22 2001 - 12:37:49 CDT