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.
This entry was posted on July 31, 2008 at 8:44 pm and is filed under Database, Oracle, SQL, Software, Technology, pl/sql, programming with tags blog, blogging, Coding, Database, Oracle, pl/sql, techsaints. You can follow any responses to this entry through the RSS 2.0 feed
You can leave a response, or trackback from your own site.
November 24, 2008 at 5:31 am
Hi,
I want to know how to insert a txt.file in a particular field using PL/SQL
plz tell me code also