I have a table named Test_tbl with about 50 columns in it. 25 columns name start with "INFO_" and rest 25 with "DTL_".
In my project, I use this table 100 times but with the dynamic query to select or update records by mentioning each column name every time.
Is there any way to put the like condition on the column's name of a table. So, we can manage this kind of data/table structure easily.
Something like this:
SELECT COLUMN_NAME LIKE 'INFO_%' FROM TEST_TBL
SELECT * FROM TEST_TBL WHERE INFORMATION_SCHEMA.COLUMN_NAME LIKE 'INFO_%'