Oracle SET DEFINE OFF

The SET DEFINE OFF command in Oracle prevents Oracle from doing any variable substitution.

Use the SET DEFINE OFF command in Oracle to prevent Oracle from interpreting the ampersand for variable substitution.

The SET DEFINE ON command turns variable substitution back on.

About these ads

One Response

  1. Hi,

    I want to know how to insert a txt.file in a particular field using PL/SQL

    plz tell me code also

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: