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

There is no real right or wrong way.
The 'De Fecto' standard seems to be example 1 which I see mostly in books, Oracle website (and i use personally). If you are looking at a company point of view, create a standard and make sure everyone sticks to it.

I could go on forever but no time. Personally, uppercase for Oracle reserved words and keywords, lowercase for variables and other stuff and initcap for Procedure/package calls.

My two pence worth ;-)

M

Dino Hsu <dino1_at_ms1.hinet.net> wrote in message news:<0dfhht44o0un1gea4ri1bglifq6i59dbb0_at_4ax.com>...
> 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 Wed Jun 06 2001 - 05:53:39 CDT