Home » SQL & PL/SQL » SQL & PL/SQL » A question about escape sequence...Urgent!!
A question about escape sequence...Urgent!! [message #18822] Sat, 16 February 2002 01:07 Go to next message
Shrirang
Messages: 8
Registered: October 2000
Junior Member
Hi Friends,
I am slightly confused about how to use the escape sequence.For example i have a table employee containing following columns:

reg_no number(5),
emp_name varchar2(100)

But when i try to enter the name like D'SOUZA into emp_name column it gives error.
This is very big table and around 50000 values will be inserted into it eventually.

How do i overcome this problem?Is it possible to write any trigge for this which will provide necessary escape sequence ?
If yes how?
Thanks in advance
Rgds.
-Shrirang.

Report message to a moderator

Re: A question about escape sequence...Urgent!! [message #18823 is a reply to message #18822] Sat, 16 February 2002 05:23 Go to previous message
sokeh
Messages: 77
Registered: August 2000
Member
this is one possible solution:
insert into emp(name)
values('D''SOUZA');

Report message to a moderator

Previous Topic: Check for existence of table, if not there, create, if there, update
Next Topic: Pass parameter list to IN clause of cursor
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 15:57:07 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.