OraFAQ Forum: Server Administration » Re: How to insert an & in a varchar2 throw a SQL script ?

Home » RDBMS Server » Server Administration » Re: How to insert an & in a varchar2 throw a SQL script ?

Fri, 02 March 2001 16:06

Bala
Messages: 205
Registered: November 1999

Senior Member

Hi,
SQL> set escape '/'
SQL> insert into t1(col1) values('valuewith/&')
SQL> select * from t1;
COL1
------
valuewith&

Bala

Previous Topic:	inserting into the table
Next Topic:	Re: How to insert an & in a varchar2 throw a SQL script ?

Goto Forum:

]

Current Time: Thu Jun 13 06:36:49 CDT 2024