代码搜索:sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/183260/9173878
sql almostfull.sql
REM AlmostFull.sql
REM Chapter 9, Oracle9i PL/SQL Programming by Scott Urman
REM This script demonstrates a stored function.
CREATE OR REPLACE FUNCTION AlmostFull (
p_Department classes.depart
www.eeworm.com/read/183260/9173880
sql nocopytest.sql
REM NoCopyTest.sql
REM Chapter 9, Oracle8i Advanced PL/SQL Programming
REM This procedure illustrates the behavior of the Oracle8i
REM NOCOPY modifier.
CREATE OR REPLACE PROCEDURE NoCopyTest (
www.eeworm.com/read/183260/9173882
sql tconstruct.sql
REM tConstruct.sql
REM Chapter 8, Oracle9i PL/SQL Programming by Scott Urman
REM This block illustrates nested table constructors.
DECLARE
TYPE NumbersTab IS TABLE OF NUMBER;
-- Create a
www.eeworm.com/read/183260/9173884
sql collectionloops.sql
REM collectionLoops.sql
REM Chapter 8, Oracle9i PL/SQL Programming by Scott Urman
REM This block demonstrates FIRST, LAST, NEXT, and PRIOR.
set serveroutput on
DECLARE
TYPE CharTab IS TABLE
www.eeworm.com/read/183260/9173886
sql library.sql
REM Library.sql
REM Chapter 8, Oracle9i PL/SQL Programming by Scott Urman
REM This package demonstrates operations on stored nested tables.
CREATE OR REPLACE PACKAGE Library AS
-- Prints out t
www.eeworm.com/read/183260/9173888
sql printrequired.sql
REM PrintRequired.sql
REM Chapter 8, Oracle9i PL/SQL Programming by Scott Urman
REM This procedure illustrates how to query a stored varray.
CREATE OR REPLACE PROCEDURE PrintRequired(
p_Depart
www.eeworm.com/read/183260/9173890
sql collectiondml.sql
REM collectionDML.sql
REM Chapter 8, Oracle9i PL/SQL Programming by Scott Urman
REM This file contains examples of DML operations on collections.
DECLARE
v_CSBooks BookList := BookList(1000, 1
www.eeworm.com/read/183260/9173891
sql nested.sql
REM nested.sql
REM Chapter 8, Oracle9i PL/SQL Programming by Scott Urman
REM This block illustrates some nested tables.
DECLARE
-- Define a nested table type based on an object type
TYPE Ob
www.eeworm.com/read/183260/9173892
sql vconstruct.sql
REM vConstruct.sql
REM Chapter 8, Oracle9i PL/SQL Programming by Scott Urman
REM This block illustrates some varray constructors.
DECLARE
-- Define a VARRAY type.
TYPE Numbers IS VARRAY(20)
www.eeworm.com/read/183260/9173893
sql extend.sql
REM extend.sql
REM Chapter 8, Oracle9i PL/SQL Programming by Scott Urman
REM This block demonstrates the EXTEND collection method.
set serveroutput on
DECLARE
v_NumbersTab NumTab := NumTab(