In Oracle, you can create your own procedures.
The syntax for a procedure is:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
CREATE [OR REPLACE] PROCEDURE procedure_name [ (parameter [,parameter]) ] IS [declaration_section] BEGIN executable_section [EXCEPTION exception_section] END [procedure_name]; |
The following is a simple example of a procedure:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 |
CREATE OR REPLACE Procedure UpdateCourse ( name_in IN varchar2 ) IS cnumber number; cursor c1 is select course_number from courses_tbl where course_name = name_in; BEGIN open c1; fetch c1 into cnumber; if c1%notfound then cnumber := 9999; end if; insert into student_courses ( course_name, course_number ) values ( name_in, cnumber ); commit; close c1; EXCEPTION WHEN OTHERS THEN raise_application_error(-20001,'An error was encountered - '||SQLCODE||' -ERROR- '||SQLERRM); END; |
joss saiki gaweane nggo store prosedure dengan PLSQL
kalau dipakai untuk proses migrasi berarti bisa lebih mudah ya bos ardhitya? untuk proses pemilahan datanya.
Wah ndak tau kalau buat migrasi, wong aku baru belajar kok 😀
Kowe sopo? wani komen ora wani nggo jeneng asli 😛
Kuwi mesti farid, wkwkwk
Hooh nek seko rupa²ne sih parid… saiki ngurusi migrasi dia..
wogh saiki ngeri SQL di coding