orale培训教材包括了所有的sql说明和实例

源代码在线查看: map.sql

软件大小: 30547 K
上传用户: maple_78
关键词: orale sql 培训教材
下载地址: 免注册下载 普通下载 VIP

相关代码

				create or replace procedure insertPart(
				   id number,
				   description varchar2,
				   unitprice number,
				   onhand number,
				   reorder number)
				as
				language java
				name 'Part.insert(
				   oracle.sql.NUMBER,
				   oracle.sql.CHAR,
				   oracle.sql.NUMBER,
				   oracle.sql.NUMBER,   
				   oracle.sql.NUMBER)';
				/
				
				create or replace procedure  updatePart(
				   id number,
				   description varchar2,
				   unitprice number,
				   onhand number,
				   reorder number)
				as
				language java
				name 'Part.update(
				   oracle.sql.NUMBER,
				   oracle.sql.CHAR,
				   oracle.sql.NUMBER,
				   oracle.sql.NUMBER,   
				   oracle.sql.NUMBER)';
				/
				
				create or replace procedure deletePart (id number)
				as
				language java
				name 'Part.delete(oracle.sql.NUMBER)';
				/			

相关资源