Hi Guys,
I am having a .sql file where i need to get input from user start and end date to process further in passing as parameter in procedure
test.sql
Proc_process(p_in =>lv_in,p1_in =>lv_in1);
once the above process is done then ask user to proceed with altering the table with columnn name as col_1
press Y to continue or N to exit
alter table T1 add col_1 date;
I want these operations to be perfromed when in execute test.sql