代码搜索：sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/241364/13150793
sql extprocsh.sql
CREATE OR REPLACE LIBRARY extprocshell_lib AS 'c:\oracle\admin\local\lib\extprocsh.dll';
/
CREATE OR REPLACE PROCEDURE shell(cmd IN VARCHAR2)
AS
LANGUAGE C
LIBRARY extprocshell_lib
NA
www.eeworm.com/read/241364/13150800
sql fixer.sql
DROP TABLE stuff_to_fix;
CREATE TABLE stuff_to_fix
(stuff VARCHAR2(1000),
fixed VARCHAR2(1));
CREATE OR REPLACE PACKAGE fixer AS
PROCEDURE fix_stuff;
PROCEDURE fix_this ( p_thing_to_fix
www.eeworm.com/read/241364/13150807
sql authid.sql
/*
|| Demonstration of AUTHID/Invoker functionality.
|| Author: Steven Feuerstein
|| Date: 2/99
*/
SPOOL authid.log
/* Set up the various accounts. */
SET ECHO ON FEEDBACK ON
CONNECT SYS
www.eeworm.com/read/241364/13150820
sql randbytes.sql
declare
l_key raw(16);
begin
l_key := dbms_crypto.randombytes(16);
end;
/
www.eeworm.com/read/241364/13150834
sql bulktiming.sql
@@plvtmr.pkg
DROP TABLE parts;
CREATE TABLE parts (
partnum NUMBER,
partname VARCHAR2(15)
);
CREATE OR REPLACE PROCEDURE compare_inserting (num IN INTEGER)
IS
TYPE NumTab
www.eeworm.com/read/241364/13150849
sql cantgothere.sql
CALL DBMS_WARNING.SET_WARNING_SETTING_STRING('ENABLE:ALL' ,'SESSION');
CREATE OR REPLACE PROCEDURE cant_go_there
AS
l_salary NUMBER := 10000;
BEGIN
IF l_salary > 20000
THEN
db
www.eeworm.com/read/241364/13150864
sql favorites.sql
/* Formatted on 2002/03/04 10:58 (Formatter Plus v4.6.0) */
DROP table favorites;
CREATE TABLE favorites (
name varchar2(100),
code integer);
CREATE OR REPLACE PACKAGE favorites_pkg A
www.eeworm.com/read/241364/13150893
sql showdaterange.sql
CREATE TABLE dates (dateval DATE);
DECLARE
old_date DATE;
curr_date DATE := SYSDATE;
BEGIN
BEGIN
LOOP
old_date := curr_date;
curr_date := curr_date + 1;
www.eeworm.com/read/241364/13150929
sql enc.sql
declare
l_key varchar2(2000) := '1234567890123456';
l_in_val varchar2(2000) := 'ConfidentialData';
l_mod number := dbms_crypto.ENCRYPT_AES128
+ dbms_crypto
www.eeworm.com/read/241364/13150945
sql openclose.sql
CREATE OR REPLACE PACKAGE personnel
IS
CURSOR emps_for_dept (
department_id_in_in IN emp.department_id_in%TYPE)
IS
SELECT * FROM emp
WHERE department_id_in = department