Readability of procedure with naming convention.

[getmeidea]

Hi,

I have a procedure like this

CREATE PROCEDURE get_employee_details(employeerid INT)
BEGIN
select * from employee_master
where employee_id = employeerid;
END;

Here i can distinguish variables in procedure and database objects.
So it gives me poor readability.

Is there any standard way of naming convention applied to variables so that i will be able to understand variables declared within procedure and database objects.

[r035198x]

Hi,

I have a procedure like this



Here i can distinguish variables in procedure and database objects.
So it gives me poor readability.

Is there any standard way of naming convention applied to variables so that i will be able to understand variables declared within procedure and database objects.

Do not double post. It's against the site rules.
Keep this discussion in this thread that you started yesterday.