The case preference of writing SQL, PL/SQL, SQL*PLUS comands/scripts

Dear all,

In Oracle PL/SQL training merterial, upper cases are used for key words, while lower cases for variable names (ex.1); but in many books about Oracle the reverse are used (ex.2).

(ex.1)

CREATE OR REPLACE FUNCTION sf_age
(i_date IN DATE)

RETURN NUMBER
IS

    v_year1 NUMBER;
    v_year2 NUMBER;
BEGIN
    v_year1 := TO_NUMBER(TO_CHAR(SYSDATE,'yyyy'));     v_year2 := TO_NUMBER(TO_CHAR(i_date,'yyyy'));     RETURN v_year1 - v_year2;
END;
/

(ex.2)

create or replace function SF_AGE
(I_DATE in date)

return number
is

    V_YEAR1 number;
    V_YEAR2 number;
begin

    V_YEAR1 := to_number(to_char(sysdate,'YYYY'));     V_YEAR2 := to_number(to_char(I_DATE,'YYYY'));     return V_YEAR1 - V_YEAR2;
end;
/

Which one is the proper usage? Thanks for your comments.

Dino Received on Sat Jun 02 2001 - 05:32:29 CDT