代码搜索:SqL
找到约 10,000 项符合「SqL」的源代码
代码结果 10,000
www.eeworm.com/read/183260/9173823
sql defaultpragma.sql
REM DefaultPragma.sql
REM Chapter 10, Oracle9i PL/SQL Programming by Scott Urman
REM This package uses the DEFAULT keyword in the RESTRICT_REFERENCES
REM pragma.
CREATE OR REPLACE PACKAGE Defaul
www.eeworm.com/read/183260/9173824
sql fullname.sql
REM FullName.sql
REM Chapter 10, Oracle9i PL/SQL Programming by Scott Urman
REM This function can be called from a SQL statement.
CREATE OR REPLACE FUNCTION FullName (
p_StudentID students.ID
www.eeworm.com/read/183260/9173826
sql invokers.sql
REM invokers.sql
REM Chapter 10, Oracle9i PL/SQL Programming by Scott Urman
REM This script demonstrates the behavior of Oracle8i invoker's-
REM rights procedures.
set echo on
set serveroutput
www.eeworm.com/read/183260/9173828
sql localsub.sql
REM localSub.sql
REM Chapter 10, Oracle9i PL/SQL Programming by Scott Urman
REM This block demonstrates a local subprogram,
set serveroutput on
DECLARE
CURSOR c_AllStudents IS
SELECT f
www.eeworm.com/read/183260/9173830
sql overload.sql
REM Overload.sql
REM Chapter 10, Oracle9i PL/SQL Programming by Scott Urman
REM This package uses RESTRICT_REFERENCES with overloaded
REM subprograms.
CREATE OR REPLACE PACKAGE Overload AS
FU
www.eeworm.com/read/183260/9173832
sql execute.sql
REM execute.sql
REM Chapter 10, Oracle9i PL/SQL Programming by Scott Urman
REM This script demonstrates the behavior of the EXECUTE system
REM privilege.
set echo on
set serveroutput on
-- F
www.eeworm.com/read/183260/9173834
sql dmlupdate.sql
REM DMLUpdate.sql
REM Chapter 10, Oracle9i PL/SQL Programming by Scott Urman
REM This function can be called from a DML statement in Oracle8i.
CREATE OR REPLACE FUNCTION UpdateTemp(p_ID IN studen
www.eeworm.com/read/183260/9173835
sql forwarddeclaration.sql
REM forwardDeclaration.sql
REM Chapter 10, Oracle9i PL/SQL Programming by Scott Urman
REM This block illustrates a forward declaration.
set serveroutput on
DECLARE
v_TempVal BINARY_INTEGER
www.eeworm.com/read/183260/9173837
sql localstored.sql
REM localStored.sql
REM Chapter 10, Oracle9i PL/SQL Programming by Scott Urman
REM This procedure contains a local subprogram.
set serveroutput on
CREATE OR REPLACE PROCEDURE StoredProc AS
www.eeworm.com/read/183260/9173839
sql mutual.sql
REM mutual.sql
REM Chapter 10, Oracle9i PL/SQL Programming by Scott Urman
REM This example demonstrates mutually exclusive local subprograms.
set serveroutput on
DECLARE
v_TempVal BINARY_IN