demo.sql

来自「由浅入深的介绍JAVAse的基本编程思想」· SQL 代码 · 共 10 行

drop procedure MyProcedure;
drop table person;
create table person(id  number primary key, name char(20), age number);
create or replace procedure MyProcedure (pid in number,name in char,age in char) 
as 
	begin 
		insert into person values(pid,name,age); 
	end;
/