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
Printable View
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;
Yes like this but in the begin and end block.