Category: PL/SQL

The PL/SQL Add_Months function is a powerful date manipulation function available in Oracle Database. It allows you to add or subtract a specified number of months to a given date, resulting in a new date. Syntax The syntax of the Add_Months...

Oracle PL/SQL Examples Alter Table As Case Commit Count Create Table Decode Delete Drop Table Exists Exit Fetch For Loop Goto If-Then-ElsIf-Else Inner Join Instr Lock Table Non Equi-Join Outer Join Rollback to savepoint Select Into Self-Join Set Transaction SQLCODE SQLERRM...

Oracle PL/SQL With Connect By Example With Connect By Example CREATE TABLE employees ( name VARCHAR2(25), department NUMBER(2)); INSERT INTO employees VALUES ('ANDY',4); INSERT INTO employees VALUES ('KATE',2); INSERT INTO employees VALUES ('ANNA',1); INSERT INTO employees VALUES ('GERARD',2); INSERT INTO employees...

Oracle PL/SQL With Example With Example 1: WITH test AS ( SELECT 1 result FROM DUAL UNION ALL SELECT 2 FROM DUAL UNION ALL SELECT 7 FROM DUAL UNION ALL SELECT 10 FROM DUAL UNION ALL SELECT 37 FROM DUAL UNION...

Oracle PL/SQL While Loop DECLARE i integer := 5; BEGIN i := 0; WHILE i < 10 LOOP i := i + 1; DBMS_OUTPUT.PUT_LINE(i); END LOOP; END;...