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');

Trim Example In Oracle PL/SQL

Trim Character
SELECT TRIM('A' FROM 'AAAHAI') FROM DUAL;
OUTPUT:
HAI

Trim Space
SELECT TRIM(' ' FROM 'I AM THIYAGARAAJ') FROM DUAL;
OUTPUT:
I AM THIYAGARAAJ

Trim Character
SELECT TRIM('A' FROM 'AAI AM THIYAGARAAJAAAA') FROM DUAL;
OUTPUT:
I AM THIYAGARAAJ

Trim Space
SELECT TRIM(' ' FROM '        I AM THIYAGARAAJ   ') FROM DUAL;
OUTPUT:
I AM THIYAGARAAJ

While Loop In Oracle

Syntax WHILE Loop In Orcale
WHILE Contitions
   Loop Statements
END LOOP

While Loop Start With 1 to 10
DECLARE
i NUMBER :=0;
BEGIN
WHILE i < 10 LOOP
i:= i+1;
DBMS_OUTPUT.PUT_LINE('Current Number :'||i);
END LOOP;
END;
/

While Loop Start With 10 to 17
DECLARE
i NUMBER :=10;
BEGIN
WHILE i < 17 LOOP
i:= i+1;
DBMS_OUTPUT.PUT_LINE('Current Number :'||i);
END LOOP;
END;
/

While Loop Start & End With variables value
DECLARE
StartValue NUMBER := 10;
EndValue   NUMBER := 20;
BEGIN
WHILE StartValue < EndValue LOOP
StartValue := StartValue + 1;
DBMS_OUTPUT.PUT_LINE('Current Number :'||StartValue);
END LOOP;
END;
/