代码搜索:sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/183260/9173939
sql alreadyopen.sql
REM AlreadyOpen.sql
REM Chapter 6, Oracle9i PL/SQL Programming by Scott Urman
REM This block illustrates the ORA-6511 error.
DECLARE
v_StudentID students.ID%TYPE;
CURSOR c_AllStudentIDs
www.eeworm.com/read/183260/9173943
sql forupdate.sql
REM ForUpdate.sql
REM Chapter 6, Oracle9i PL/SQL Programming by Scott Urman
REM This block illustrates a cursor with a FOR UPDATE clause.
DECLARE
-- Number of credits to add to each student's
www.eeworm.com/read/183260/9173944
sql simpleloop.sql
REM SimpleLoop.sql
REM Chapter 6, Oracle9i PL/SQL Programming by Scott Urman
REM This block demonstrates a simple fetch loop.
DECLARE
-- Declare variables to hold information about the student
www.eeworm.com/read/183260/9173946
sql badfetch.sql
REM BadFetch.sql
REM Chapter 6, Oracle9i PL/SQL Programming by Scott Urman
REM This block illustrates legal and illegal FETCH statements.
DECLARE
v_Department classes.department%TYPE;
v_Co
www.eeworm.com/read/183260/9173948
sql cursorloop.sql
REM CursorLoop.sql
REM Chapter 6, Oracle9i PL/SQL Programming by Scott Urman
REM This block illustrates an explicit cursor fetch loop.
DECLARE
/* Output variables to hold the results of the qu
www.eeworm.com/read/183260/9173950
sql nomatch.sql
REM NoMatch.sql
REM Chapter 6, Oracle9i PL/SQL Programming by Scott Urman
REM This script illustrates the use of cursor attributes on the
REM implicit SQL cursor.
BEGIN
UPDATE rooms
SET
www.eeworm.com/read/183260/9173952
sql nodatafound.sql
REM NoDataFound.sql
REM Chapter 6, Oracle9i PL/SQL Programming by Scott Urman
REM This script illustrates the behavior of the NO_DATA_FOUND
REM exception.
set serveroutput on
DECLARE
-- Re
www.eeworm.com/read/183260/9173954
sql forloop.sql
REM ForLoop.sql
REM Chapter 6, Oracle9i PL/SQL Programming by Scott Urman
REM This block demonstrates a cursor FOR loop.
DECLARE
-- Cursor to retrieve the information about History students
www.eeworm.com/read/183260/9173955
sql parameterized.sql
REM Parameterized.sql
REM Chapter 6, Oracle9i PL/SQL Programming by Scott Urman
REM This block illustrates the declaration of a parameterized cursor.
DECLARE
CURSOR c_Classes(p_Department clas
www.eeworm.com/read/183260/9173956
sql implicitfor.sql
REM ImplicitFOR.sql
REM Chapter 6, Oracle9i PL/SQL Programming by Scott Urman
REM This block demonstrates an implicit FOR loop.
BEGIN
-- Begin the loop. An implicit OPEN is done here.
FOR v