//resource code
// procedure 1
create or replace procedure TQ_FirstProc is
classname_value class %rowtype;
begin
select * into classname_value from class where class_id='2';
dbms_output.put_line(classname_value.class_number);
end TQ_FirstProc;
// procedure 2
create or replace procedure TQ_Proc2 is
classname class.class_name%type;
remark class.class_remark%type;
begin
select class.class_name into classname from class where class.class_number = 1003;
if classname = 'Grade one' then
remark := '5 students';
elsif classname = 'Grade two' then
remark := '10 students';
else
remark := '15 students';
end if;
update class set class_remark = remark where class.class_number = 1003;
commit;
end TQ_Proc2;
// procedure 3
create or replace procedure TQ_PROC3 is
num NUMBER(3):=5;
rus number(5):=1;
begin
for i in 1..num loop
rus := rus*i;
end loop;
dbms_output.put_line((rus));
end TQ_PROC3;
分享到:
相关推荐
存储过程(Stored Procedure)是一组为了完 成特定功能的 SQL 语句集,经编译后存储在数据库中。用户通过指定存储过程的名字并给 出参数(如果该存储过程带有参数)来执行它。存储过程是数据库中的一个重要对象,...
Using Informatica Stored Procedure Transformation
学习使用存储过程(Stored Procedure),是ASP程序员的必须课之一。所有的大型数据库SPAN>都支持存储过程,比如Oracle、MS SQL等,(但MS Access不支持,不过,在Access里可以使用参数化的查询)
The implementation of stored procedures in MySQL 5.0 ... This book, destined to be the bible of stored procedure development, is a resource that no real MySQL programmer can afford to do without.
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 ...
解决OracleRAC集群下创建SDE时报Stored procedures错误问题 环境:Oracle11.2.0.3 两节点RAC集群,windows server2008R2,FCSAN共享存储,ArcGIS Desktop 1031
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 ...
sybase stored procedure
mysql存储过程方面的圣经,以通俗的示例方法讲述mysql存储过程的深奥内容,In MySQL Stored Procedure Programming, they put that hard-won experience to good use. Packed with code examples and covering ...
Standards for the Oracle Security Server Standards for Employees Sample Security Plan Index Sample Security Plan Checklist Chapter 8 Installing and Starting Oracle Segmenting Application ...
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 ...
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 ...
Advance Praise for MySQL Stored Procedure Programming Preface Objectives of This Book Structure of This Book What This Book Does Not Cover Conventions Used in This Book Which Version? ...
mysql stored procedure programming PDF version
net下的任何程序集的保密Programs written for the CLR reside in modules. A CLR module is a byte stream, typically stored as a file in the local file system or on a Web server. As shown in Figure 2.1, a...
简单明了的教程,快速入门,强烈推荐。也是735认证考试的材料。
SQL Server 2000 Stored Procedure Programming SQL SERVER 2000存储过程编程,英文版,pdf文件,6M左右,贼清晰
the artists who provided artwork for the art gallery example. They are Elliott Easterling, Laura Blair, Stuart Sheldon, and Todd Brown. Errata and solutions to the labs can be found on the book’s ...
Debugger for MySQL offers a balanced set of advanced debugging features that will help you minimize the time needed for managing and testing even the most complex stored functions and procedures....
For example, a query that requests data generated in the month of October 1994 can scan just the rows stored in the October 1994 partition, rather than rows generated over years of activity....