oracle-存储过程-命名规则

CREATE OR REPLACE
PROCEDURE "name_rules2" (

	v_sal IN OUT EMPLOYEES.SALARY%type,  --数据类型与员工表salary类型一致

	v_email IN OUT EMPLOYEES.EMAIL%type, 
	
	v_hire_date IN OUT DATE

)
AS
/*
命名规则:
						程序变量 				V_name
						程序常量 				C_Name
						游标变量 				Name_cursor
						异常标识 				E_name
						表类型   			Name_table_type
						表							Name_table
						记录类型	 			Name_record
				SQL*PLUS替代变量		P_name
						绑定变量				G_name

 
*/
	
BEGIN
	-- routine body goes here, e.g.
	-- DBMS_OUTPUT.PUT_LINE('Navicat for Oracle');
	select salary,email,hire_date into v_sal,v_email,v_hire_date from EMPLOYEES where EMPLOYEE_ID = 100;
	dbms_output.put_line(v_sal || ',' || v_email || ',' || v_hire_date);

END;