-
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
-
Can you pass these inputs as parameters to the pl/sql ( procedure ) because Pl/sql is not interactive..
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|