Hi Friends,
How to or ...
Can PL/PQL be able to prompt and accept user input
from screen? (e.g.) "Please Enter Process Date (format yyyymmdd)"
Thanks,
Printable View
Hi Friends,
How to or ...
Can PL/PQL be able to prompt and accept user input
from screen? (e.g.) "Please Enter Process Date (format yyyymmdd)"
Thanks,
Not in a function, procedure or package, which are entirely serverside processes.
Through SQL*Plus you could prompt for and accept a value, then pass it to a procedure, or use it in an anonymous block of PL/SQL