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

Thread: SQL plus question

  1. #1
    Join Date
    Jan 2002
    Posts
    474
    Hi all,

    If i have a long function and I want to create this function in the database. What I did was copy and paste it in SQL plus, and it stop at line 99.

    what command in SQL plus I need type before I can copy and paste the whole thing to SQL Plus???

    Thanks

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    do a select, click enter twice, write ed, dleete everything in text, paste the function now

    close text editior

    run


  3. #3
    Join Date
    May 2002
    Location
    USA
    Posts
    462
    try to set high buffer value

    eg ..
    set buffer 999999
    siva prakash
    DBA

  4. #4
    Join Date
    Jan 2002
    Posts
    474
    prakash43,

    set buffer doesn't help, it still stop at line 99 in SQL Plus



    Pando,

    Could you elaborate your suggestion a little , I don't get it

    thanks all

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    well when you write a query you can edit it afterwards right by writing ed right?

    then just do that write any query then edit the file and paste the text there

  6. #6
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    or simple...

    save comple function in .sql file and run that file in SQL*Plus

    SQL> @myfunc.sql;


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