ORACLE PLSQL - PROCEDURE

1. CREATE INDEX
2. DECODE
3. TO_CHAR
4. TO_DATE
5. SELECT
6. GRANT
7. INSERT
8. TUNNING
9. UPDATE
10. CREATE USER

PROCEDURE

	CREATE OR REPLACE PROCEDURE p_name (params)
	IS
	   -- Available in Oracle8i and above
	   PRAGMA AUTONOMOUS_TRANSACTION;
	BEGIN
	code...
	   -- Upon successful completion, save all changes.
	   COMMIT;
	EXCEPTION
	   -- For each error handler, don't forget the rollback!
	   WHEN OTHERS 
	   THEN
	      ROLLBACK;   
	END;

	CREATE OR REPLACE PROCEDURE p_desc(p_code in number, p_dest in number) AS
	v_res varchar2(100):='';
	
	BEGIN
	
	SELECT desc INTO v_des
	FROM t_datos
	WHERE code=:p_code;
	
	UPDATE t_dest SET res=:v_res
	WHERE code=:p_code;
	INSERT INTO t_dest (code,res)
		VALUES (p_code,v_res);
	
	END;