Results 1 to 4 of 4

Thread: Coding with PL/SQL

  1. #1
    Contributing Member
    Join Date
    Jul 2006

    Smile Coding with PL/SQL

    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.

  2. #2
    Junior Member
    Join Date
    Feb 2007

    Re: Coding with PL/SQL

    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
    Scott Urman

  3. #3
    Contributing Member
    Join Date
    Jan 2007

    Re: Coding with PL/SQL


    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.


  4. #4
    Junior Member
    Join Date
    Mar 2007

    Re: Coding with PL/SQL


    What Mr. Raghav said, its 100% correct.

    Dont worry abt the coding standards.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.