Hi Team,
Good Morning
SELECT table_name,
LISTAGG (DISTINCT column_name, ',')
WITHIN GROUP (ORDER BY column_name)
columns_available_in_the_table
FROM all_tab_cols where owner='ADMIN' and table_name= ''''||upper(&table_name)||''''
GROUP BY table_name;
ORA-00904: "SUPER_RR": invalid identifier
SELECT table_name,
LISTAGG (DISTINCT column_name, ',')
WITHIN GROUP (ORDER BY column_name)
columns_available_in_the_table
FROM all_tab_cols where owner='ADMIN' and table_name='SUPER_RR'
GROUP BY table_name;
this is working fine.
how to deal with a single quote here?