代码搜索:SqL
找到约 10,000 项符合「SqL」的源代码
代码结果 10,000
www.eeworm.com/read/183260/9173906
sql vassign.sql
REM vAssign.sql
REM Chapter 8, Oracle9i PL/SQL Programming by Scott Urman
REM This file illustrates legal and illegal varray assignments.
DECLARE
TYPE Strings IS VARRAY(5) OF VARCHAR2(10);
www.eeworm.com/read/183260/9173908
sql extenddelete.sql
REM extendDelete.sql
REM Chapter 8, Oracle9i PL/SQL Programming by Scott Urman
REM This block demonstrates the interaction between EXTEND and DELETE.
set serveroutput on
DECLARE
-- Initiali
www.eeworm.com/read/183260/9173910
sql typelocation.sql
REM typeLocation.sql
REM Chapter 8, Oracle9i PL/SQL Programming by Scott Urman
REM This file contains examples of different locations for
REM collection types.
-- Create a stored type which is v
www.eeworm.com/read/183260/9173911
sql indexby.sql
REM indexBy.sql
REM Chapter 8, Oracle9i PL/SQL Programming by Scott Urman
REM This file contains several examples of index-by tables.
DECLARE
TYPE NameTab IS TABLE OF students.first_name%TYPE
www.eeworm.com/read/183260/9173913
sql trim.sql
REM trim.sql
REM Chapter 8, Oracle9i PL/SQL Programming by Scott Urman
REM This block shows the TRIM collection method.
set serveroutput on
DECLARE
-- Initialize a table to 7 elements.
v
www.eeworm.com/read/183260/9173915
sql multilevel.sql
REM multilevel.sql
REM Chapter 8, Oracle9i PL/SQL Programming by Scott Urman
REM This block illustrates multilevel collections.
DECLARE
-- First declare an index-by table of numbers
TYPE t_
www.eeworm.com/read/183260/9173917
sql libraryoperator.sql
REM LibraryOperator.sql
REM Chapter 8, Oracle9i PL/SQL Programming by Scott Urman
REM This version of the Library package uses the TABLE operator
REM to manipulate individual elements of the nested
www.eeworm.com/read/183260/9173919
sql tabobject.sql
REM tabObject.sql
REM Chapter 8, Oracle9i PL/SQL Programming by Scott Urman
REM This block shows an index-by table of an object type.
CREATE OR REPLACE TYPE MyObject AS OBJECT (
field1 NUMBER,
www.eeworm.com/read/183260/9173921
sql userdefined.sql
REM UserDefined.sql
REM Chapter 7, Oracle9i PL/SQL Programming by Scott Urman
REM This example illustrates user defined exceptions.
-- This block may raise the exception, but does not handle it.
www.eeworm.com/read/183260/9173923
sql dupvalonindex.sql
REM DupValOnIndex.sql
REM Chapter 7, Oracle9i PL/SQL Programming by Scott Urman
REM This block will raise the DUP_VAL_ON_INDEX exception.
BEGIN
INSERT INTO students (id, first_name, last_name)