SQL*Plus (MOSC)

MOSC Banner

Escape char

edited Jun 3, 2009 2:58AM in SQL*Plus (MOSC) 4 commentsAnswered ✓
 I am trying to insert data with embedded quotes

have data as

create table some_table(

some_name varchar2(65),

some_description varchar2(2000));

insert into some_table values ('name','this data has embedded quotes escaped with \' doesn\'t seem to work');

Doesn't  set escape on turn on the backslash escape character?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center