DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: how to disable the ampersand in sql script?

  1. #1
    Join Date
    Mar 2004
    Location
    IA USA
    Posts
    257

    how to disable the ampersand in sql script?

    Hi DBAs,

    There are some ampersands before the data which should be inserted into the database in some of the scripts. When I run them, the system
    always prompted to input data. This is the default behavior.

    How can I disable the default ampersand functionality?

    Thanks,

    Lily

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    set define off
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Nov 2000
    Location
    Birmingham, UK
    Posts
    360
    set scan off does the job too

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width