PearlJamFanatic
asked on
table name in uppercase
If there a query that i can write that will return the results from either of the query whichever returns rows. The character case of the table name could be in any case and not known to me at design time.
select COLUMN_NAME from all_tab_columns where TABLE_NAME='abcdefg'
select COLUMN_NAME from all_tab_columns where TABLE_NAME='ABCDEFG'
or any other case like 'Abcdefg' or 'AbCdEfg'
this query is to be run in oracle and sybase DBs
select COLUMN_NAME from all_tab_columns where TABLE_NAME='abcdefg'
select COLUMN_NAME from all_tab_columns where TABLE_NAME='ABCDEFG'
or any other case like 'Abcdefg' or 'AbCdEfg'
this query is to be run in oracle and sybase DBs
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
select COLUMN_NAME from all_tab_columns where UPPER(TABLE_NAME) = UPPER('abcdefg')