-
Data Integrity
How does Oracle guarantee data integrity?
-
Catch The Error
SQL>DECLARE 2 dayofweek VARCHAR2(200); 3 BEGIN 4 SELECT TO_CHAR(sysdate,'Day') INTO dayofweek FROM DUAL ; 5 6 IF dayofweek = 'Tuesday' 7 THEN 8 DBMS_OUTPUT.PUT_LINE('Aloha!!! Today Is Tuesday'); 9 ELSE 10 DBMS_OUTPUT.PUT_LINE('Today is '||to_char(sysdate,'Day')); 11 END IF; 12 END; 13 /Today is TuesdayPL/SQL procedure successfully completed.SQL>What's...
-
Debug PL SQL
How can we generate debugging output from PL/SQL?
-
-