代码搜索:SqL
找到约 10,000 项符合「SqL」的源代码
代码结果 10,000
www.eeworm.com/read/183260/9173752
sql nativedynamic.sql
REM NativeDynamic.sql
REM Chapter 12, Oracle9i PL/SQL Programming by Scott Urman
REM This script illustrates the use of native dynamic SQL to
REM process queries.
CREATE OR REPLACE PACKAGE Nati
www.eeworm.com/read/183260/9173758
sql execbind.sql
REM execBind.sql
REM Chapter 12, Oracle9i PL/SQL Programming by Scott Urman
REM This block demonstrates the use of the USING clause with EXECUTE
REM IMMEDIATE to handle bind variables.
DECLARE
www.eeworm.com/read/183260/9173760
sql pointsql.sql
REM PointSQL.sql
REM Chapter 12, Oracle9i PL/SQL Programming by Scott Urman
REM This script demonstrates SQL operations on object types.
DROP TABLE point_object_tab;
CREATE TABLE point_object_
www.eeworm.com/read/183260/9173765
sql pipesend.sql
REM PipeSend.sql
REM Chapter 12, Oracle9i PL/SQL Programming by Scott Urman
REM This block illustrates the use of the DBMS_PIPE package to
REM send a message.
DECLARE
v_PipeName VARCHAR2(30)
www.eeworm.com/read/183260/9173767
sql logcreations.sql
REM LogCreations.sql
REM Chapter 11, Oracle9i PL/SQL Programming by Scott Urman
REM This file contains a system trigger.
DROP TABLE ddl_creations;
CREATE TABLE ddl_creations (
user_id
www.eeworm.com/read/183260/9173769
sql limitmajors.sql
REM LimitMajors.sql
REM Chapter 11, Oracle9i PL/SQL Programming by Scott Urman
REM This trigger will raise an ORA-4091 mutating table error.
CREATE OR REPLACE TRIGGER LimitMajors
/* Limits the
www.eeworm.com/read/183260/9173771
sql classesroomsinstead.sql
REM ClassesRoomsInstead.sql
REM Chapter 11, Oracle9i PL/SQL Programming by Scott Urman
REM This is a complete instead-of trigger.
CREATE OR REPLACE TRIGGER ClassesRoomsInstead
INSTEAD OF INSER
www.eeworm.com/read/183260/9173774
sql samename.sql
REM samename.sql
REM Chapter 11, Oracle9i PL/SQL Programming by Scott Urman
REM This script demonstrates triggers, procedures, and tables with
REM the same name.
-- Legal, since triggers and tab
www.eeworm.com/read/183260/9173775
sql pseudorecords.sql
REM pseudoRecords.sql
REM Chapter 11, Oracle9i PL/SQL Programming by Scott Urman
REM This trigger shows that :old and :new are pseudo-records.
set echo on
CREATE OR REPLACE TRIGGER TempDelete
www.eeworm.com/read/183260/9173777
sql updatemajorstats.sql
REM UpdateMajorStats.sql
REM Chapter 11, Oracle9i PL/SQL Programming by Scott Urman
REM This is an example of a DML trigger.
CREATE OR REPLACE TRIGGER UpdateMajorStats
/* Keeps the major_stats