Re: Inserting a & into a table

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: 1998/04/02
Message-ID: <6fut75$1kd@bgtnsc03.worldnet.att.net>#1/1

On 1 Apr 1998 07:59:22 GMT, "Shawn A. Savela" <ssavela_at_winternet.com> wrote:

>How do I insert a row into a table that has an embedded '&'
>character in it via sqlplus?

The SQL*Plus command SET DEFINE OFF will turn variable substitution off. Once you execute that, SQL*Plus will leave the ampersands alone.

Jonathan Received on Thu Apr 02 1998 - 00:00:00 CST

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US