User Input in PL/SQL block?

[rborikar]

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

[Victoria]

Can you pass these inputs as parameters to the pl/sql ( procedure ) because Pl/sql is not interactive..

[bensr]

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;

[rborikar]

Yes like this but in the begin and end block.