![SYNTAX
CREATE [OR REPLACE] PROCEDUREprocedure_name
[(parameter1油[mode]油datatype1,
parameter2油[mode]油datatype2,油)]
IS|AS
[local_variable_declarations;油]
BEGIN
油actions;
END油[procedure_name];](https://image.slidesharecdn.com/it-ppt-template-013-130928230515-phpapp01/85/PBD-Stored-Procedure-3-320.jpg)
More Related Content
Viewers also liked (19)
Similar to PBD- Stored Procedure (20)
Recently uploaded (20)
PBD- Stored Procedure
- 1. STORED PROCEDUREKELOMPOK : 1.Fadlan R. (12410100144) 2.Rendy M. (12410100151) 3.Rr.Aisyah (12410100154) 4.Abu Rizal (12410100155)
- 3. SYNTAX CREATE [OR REPLACE] PROCEDUREprocedure_name [(parameter1油[mode]油datatype1, parameter2油[mode]油datatype2,油)] IS|AS [local_variable_declarations;油] BEGIN 油actions; END油[procedure_name];
- 4. CONTOH CREATE OR REPLACE PROCEDURE油test IS BEGIN DBMS_OUTPUT.PUT_LINE('Procedure油Berhasil油Dibuat'); END;
- 6. Tipe Parameter pada Procedure ada 3 : IN油parameter,油Merupakan油Tipe油parameter油yang油didefinisikan油pada油aktual油 parameter油untuk油kemudian油ditangkap油oleh油formal油parameter.油
- 8. IN OUT油parameter.油Tipe油parameter油yang油digunakan油untuk油mengirimkan油 sebuah油nilai油ke油procedure油yang油kemudian油akan油diproses油dan油dikembalikan油 kepada油si油pemanggil油procedure. Contoh IN OUT Paramater SET SERVEROUTPUT ON CREATE OR REPLACE PROCEDURE油format_phone (phone_no IN OUT VARCHAR2) IS BEGIN phone_no油:=油'('油||油SUBSTR(phone_no,1,3)油||油')'油||SUBSTR(phone_no,4,3)油||油'-'油 ||油SUBSTR(phone_no,7); END油format_phone; / Setelah itu kita buat pemanggil procedurenya DECLARE phone油VARCHAR2(21):='234234ASDA'; BEGIN format_phone(phone油); DBMS_OUTPUT.PUT_LINE(phone); END;