LIST of SQL For DBA. 

1. How to find the Database Version with Banner :?  

    Select * from v$version@DB;

2. How to find the Database Version only? 

   SELECT version FROM V$INSTANCE@DB;

3.  Datasheet for Oracle Release Nomenclature. 




4. Find DBA_Tablespace.

select * from DBA_TABLESPACES;

select * from USER_TABLESPACES;
select * from V$TABLESPACE;
select * from V$session where username='HR';
select last_name, job_id, department_id, hire_date, employee_id, salary*12  Annsal from  employees order by department_id, Annsal desc;

SELECT employee_id, last_name, job_id,&column_name
FROM employees
WHERE &condition
ORDER BY &order_column ;
SELECT employee_id, last_name, job_id,&column_name
FROM employees
WHERE &condition
ORDER BY &order_column ;