代码搜索：sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/241364/13150974
sql showjava.sql
COLUMN object_name FORMAT A30
SELECT object_name, object_type, status, timestamp
FROM user_objects
WHERE (object_name NOT LIKE 'SYS_%'
AND object_name NOT LIKE 'CREATE$%'
AND
www.eeworm.com/read/241364/13150992
sql atleastone.sql
SET VERIFY OFF
@ssoo
@plvtmr.pkg
DECLARE
/* Different approaches to answering "at least one?" */
CURSOR empcur
IS
SELECT employee_id
FROM employee_big WHERE department_
www.eeworm.com/read/241364/13151102
sql desctest.sql
/* Formatted on 2002/09/20 11:35 (Formatter Plus v4.5.2) */
DROP TYPE numtab FORCE;
DROP TYPE datearray FORCE;
DROP TYPE hiredatetab FORCE;
DROP TYPE obj_t FORCE;
CREATE TYPE numtab IS TABLE OF
www.eeworm.com/read/241364/13151209
sql utlcmd.sql
/*
Build by Vadim Loevski of Quest Software.
*/
CREATE OR REPLACE AND RESOLVE JAVA SOURCE NAMED " UTLcmd" AS
import java.lang.Runtime;
public class UTLcmd
{
public static void execute (
www.eeworm.com/read/241364/13151228
sql mastkey.sql
REM
REM Define a variable to hold the encrypted value
variable enc_val varchar2(2000);
declare
l_key varchar2(2000) := '1234567890123456';
l_master_key varchar2(2000) := '&master_key';
www.eeworm.com/read/241364/13151250
sql no_create.sql
CREATE OR REPLACE TRIGGER no_create
AFTER DDL ON SCHEMA
BEGIN
IF ORA_SYSEVENT = 'CREATE' THEN
RAISE_APPLICATION_ERROR(-20000,'Cannot create the ' || ORA_DICT_OBJ_TYPE ||
www.eeworm.com/read/241364/13151271
sql autontrigger.sql
DROP TABLE ceo_compensation;
CREATE TABLE ceo_compensation (
company VARCHAR2(100),
NAME VARCHAR2(100),
compensation NUMBER);
DROP TABLE ceo_comp_history;
CREATE TABLE ceo_comp_hi
www.eeworm.com/read/241364/13151295
sql autonserial.sql
DROP TABLE emp2;
CREATE TABLE emp2 AS SELECT * FROM emp;
CREATE OR REPLACE PROCEDURE fire_em_all
IS
PRAGMA AUTONOMOUS_TRANSACTION;
BEGIN
DELETE FROM emp2;
COMMIT;
EXCEPTION -- Lon
www.eeworm.com/read/241364/13151317
sql bulkexc.sql
REM DROP TABLE employee2;
REM CREATE TABLE employee2 as SELECT * FROM employee2;
CREATE OR REPLACE PROCEDURE BULK_EXCEPTIONS (whr_in IN VARCHAR2 := NULL)
IS
-- Example of anchor over DB Linnk
www.eeworm.com/read/241364/13151331
sql decval.sql
REM
REM Define a variable to hold the encrypted value
variable enc_val varchar2(2000);
declare
l_key varchar2(2000) := '1234567890123456';
l_in_val varchar2(2000) := 'ConfidentialData';