Oracle sql to solve the sql query with select statement in the column list that fetches multiple value -
select * ( select table_name user_tab_cols column_name='contract_number' ) contarct_number ='u5490231'
in select statement, trying list of tables user_tab_cols
,
select * table_name column_name='u5490231'.
trying find select statement on basis getting error
oracle query: v_table nvarchar(max) v_wherecol nvarchar(max) v_whereparam nvarchar(max) v_whereparam := 'contract_number' v_wherecol := 'u5490231' select e.table_name v_table user_tab_cols e e.column_name = v_whereparam v_query nvarchar(max) v_query := 'select * ' || v_table || ' contarct_number =''' || v_wherecol || '''' execute immediate v_query
Comments
Post a Comment