In Oracle, you can create your own procedures.
The syntax for a procedure is:
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:
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