Syntax of the Create Package
CREATE OR REPLACE PACKAGE [body] packagename IS
END;
Sample:
CREATE OR REPLACE PACKAGE overloaded IS
PROCEDURE insby(namein VARCHAR2);
PROCEDURE insby(numbin PLS_INTEGER);
END overloaded;
/
CREATE OR REPLACE PACKAGE BODY overloaded IS
--==========================================
PROCEDURE local(namein VARCHAR2, nameout OUT VARCHAR2) IS
BEGIN
nameout := TRANSLATE(namein,'AEIOUaeiou','EIOUAeioua');
END local;
--==========================================
PROCEDURE insby (namein VARCHAR2) IS
x PLS_INTEGER;
BEGIN
SELECT MAX(seqno)+1
INTO x
FROM persons;
INSERT INTO persons
(seqno, name)
VALUES
(x, namein);
COMMIT;
END insby;
--==========================================
PROCEDURE insby (numbin PLS_INTEGER) IS
x VARCHAR2(30);
BEGIN
SELECT MAX(name)
INTO x
FROM persons;
local(x, x);
INSERT INTO persons
(seqno, name)
VALUES
(numbin, x);
COMMIT;
END insby;
--==========================================
END overloaded;
/
exec overloaded.insby('Helen Lofstrom');
exec overloaded.insby(4);
Syntax of the Drop Package
DROP PACKAGE [BODY] [schema.]package_name;
Sample:
DROP PACKAGE INV.INV_TRANSFER_ORDER_PVT;
DROP PACKAGE BODY INV.INV_TRANSFER_ORDER_PVT;
转载请注明出处:http://blog.csdn.net/pan_tian/article/details/7754847
===EOF===
分享到:
相关推荐
Server-side PL/SQL is stored and compiled in the Oracle Database and runs within the Oracle executable. With this guide Oracle developers can work towards accomplishing Oracle 11g Advanced PL/SQL ...
Create/Drop/Alter Stored Procedures, Functions, Views and Triggers. HTTP and SSH Tunneling - smartly manage your MySQL server even if the MySQL port is blocked or remote access to MySQL is disallowed...
解决OracleRAC集群下创建SDE时报Stored procedures错误问题 环境:Oracle11.2.0.3 两节点RAC集群,windows server2008R2,FCSAN共享存储,ArcGIS Desktop 1031
Programming Oracle Triggers And Stored Procedures 英文第三版 自制CHM格式,可DropDownList选章选节阅读,可调节字体大小,大大方便了Viliv S5等手持上网设备的阅读。 注意: 由于内部使用了MS XML Parser,本...
Oracle Database 11g Administration Workshop II (数据库管理-课堂练习II 学生指南第3册)
oracle练习题,Oracle基础知识。oracle练习题,Oraoracle练习题,Oracle基础知识。cle基础知识。
存储过程(Stored Procedure)是一组为了完 成特定功能的 SQL 语句集,经编译后存储在数据库中。用户通过指定存储过程的名字并给 出参数(如果该存储过程带有参数)来执行它。存储过程是数据库中的一个重要对象,...
Oracle9i Java Stored Procedures Developer’s Guide Release 2 (9.2)
(prentice hall 2003) - programming oracle triggers and stored procedures, 3rd ed.rar
to set, less compiler configuration, the object code stored in the database, and compatibility with Oracle Real Application Clusters environments. The FORALL statement can handle associate arrays and ...
Oracle8i Java Stored Procedures Developer’s Guide Release 2 (8.1.6)
w Access your stored packages easily through the TOraclePackage component or the Package Wizard w Encapsulation of standard Oracle packages (dbms_alert, dbms_job, utl_file, ...) w Many Oracle ...
The implementation of stored procedures in MySQL 5.0 a huge<br/>milestone -- one that is expected to lead to widespread enterprise adoption of<br/>the already extremely popular MySQL database....
Oracle PL/SQL从入门到精通 配书教学视频 第11章
Cache = require('promise-cache').create() 将项目存储在缓存中 Cache . put ( 'key' , 'value' , 20 ) ; // will be stored for 20 seconds. Cache . forever ( 'other' , 'thing' ) ; // will be stored ...
用于执行Oracle存储过程的SpringBoot演示项目前提条件这需要Oracle DB。 请按照以旋转Oracle docker映像。 或者,您可以使用 ... 必须明确设置以下JPA属性spring : application : name : spring-oracle-stored-proc
Stored Programs Synonyms Privileges Roles Profiles Chapter 4 The Oracle Data Dictionary Creating and Maintaining the Data Dictionary The Data Dictionary Views About SQL.BSQ Views Used for ...
Oracle Objects for OLE (OO4O) is a product designed to allow easy access to data stored in Oracle databases using any programming or scripting language that supports the Microsoft ...
基本用法示例: package myappimport ( "fmt" "github.com/edge/atomicstore")func main () { // Value can be any type v := "value" // Create lockable store store := atomicstore . New ( true ) // Insert ...
For this server, dbExpress provides a driver as an independent library that implements the common dbExpress interface for processing queries and stored procedures. As data-access layer is thin and ...