HI Tim,
Thank you for your help. Yes that is what I mean. I need to grab the name of the column (I know I can have it in ALL_TAB_COLUMNS) and its value. My problem is that I need to normalize a denormalized table. The column of the denormalized table has the products attributes (qty, price) in the name of the column (MyProd1_Price, MyProd1_Qty). I need to evaluate the name of the product (name of te column) and the values of qty and price and insert them into a normalized table.
The only way I could do it for the moment is to hardcode all 22 products names and attribute and do 22 inserts by row fetched by the main cursor. If I was using something like ADO, I would be able to write MyRec(1).name (would give me the name of the product) and MyRec(1).Value for the qty and MyRec(2).Value for the price. And so on ofr the 22 products. I would know that the product have changed when MyRec(n).name change.
Is it possible to replicate the same mechanic in PL/SQL?
Thank you,
Christian
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only