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

Thread: sqlplus question

  1. #1
    Join Date
    Sep 2000
    Posts
    77
    I am trying to paste some 300 lines of code from a file to sqlplus window on
    windows NT ,but after pasting some 95 lines it is not pasting any further.
    Is there any setting i can modify so that i can paste any noof lines of code
    to sqlplus window. Please advise.
    Thanks

  2. #2
    Join Date
    Dec 2000
    Posts
    6

    Paste operation


    Durga,

    You can paste the lines into a file, and then read this SQL file from SQL*Plus using:

    SQL> @your_filename_goes_here.sql

    ---
    Roberto S Nakai
    NZ Technology

  3. #3
    Join Date
    Oct 2000
    Posts
    123

    Re: Paste operation

    THis is 'cos the buffer limit in SQLPLUS, Do one thing:

    open NotePad in new session, then paste the file in it, and finally you can paste any length as you want to from NotePad to the SQLPLUS environment.

    Take care

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