A question about escape sequence...Urgent!! [message #18822] |
Sat, 16 February 2002 01:07 |
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.
|
|
|
|