How to query a string containing an apostrophe ?

[news]

Hi there,

I have a table in an Oracle 9i R2 database containing the following string"

"It's so easy"

When I try to execute the following query:
SELECT EXPRESSION FROM EXPRESSIONS WHERE EXPRESSION = "It's so easy"

I recieve an error:
ORA-01740-Missing double quote in identifier

I tried to correct the query with a double quote:
SELECT EXPRESSION FROM EXPRESSIONS WHERE EXPRESSION = "It''s so easy"

then the query return empty.

Is there something I'm doing wrong ?

The definition of the table is

CREATE TABLE EXPRESSIONS
(
ID NUMBER(8) NOT NULL,
EXPRESSION_IDXED NVARCHAR2(500) NULL,
CREATEDATE DATE NULL,
CREATEBY NVARCHAR2(20) NULL,
)

Thanks for your help.

JBF

[news]

Hi again,

It was my mistake. I did the query without the uppercase on the first
letter. I corrected it and it works fine.
please disregard the previous post.

JBF.
"news" <jb*******@multicorpora.ca> wrote in message
news:SG********************@weber.videotron.net...

Hi there,

I have a table in an Oracle 9i R2 database containing the following string"
"It's so easy"

When I try to execute the following query:
SELECT EXPRESSION FROM EXPRESSIONS WHERE EXPRESSION = "It's so easy"

I recieve an error:
ORA-01740-Missing double quote in identifier

I tried to correct the query with a double quote:
SELECT EXPRESSION FROM EXPRESSIONS WHERE EXPRESSION = "It''s so easy"

then the query return empty.

Is there something I'm doing wrong ?

The definition of the table is

CREATE TABLE EXPRESSIONS
(
ID NUMBER(8) NOT NULL,
EXPRESSION_IDXED NVARCHAR2(500) NULL,
CREATEDATE DATE NULL,
CREATEBY NVARCHAR2(20) NULL,
)

Thanks for your help.

JBF