代码搜索:SqL
找到约 10,000 项符合「SqL」的源代码
代码结果 10,000
www.eeworm.com/read/183260/9173780
sql firingorder.sql
REM firingOrder.sql
REM Chapter 11, Oracle9i PL/SQL Programming by Scott Urman
REM This script demonstrates the order of trigger firing.
DROP SEQUENCE trig_seq;
CREATE SEQUENCE trig_seq
STA
www.eeworm.com/read/183260/9173781
sql logrschanges.sql
REM LogRSChanges.sql
REM Chapter 11, Oracle9i PL/SQL Programming by Scott Urman
REM This trigger uses predicates to log changes to the
REM registered_students table.
CREATE OR REPLACE TRIGGER Lo
www.eeworm.com/read/183260/9173785
sql databaseschema.sql
REM DatabaseSchema.sql
REM Chapter 11, Oracle9i PL/SQL Programming by Scott Urman
REM This script demonstrates two system triggers.
-- First create UserA and UserB. You may need to change the
-
www.eeworm.com/read/183260/9173787
sql insteadof.sql
REM insteadOf.sql
REM Chapter 11, Oracle9i PL/SQL Programming by Scott Urman
REM This script demonstrates the use of an Oracle8 instead-of
REM trigger.
CREATE OR REPLACE VIEW classes_rooms AS
www.eeworm.com/read/183260/9173789
sql cascadersinserts.sql
REM CascadeRSInserts.sql
REM Chapter 11, Oracle9i PL/SQL Programming by Scott Urman
REM This trigger cascades inserts into registered_students into
REM classes and students.
CREATE OR REPLACE TR
www.eeworm.com/read/183260/9173790
sql logconnects.sql
REM LogConnects.sql
REM Chapter 11, Oracle9i PL/SQL Programming by Scott Urman
REM These triggers will record all connects and disconnects to/from
REM the database.
CREATE OR REPLACE TRIGGER Lo
www.eeworm.com/read/183260/9173792
sql generatestudentid.sql
REM GenerateStudentID.sql
REM Chapter 11, Oracle9i PL/SQL Programming by Scott Urman
REM These triggers demonstrate the use of the :new correlation
REM identifier.
/* This will fail, since we do
www.eeworm.com/read/183260/9173795
sql mutating.sql
REM mutating.sql
REM Chapter 11, Oracle9i PL/SQL Programming by Scott Urman
REM This script shows how to avoid the mutating table error.
PROMPT StudentData package...
CREATE OR REPLACE PACKAGE S
www.eeworm.com/read/183260/9173797
sql logerrors.sql
REM LogErrors.sql
REM Chapter 11, Oracle9i PL/SQL Programming by Scott Urman
REM This trigger demonstrates the use of
REM DBMS_UTILITY.FORMAT_ERROR_STACK in a SERVERERROR trigger.
DROP TABLE er
www.eeworm.com/read/183260/9173798
sql anonymousdependencies.sql
REM anonymousDependencies.sql
REM Chapter 10, Oracle9i PL/SQL Programming by Scott Urman
REM This package is used to illustrate dependencies between an
REM anonymous calling block and package runti