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

Thread: creating sql to generate sql

  1. #1
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995

    creating sql to generate sql

    hey guys,
    I've got an sql statment that is cutting off my generated sql if I set wrap off I get this
    Code:
    alter table AITADMIN.SYSTEM_TRUSTED_SITE disable constraint FK_SYSTEM_TRUST_SYS_
    if I set wrap on I get this
    Code:
    alter table AITADMIN.SYSTEM_TRUSTED_SITE disable constraint FK_SYSTEM_TRUST_SYS_
    CD;
    any ideas how I can make it so no code gets chopped off and no carrage returns, so I can get just one line of code and this damned thing to work?

    thanks in advance for the help!
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

  2. #2
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    set linesize 1000

  3. #3
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    Ohh you are soooo the MAN! thanks dooooood. that fixed it.
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

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