Get Oracle Version ( SQL )

Select Database Version
select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Prod
PL/SQL Release 10.2.0.2.0 - Production
CORE    10.2.0.2.0      Production
TNS for Solaris: Version 10.2.0.2.0 - Production
NLSRTL Version 10.2.0.2.0 - Production  
 


Select Full Product Details
select * from product_component_version;

PRODUCT
----------------------------------------------------------------
VERSION
----------------------------------------------------------------
STATUS
----------------------------------------------------------------
NLSRTL
10.2.0.2.0
Production

Oracle Database 10g Enterprise Edition
10.2.0.2.0
Prod

PRODUCT
----------------------------------------------------------------
VERSION
----------------------------------------------------------------
STATUS
----------------------------------------------------------------

PL/SQL
10.2.0.2.0
Production

TNS for Solaris:
10.2.0.2.0

PRODUCT
----------------------------------------------------------------
VERSION
----------------------------------------------------------------
STATUS
----------------------------------------------------------------
Production




Select Version With Banner

select * from v$version where banner like 'Oracle%';
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Prod



Select Version With Banner

select * from v$version where banner like 'PL/SQL%';
BANNER
----------------------------------------------------------------
PL/SQL Release 10.2.0.2.0 - Production

Create table In Oracle

Table Creation Simple Example

CREATE TABLE Syntax:
CREATE TABLE TABLENAME (
   field1 data_type,
   field2 data_type,
   ...
   ...
   fieldn data_type
)

here,
Consider
Two Fields;
1) E_ID as number
2) E_Name as varchar(20)

CREATE TABLE Example
CREATE TABLE EMPLOYEE
   (
   E_ID NUMBER,
   E_NAME VARCHAR2(20)
   );

Drop In Oracle

Assume table name is EMPLOYEE

DROP TABLE_NAME;
DROP EMPLOYEE;

Count In Oracle / SQL

Assume table name is EMPLOYEE and it has E_NAME Field 


Count All Records In Table

SELECT COUNT(*) FROM EMPLOYEE;

Count All Records In Table with Head Name

SELECT COUNT(*) AS EMPLOYYE_COUNT FROM EMPLOYEE;

Count Column Records In Table

SELECT COUNT(E_NAME) FROM EMPLOYEE;

Count Distinct Column Records In Table

SELECT COUNT(DISTINCT E_NAME) FROM EMPLOYEE;

Count Selected Records In Table

SELECT COUNT(*) FROM EMPLOYEE WHERE CONDITION E_NAME = 'BOND';

Count Selected Records with Head Name

SELECT COUNT(*) FROM EMPLOYEE NAME_BOND WHERE CONDITION E_NAME = 'BOND';

Delete In Oracle / SQL

Assume table name is EMPLOYEE and it has E_NAME Field
Delete All Rows In Tables

DELETE TABLE_NAME;
DELETE EMPLOYEE;

Delete All Rows In Tables

DELETE FROM TABLE_NAME;
DELETE FROM EMPLOYEE;

Delete Selected Rows In Tables

DELETE FROM TABLE_NAME WHERE CONDITION;
DELETE FROM EMPLOYEE WHERE E_NAME = 'RAJU';

Delete through Select Rows In Tables

DELETE FROM (SELECT * FROM TABLE_NAME WHERE CONDITION);
DELETE FROM (SELECT * FROM EMPLOYEE WHERE E_NAME = 'RAJU');