Study With Rafiq

-- Create object type create or replace TYPE TYP_SIMPLE_ORDER AS OBJECT (     ANIMAL_ID       NUMBER,     SUPPLIER_ID    NUMBER,     ANIMAL_TYPE   VARCHAR2(20),     BUYING_PRICE  NUMBER,     STATUS             VARCHAR2(20) ); -- Create table type C…

create or replace function         GET_EXPENSE_DTL (in_type in varchar2,in_id in number) return varchar2 is v_name varchar2(256); begin  if in_type  = 'AMOUNT' then SELECT SUM(AMOUNT) AMOUNT INTO V_NAME    from EXPENSE_DTL  where EXPENSE_MST_…

================ Package Specification ======================= Create or Replace Package OVERLOADING_PACKAGE AS    PROCEDURE DISPLAY_Result (p_lower IN NUMBER, p_upper IN NUMBER);     PROCEDURE DISPLAY_Result ( V1 IN NUMBER, V2 IN NUMBER, V3 IN NU…

Note : Shipping plan and Stuffing plan table structure almost same. Processes ======= declare  v_mst_id number ; v_STUFFING_PLAN_ID varchar2(50); begin  FOR i in 1.. apex_application.g_f01 .count  LOOP if apex_application.g_f01(i) is not null then …

CREATE   OR   REPLACE   TRIGGER  "Update_house_TRG"  BEFORE   INSERT   OR   UPDATE ON  CONSOL_DTL REFERENCING   NEW   AS   New   OLD   AS   Old FOR   EACH   ROW DECLARE   MAX_FROMDATE  DATE ; MIN_FROMDATE  DATE ; BEGIN   IF  INSERTING  THE…

CREATE OR REPLACE FUNCTION F_WORKING_TIME    (START_TIME    VARCHAR2,   END_TIME   VARCHAR2)    RETURN   VARCHAR2  IS    V_TIME_IN                 NUMBER(10);    V_TIME_OUT                NUMBER(10);    VHH                       VARCHAR2(8);    VMM …

About PL/SQL About PL/SQL :   • Stands for “Procedural Language extension to SQL”  • Is Oracle Corporation’s standard data access language for relational databases  • Seamlessly integrates procedural constructs with SQL           Benefits of PL/SQL :…