Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

dynamic sql - i have column name and table as values in table need to update the results in the same

User_1L8R0Jun 13 2020 — edited Jun 17 2020

Hi,

I have table like below

TABLE XX_TEMP_DATA :

SRC_TBL_NAME            SRC_COL_NAME       CURRENT_VAL            SOURCE_VAL

XX_TBL_1                           COL1                             100                  

XX_TBL_1                           COL2                             ABC

XX_TBL_1                           COL3                             XYZ

XX_TBL_2                           COL8                             HAYU

I have a table with source_table_name and source_column name which are acutal database table and columns. I need to exectue them and populate it in source_val column. could any one advise how to do it ?

Thanks,
Comments
Post Details
Added on Jun 13 2020
27 comments
2,280 views