代码搜索：sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/183260/9173960
sql exitwhen.sql
REM ExitWhen.sql
REM Chapter 6, Oracle9i PL/SQL Programming by Scott Urman
REM This block illustrates the incorrect location of the
REM EXIT WHEN statement.
DECLARE
-- Declare variables to h
www.eeworm.com/read/183260/9173961
sql refcursors.sql
REM RefCursors.sql
REM Chapter 6, Oracle9i PL/SQL Programming by Scott Urman
REM This block illustrates several REF CURSOR declarations.
DECLARE
-- Definition using %ROWTYPE.
TYPE t_Student
www.eeworm.com/read/183260/9173962
sql simpleloop.sql
REM SimpleLoop.sql
REM Chapter 1, Oracle9i PL/SQL Programming by Scott Urman
REM This block contains a simple loop.
DECLARE
v_LoopCounter BINARY_INTEGER := 1;
BEGIN
LOOP
INSERT INTO t
www.eeworm.com/read/183260/9173963
sql roomspkg.sql
REM RoomsPkg.sql
REM Chapter 1, Oracle9i PL/SQL Programming by Scott Urman
REM This script contains a PL/SQL package.
CREATE OR REPLACE PACKAGE RoomsPkg AS
PROCEDURE NewRoom(p_Building rooms.b
www.eeworm.com/read/183260/9173964
sql cursorloop.sql
REM CursorLoop.sql
REM Chapter 1, Oracle9i PL/SQL Programming by Scott Urman
REM This block illustrates a cursor fetch loop.
DECLARE
v_FirstName VARCHAR2(20);
v_LastName VARCHAR2(20);
-
www.eeworm.com/read/183260/9173966
sql error.sql
REM Error.sql
REM Chapter 1, Oracle9i PL/SQL Programming by Scott Urman
REM This block illustrates some of the error-handling features
REM of PL/SQL.
DECLARE
v_ErrorCode NUMBER; -- C
www.eeworm.com/read/183260/9173968
sql printstudents.sql
REM PrintStudents.sql
REM Chapter 1, Oracle9i PL/SQL Programming by Scott Urman
REM This script illustrates a stored procedure.
set serveroutput on
CREATE OR REPLACE PROCEDURE PrintStudents(
www.eeworm.com/read/183260/9173969
sql numericloop.sql
REM NumericLoop.sql
REM Chapter 1, Oracle9i PL/SQL Programming by Scott Urman
REM This block illustrates a numeric FOR loop.
BEGIN
FOR v_LoopCounter IN 1..50 LOOP
INSERT INTO temp_table (
www.eeworm.com/read/183260/9173971
sql collections.sql
REM Collections.sql
REM Chapter 1, Oracle9i PL/SQL Programming by Scott Urman
REM This block demonstrates some PL/SQL collections.
DECLARE
TYPE t_IndexBy IS TABLE OF NUMBER
INDEX BY BINAR
www.eeworm.com/read/183260/9173973
sql conditional.sql
REM Conditional.sql
REM Chapter 1, Oracle9i PL/SQL Programming by Scott Urman
REM This block illustrates a conditional statement.
DECLARE
v_TotalStudents NUMBER;
BEGIN
-- Retreive the tota