August 9th, 2013 
Jijo K Jose Display all table names in a database
select * from tab;
Display number of tables in a database
select count(*) from tab;
Find table exits in a database
select * from tab where tname like '%STUDENT%';
Display all column names in a database
select * from USER_TAB_COLUMNS;
Display number of columns in a database
select count(*) from USER_TAB_COLUMNS;
Find column name exits in a database
select * from USER_TAB_COLUMNS where COLUMN_NAME like '%STUDENT_ID%';
Find column name exits on a table in a database
select * from USER_TAB_COLUMNS where TABLE_NAME like '%STUDENT%' and COLUMN_NAME like 'STUDENT_ID';
