use sysdate to init a variable : SYSDATE « Date Timezone « Oracle PL / SQL

1. Oracle PL / SQL
2. Date Timezone
3. SYSDATE

use sysdate to init a variable

 
SQL>
SQL> set echo on
SQL>
SQL> DECLARE
  2      v_MyChar VARCHAR2(20) := 'test';
  3      v_NUMBER NUMBER;
  4      V_Date DATE := SYSDATE;
  5      v_counter INTEGER;
  6  BEGIN
  7      DBMS_OUTPUT.PUT_LINE('This is a Test');
  8      DBMS_OUTPUT.PUT_LINE('Of Syntax Error Debugging');
  9      For v_COUNTER IN 1..5 LOOP
 10          DBMS_OUTPUT.PUT_LINE('You are in loop:' || v_counter);
 11      END LOOP;
 12  END;
 13  /
This is a Test
Of Syntax Error Debugging
You are in loop:1
You are in loop:2
You are in loop:3
You are in loop:4
You are in loop:5

PL/SQL procedure successfully completed.

SQL>
SQL>
SQL>
SQL> --

 

Related examples in the same category