CONSTANT in PLSQL

Rumesh Aponso (RMAX)

Nov 15, 20241 min read

Updated: Nov 22, 2024

DECLARE
   HUNDRED_     CONSTANT VARCHAR2(15) := 'hundred';
   HUNDRED_NUM_ CONSTANT NUMBER       := 100;
BEGIN
   Dbms_Output.Put_Line(HUNDRED_);
   Dbms_Output.Put_Line(HUNDRED_NUM_);
END;

Output:

See All

LISTAGG in PLSQL

Example 1: SELECT DISTINCT LISTAGG(t.commission_receiver, ';') WITHIN GROUP (ORDER BY t.commission_receiver) FROM...

Get Foundation Error from ORA Error

FUNCTION Strip_Ora_Error ( sqlerrm_ IN VARCHAR2, sqlcode_ IN NUMBER DEFAULT NULL, strip_ora_only_ IN BOOLEAN DEFAULT...

CONNECT BY PRIOR / Hierarchical Queries / Query Tree Structure

Example 1: SELECT handling_unit_id, t.shipment_id FROM handling_unit_tab t START WITH handling_unit_id = '4558' CONNECT BY PRIOR...

CONSTANT in PLSQL

Related Posts

Comments