Re: How to enter ingle or double quotes in INSERT INTO ... VALUES?

MaG <antonio_homepage_at_yahoo.com> schreef in berichtnieuws b50d7a74.0304281642.3963fd13_at_posting.google.com...
| Anton,
|
| Thanks for your help. Your suggestions will definitely work for my
| assignment.
|
| I'm also wondering if there's a way to avoid typing two single quotes
| when you want to insert a single quote in the column.
|
| For instance, to insert:
| That's OK
| in a varchar2 column, I have to type in: That''s OK
|
| Is there any way I can avoid writing two quotes?
|
| Thanks,
| AH
|
|
|
|
|
|
| "Anton Buijs" <remove_aammbuijs_at_xs4all.nl> wrote in message
news:<3ea99abe$0$49107$e4fe514c_at_news.xs4all.nl>...
| > MaG <antonio_homepage_at_yahoo.com> schreef in berichtnieuws
| > b50d7a74.0304251122.cbcc4db_at_posting.google.com...
| > | Hello,
| > |
| > | I need to write a script which asks the user to enter a string. This
| > | string is stored in a varchar2 column. This can off course be achieved
| > | using & in a INSERT INTO ... VALUES statement.
| > |
| > | But how do I handle input strings that contain single quotes and
| > | double quotes?
| > |
| > | Thanks for your help,
| > | AH
| >
| > SQL> create table test (col1 varchar2(10));
| >
| > Table created.
| >
| > SQL> insert into test values ('&param');
| > Enter value for param: a
| > old 1: insert into test values ('&param')
| > new 1: insert into test values ('a')
| >
| > 1 row created.
| >
| > SQL> undef param
| > SQL> /
| > Enter value for param: "b"
| > old 1: insert into test values ('&param')
| > new 1: insert into test values ('"b"')
| >
| > 1 row created.
| >
| > SQL> undef param
| > SQL> /
| > Enter value for param: ''c''
| > old 1: insert into test values ('&param')
| > new 1: insert into test values ('''c''')
| >
| > 1 row created.
| >
| > SQL> select * from test;
| >
| > COL1
| > ----------
| > a
| > "b"
| > 'c'
| >
| > To be clear:
| > b is added as double-quote b double-quote
| > c is added as single-quote single-quote c single-quote single-quote
| > Or: a double-quote can just be typed. A single-quote must be entered
twice
| > to get one into the column.

I can't think of one. Sqlplus is not the most commonly used tool to insert data interactively and not designed for that purpose. And for incidental usae maybe a reminder like

   prompt Enter ' as double '
could be adequate? Received on Tue Apr 29 2003 - 13:19:06 CDT