select count(*)
from user_tab_columns
where table_name='table name'
Application development and sharing our knowledge to developer to developer for helping knowledge to build a effective solution for web architect.
Sunday, July 13, 2014
How to count the number of columns in a table using SQL?
Thursday, June 5, 2014
How to search column name in all database table in oracle?
How to search column name in all database table in oracle?
SELECT * FROM ALL_TAB_COLUMNS
WHERE COLUMN_NAME LIKE '%COLUMN_NAME%'
SELECT * FROM ALL_TAB_COLUMNS
WHERE COLUMN_NAME LIKE '%COLUMN_NAME%'
Subscribe to:
Posts (Atom)