PL/SQL Cheatsheet

PL/SQL Syntax for reference Basic PL/SQL block DECLARE –variable declarations go here BEGIN –program logic goes here END; Functions – Named pl/sql blocks mainly used for computation and not for write operations. They return value to the caller as defined in function. CREATE OR REPLACE FUNCTION myFunc( arg1_in IN VARCHAR2, arg2_in VARCHAR2) RETURN BOOLEAN AS RETURN true; END;… Read More PL/SQL Cheatsheet

CAP & ACID

CAP and ACID are two distinct terms that are used often in database world, where ACID is used to define properties of a database and CAP is actually used to determine distributed systems nature. ACID stands for Atomicity Consistency Isolation Durability Before going into the meaning of these terms one should be fairly aware of… Read More CAP & ACID