-
Hi,
Now i have a table emp (name varchar2(200)).
I inserted data as below:
insert into emp values ( 'tony & stone');
i was prompted:
enter value for stone:
I know that because the "&" in the statement. I really want it in the table. So how could i disable the meaning of "&"?
I used \& to try. It failed.
Any ideas?
-
Do this;
insert into emp
values('tom'||'&'||'bob');
Take Care
-
Hi, Mber:
I got it!
Thanks very much!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|