代码搜索：sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/183260/9173925
sql exceptioninit.sql
REM ExceptionInit.sql
REM Chapter 7, Oracle9i PL/SQL Programming by Scott Urman
REM This block illustrates the EXCEPTION_INIT pragma.
DELETE FROM log_table;
DECLARE
e_MissingNull EXCEPTION;
www.eeworm.com/read/183260/9173926
sql outofscope.sql
REM OutOfScope.sql
REM Chapter 7, Oracle9i PL/SQL Programming by Scott Urman
REM This example illustrates the scope of exceptions.
BEGIN
DECLARE
e_UserDefinedException EXCEPTION;
BEGIN
www.eeworm.com/read/183260/9173927
sql nodatafound.sql
REM NoDataFound.sql
REM Chapter 7, Oracle9i PL/SQL Programming, by Scott Urman
REM This block will raise the NO_DATA_FOUND exception.
DECLARE
TYPE t_NumberTableType IS TABLE OF NUMBER
IND
www.eeworm.com/read/183260/9173928
sql sqlerrm.sql
REM SQLERRM.sql
REM Chapter 7, Oracle9i PL/SQL Programming by Scott Urman
REM This block shows the behavior of the SQLERRM function.
set serveroutput on
BEGIN
DBMS_OUTPUT.PUT_LINE('SQLERRM(
www.eeworm.com/read/183260/9173929
sql valueerror.sql
REM ValueError.sql
REM Chapter 7, Oracle9i PL/SQL Programming by Scott Urman
REM This example raises the VALUE_ERROR exception in two different
REM ways.
DECLARE
v_TempVar VARCHAR2(3);
BEGIN
www.eeworm.com/read/183260/9173930
sql duplicatehandlers.sql
REM DuplicateHandlers.sql
REM Chapter 7, Oracle9i PL/SQL Programming by Scott Urman
REM This example illustrates the PLS-483 error.
DECLARE
-- Declare 2 user defined exceptions
e_Exception1
www.eeworm.com/read/183260/9173931
sql register.sql
REM Register.sql
REM Chapter 7, Oracle9i PL/SQL Programming by Scott Urman
REM This procedure illustrates the use of RAISE_APPLICATION_ERROR.
/* Registers the student identified by the p_StudentI
www.eeworm.com/read/183260/9173934
sql errorpkg.sql
REM ErrorPkg.sql
REM Chapter 7, Oracle9i PL/SQL Programming by Scott Urman
REM This file illustrates a more advanced error handling package.
set serveroutput on size 200000
set linesize 250
-
www.eeworm.com/read/183260/9173936
sql commit.sql
REM commit.sql
REM Chapter 6, Oracle9i PL/SQL Programming by Scott Urman
REM This block will raise "ORA-1002: fetch out of sequence" because
REM of the commit inside the SELECT..FOR UPDATE loop.
www.eeworm.com/read/183260/9173938
sql whileloop.sql
REM WhileLoop.sql
REM Chapter 6, Oracle9i PL/SQL Programming by Scott Urman
REM This block illustrates a WHILE cursor fetch loop.
DECLARE
-- Cursor to retrieve the information about History st