I Need the clear steps to write the PL/SQL procedure from the select statemet
say Select * from emp where job like 'CLERK'
I need to pass the Parameter for JOB the out of the query will give 20 records and all the 20 records insert statement records should store in text file.
I need help ,
How to write the procedure using UTL_FILE _DIR,
do i need to set up any parameters for UTL_FILE;
need help to excute the procedure step by step Please.