This content has been marked as final. Show 6 replies
What are the column you have in the table?
If you don't have seperate columns, How are you saving it in the table comma, seperated values or?
If you have columns for each parameter why don't you insert all the parameters together
insert into rep_info values(ORG_ID, P_FDATE,P_TDATE, LOT_NO, LOT_QUANTITY) or --coma seperated insert into rep_info values(ORG_ID||','|| P_FDATE||','||P_TDATE...etc)
I think you better consider changing the design as you will have so much redundant data. For the same report you are saving 'report name', Report Run Date/Time again and again the more parameter you have the more records you are inserting with same data
What about this
Insert into rep_info values(col_1,col_2,P_1...) Insert into rep_info values(col_1,col_2,P_2...) Insert into rep_info values(col_1,col_2,P_3...) Insert into rep_info values(col_1,col_2,P_4...)
Well....Younus thanks for your suggestion...
May be we should open this for another possible solution.
What you want ?
1. Do you want to insert all parameter in a single record ?
2. Do you want to insert each record for each parameter ?
3. Only those parameter what are not null ?
What your want ?
For point 1 and 2 may follow the Younus example
For point 3
Hope this helps
if :paramert1 is not null then insert into() values(); end if; if :paramer2 is not null then insert into() values(); end if;