Important SQL Queries

select * from v$version;

-- Gives Oracle Database version + Procedural Language for SQL Release +CORE+Transparent Network Substrate+National Language Support Run Time Library Version


Select * from v$database;

-- Gives DBID, NAME, CREATED, RESETLOGS_CHANGE etc...

Select * from all_tables;

-- table which stores tables in db


Select * from all_tab_coulmns;
-- table which gives columns of all tables

Select * from all_source;
-- Gives OWNER, NAME, Type of Object, Line and text of every object in DB


select * from all_views;

--table which gives all views in DB


 select * from all_users;

-- table gives all users in DB