代码搜索：sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/241364/13150607
sql serialpkg.sql
/* Formatted on 2002/04/06 08:41 (Formatter Plus v4.5.2) */
CREATE OR REPLACE PACKAGE book_info
IS
PRAGMA SERIALLY_REUSABLE;
PROCEDURE fill_list;
PROCEDURE show_list;
END;
/
CRE
www.eeworm.com/read/241364/13150625
sql recompile.sql
/* Formatted by PL/Formatter v2.0.8.0 on 1999/07/20 01:24 (01:24 AM) */
-- _____________________________________________________________________
-- | |
-- | Recompile Utility |
-- |_
www.eeworm.com/read/241364/13150690
sql xmltype.sql
/* Formatted on 2002/04/02 07:15 (Formatter Plus v4.5.2) */
DROP TABLE env_analysis;
CREATE TABLE env_analysis (
company VARCHAR2(100),
site_visit_date DATE,
report xmltype);
INSERT
www.eeworm.com/read/241364/13150696
sql mac.sql
declare
l_in_val varchar2(2000) := 'CriticalData';
l_key varchar2(2000) := '1234567890123456';
l_mac raw(2000);
begin
l_mac := dbms_crypto.mac (
src => UTL_I18N.STRING_TO_RAW (l
www.eeworm.com/read/241364/13150725
sql pssize.sql
SET PAGESIZE 66
COLUMN name FORMAT A30
COLUMN type FORMAT A15
COLUMN source_size FORMAT 999999
COLUMN parsed_size FORMAT 999999
COLUMN code_size FORMAT 999999
TTITLE 'Size of PL/SQL Objects > &&
www.eeworm.com/read/241364/13150746
sql anyobject.sql
/*
| IN THIS SCRIPT:
| create_a_type -- returns a transient object type
| create_an_instance -- returns an instance of the type
| grok_anydata -- shows how one might interpret the instanc
www.eeworm.com/read/241364/13150751
sql undroppable.sql
CREATE OR REPLACE TRIGGER undroppable
BEFORE DROP ON SCHEMA
BEGIN
RAISE_APPLICATION_ERROR(-20000,'You cannot drop me! I am invincible!');
END;
/
/*=========================================
www.eeworm.com/read/241364/13150766
sql cast.sql
/* Formatted on 2002/02/11 08:20 (Formatter Plus v4.6.0) */
DROP TYPE authors_t force;
DROP TYPE names_t force;
DROP table favorite_authors;
CREATE TYPE names_t AS TABLE OF VARCHAR2 (100);
/
www.eeworm.com/read/241364/13150774
sql autonfail.sql
CREATE OR REPLACE PROCEDURE autonfail
IS
PRAGMA AUTONOMOUS_TRANSACTION;
BEGIN
DELETE FROM emp;
END;
/
BEGIN
autonfail;
END;
/
/*===============================================
www.eeworm.com/read/241364/13150783
sql utlflexc.sql
--
-- This code helps you....
--
-- - Remember to close those files when you are done or when an error
-- finishes you prematurely.
--
-- - Identify which error caused the problem. Prior