Geek Answers Handbook

Oracle Stored Procedure Variable Naming Convention

When writing a stored procedure in oracle PL / SQL, there are many naming conventions for writing parameter names.

  • PROCEDURE PROC_MY_STORED_PROCEDURE (sFirstName VARCHAR2, nId NUMBER, oCursor REF_CURSOR)

    PROCEDURE PROC_MY_STORED_PROCEDURE (first_name_in VARCHAR2, Id_in NUMBER, o_Cursor REF_CURSOR)

  • If the prefix of the local variable is leither l_and global with gorg_

Is there any other good naming convention?

What are the best practices.

+5
source share
2 answers

Consistency is the key to naming conventions.
It doesn't matter what you use, as the agreement is always in use. After this documentation if necessary.

, , , . IE: IN: IN_FIRST_NAME; a OUT: OUT_FIRST_NAME, IN OUT IN_OUT_FIRST_NAME. Oracle (32 IIRC), .

+5

, ( ) . , l_ v_ .

: ( ) (, - ). (, _DATEC) . (.. SQL XSS/ HTML).

, IDE . , camelCase.

+9

More articles:


All Articles