Re: Special Characters

Rainer Ternes wrote:
>
> Hi,
>
> I would like to select and insert special characters
> (e.g, ' ) in varchar2 fields.
> Does anybody know haw to do this?
>
> thanks
> Rainer
> --
> *************************************************
> Rainer Ternes
> Max-Planck-Institut fuer Molekulare Genetik
> Ihnestr. 73
> D - 14195 Berlin
> Germany
>
> Tel +49 30 84131408
> Fax +49 30 84131395
> mailto: ternes_at_mpimg-berlin-dahlem.mpg.de
> ************************************************

INSERT INTO table_name ( col_1 )
  SELECT '''' FROM DUAL;
The SELECT statemnet returns ' , I did not try myself along with INSERT statement.

• Joseph Suh dbtech_at_inetnow.net.usa *
• Oracle DBA 770-908-9785 *
• Database Technology Int'l, Inc. *
• Atlanta, Georgia *

  ---