To find the column name from data dictionary Sql Server
SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME LIKE '%COLUMNNAME%';
Oracle Db
SELECT * FROM ALL_TAB_COLUMNS WHERE COLUMN_NAME LIKE '%column%;
Tutorial for Denodo,OBIEE 11g, SQL, PLSQL, Datawarehousing beginners.
Useful Queries
To find the column name from data dictionary
Sql Server
SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME LIKE '%COLUMNNAME%';
Oracle Db
SELECT * FROM ALL_TAB_COLUMNS WHERE COLUMN_NAME LIKE '%column%;
SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME LIKE '%COLUMNNAME%';
Oracle Db
SELECT * FROM ALL_TAB_COLUMNS WHERE COLUMN_NAME LIKE '%column%;
Subscribe to:
Posts (Atom)
Featured post
Snowflake - Creating warehouse in Snowflake
Creating warehouse Login to Snowflake and click on warehouse and click on Create fill the necessary details and click Finish We can also c...
-
We can use call NQS_GetAllCacheEntries(); command to get all the cache entries available in server. steps to use: 1. Login to analytics as... -
We can use call NQS_GetAllCacheEntries(); command to get all the cache entries available in server. steps to use: 1. Login to analyt...
-
Variable Description USER Holds the value the user enters as his or her logon name. Thi...