代码搜索: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