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;
|
Results 1 to 4 of 4
Thread: User Input in PL/SQL block?Threaded View
|
Click Here to Expand Forum to Full Width |