代码搜索：SqL
找到约 10,000 项符合「SqL」的源代码
代码结果 10,000
www.eeworm.com/read/183260/9173683
sql delete.sql
REM delete.sql
REM Chapter 4, Oracle9i PL/SQL Programming by Scott Urman
REM This block illustrates the DELETE statement.
DECLARE
v_StudentCutoff NUMBER;
BEGIN
v_StudentCutoff := 10;
-
www.eeworm.com/read/183260/9173685
sql insert.sql
REM insert.sql
REM Chapter 4, Oracle9i PL/SQL Programming by Scott Urman
REM This block shows some INSERT statements.
DECLARE
v_StudentID students.id%TYPE;
BEGIN
-- Retrieve a new student
www.eeworm.com/read/183260/9173687
sql nested.sql
REM nested.sql
REM Chapter 3, Oracle9i PL/SQL Programming by Scott Urman
REM This example illustrates 2 nested blocks.
DECLARE
/* Start of declarative section */
v_StudentID NUMBER(5) := 10
www.eeworm.com/read/183260/9173689
sql trigger.sql
REM trigger.sql
REM Chapter 3, Oracle9i PL/SQL Programming by Scott Urman
REM This is an example of a database trigger.
CREATE OR REPLACE TRIGGER OnlyPositive
BEFORE INSERT OR UPDATE OF num_co
www.eeworm.com/read/183260/9173691
sql recordassignment.sql
REM RecordAssignment.sql
REM Chapter 3, Oracle9i PL/SQL Programming by Scott Urman
REM This block shows legal and illegal record assignments.
DECLARE
TYPE t_Rec1Type IS RECORD (
Field1 NU
www.eeworm.com/read/183260/9173695
sql exitwhen.sql
REM exitwhen.sql
REM Chapter 3, Oracle9i PL/SQL Programming by Scott Urman
REM This block illustrates the EXIT WHEN clause.
DECLARE
v_Counter BINARY_INTEGER := 1;
BEGIN
LOOP
-- Insert
www.eeworm.com/read/183260/9173696
sql case.sql
REM case.sql
REM Chapter 3, Oracle9i PL/SQL Programming by Scott Urman
REM This script demonstrates the CASE statement.
set serveroutput on
DECLARE
v_Major students.major%TYPE;
v_CourseN
www.eeworm.com/read/183260/9173698
sql integers.sql
REM integers.sql
REM Chapter 3, Oracle9i PL/SQL Programming by Scott Urman
REM This example shows different integeter types.
DECLARE
v_BinInt BINARY_INTEGER;
BEGIN
-- Assign the maximum va
www.eeworm.com/read/183260/9173699
sql comments.sql
REM comments.sql
REM Chapter 3, Oracle9i PL/SQL Programming by Scott Urman
REM This example demonstrates legal and illegal comments.
DECLARE
v_Department CHAR(3);
v_Course NUMBER;
BE
www.eeworm.com/read/183260/9173701
sql forscope.sql
REM forscope.sql
REM Chapter 3, Oracle9i PL/SQL Programming by Scott Urman
REM This block demonstrates the scope of the index of a FOR LOOP.
DECLARE
v_Counter NUMBER := 7;
BEGIN
-- Insert