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:
Comments (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...
-
To find the difference between two dates. SELECT DATEDIFF(DAY, '4/29/2019', '6/14/2019'); result : 46 SELECT DATEDIFF(DAY,...
-
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...