As we have coding standards can someone tell me whether is there any standards for PL/SQL. If so what are the general PL/SQL standard one has to follow to have a good efficient coding.
Printable View
As we have coding standards can someone tell me whether is there any standards for PL/SQL. If so what are the general PL/SQL standard one has to follow to have a good efficient coding.
Hi,
I read various books and i got one gr8 book with having some standards of PL/SQL coding. I am giving you the book detail as i do not have the soft copy of that. I am givin you some of them are
V_VariableNmae Programme Variable
e_ExceptionName User-defined exception
t_TypeName User-defined Type
p_ParameterName Parameter to a Procedure or Function
C_ConstantValue Variable constraines with the CONSTANT clause
Cursor Name c_cursorname
Oracle 9i PL/SQL programming
Author
Scott Urman
hi,
coding standard is like a bible for any company, so we have to follow it.
and u can not follow your own coding standard or any coding standard mentioned in books. these standard differ with company. u will be given the document regrding coding standard and that u have to follow.
i do not think that there is any standard answer for this question.
if practising at home, just make sure that code should be legible to read. and if anyone is having a look at your code, is in a position to undertand the begin and end of each piece of code.
regards
RSY
hi,
What Mr. Raghav said, its 100% correct.
Dont worry abt the coding standards.