Constant in variable declaration:
========================
Declare
DOB date:=’22-Dec-2015′;
Begin
DOB:=’23-Dec-2015′;
dbms_output.put_line(DOB);
end;
Declare
DOB constant date:=’22-Dec-2015′;
Begin
–DOB:=’23-Dec-2015′;
dbms_output.put_line(DOB);
end;
————————————————————-
Not Null in variable declaration
Declare
DOB date not null:=’22-Dec-2015′;
Begin
–DOB:=’23-Dec-2015′;
–DOB:=null;
dbms_output.put_line(DOB);
end;
————————————————————–
SELECT statement in PLSQL block
select column into variable from table where condition;
————————————————————–
DML
Insert update delete commit rollback;
—————————————————————
IF Statement
If condition then
statement;
end if;
—————————————————————-
IF condition1 THEN
[statements to execute when condition1 is TRUE…]
ELSE
[statements to execute when condition1 is FALSE]
END IF;
———————————————————————
IF condition1 THEN
[statements to execute when condition1 is TRUE…]
ELSIF condition2 THEN
[statements to execute when condition2 is TRUE…]
ELSE
[statements to execute when both condition1 and condition2 are FALSE]
END IF;
—————————————————-
declare
a boolean:=False;
begin
if a then
dbms_output.put_line(‘The condition is true’);
else
dbms_output.put_line(‘The condition is false’);
end if;
end;
————————————————————————-
DECLARE
a boolean := true;
b boolean := false;
BEGIN
IF (a AND b) THEN
dbms_output.put_line(‘Line 1 – Condition is true’);
else
dbms_output.put_line(‘Line 2 – Condition is true’);
END IF;
END;
————————————————————————-
DECLARE
a boolean := true;
b boolean := false;
BEGIN
IF (a AND b) THEN
dbms_output.put_line(‘Line 1’);
END IF;
IF (a OR b) THEN
dbms_output.put_line(‘Line 2’);
END IF;
IF (NOT a) THEN
dbms_output.put_line(‘Line 3’);
ELSE
dbms_output.put_line(‘Line 4’);
END IF;
IF (NOT b) THEN
dbms_output.put_line(‘Line 5’);
ELSE
dbms_output.put_line(‘Line 6’);
END IF;
END;
—————————————————————————-
Declare
C number:=0;
begin
loop
dbms_output.put_line(‘Oracle PLSQL’);
C:=C+1;
exit when C=5;
end loop;
end;
—————————————————————————–