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.

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