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

Thread: User Input in PL/SQL block?

  1. #1
    Join Date
    Nov 2000
    Posts
    48

    Question

    Hi All,

    I am having a requirement of accepting input from user depending upon conditions within PL/SQL block. But I have not done this before and I dont know.

    Pl help me in this.

    Thanks a lot

    RB

  2. #2
    Join Date
    May 2000
    Posts
    58
    Can you pass these inputs as parameters to the pl/sql ( procedure ) because Pl/sql is not interactive..

  3. #3
    Join Date
    Feb 2001
    Posts
    180
    Do you mean something like this:
    undefine tablename
    accept tablename char prompt 'Table name: '
    undefine no_of_rows
    accept no_of_rows char prompt 'Number of rows: '

    select * from &&tablename
    where rownum <= &&no_of_rows;
    Regards
    Ben de Boer

  4. #4
    Join Date
    Nov 2000
    Posts
    48
    Yes like this but in the begin and end block.

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