代码搜索:sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/241364/13151364
sql deletefile.sql
/* Formatted on 2002/05/22 18:56 (Formatter Plus v4.6.5) */
CREATE TYPE file_details AS OBJECT (
dirname VARCHAR2 (30),
deletedate DATE)
/
CREATE TYPE file_table AS TABLE OF fi
www.eeworm.com/read/241364/13151383
sql longname.sql
SELECT object_name shortname,
DBMS_JAVA.LONGNAME (object_name) longname
FROM USER_OBJECTS
WHERE object_type = 'JAVA CLASS'
AND object_name != DBMS_JAVA.LONGNAME (object_name);
www.eeworm.com/read/241364/13151389
sql oneversion.sql
SET FEEDBACK OFF
SET VERIFY ON
REM
REM SQL*Plus script that automatically detects the Oracle version
REM and sets substitution variables that turn on or off
REM the new 8i AUTHID CURRENT_USER f
www.eeworm.com/read/241364/13151397
sql msginfo.sql
REM Create a table to hold various kinds of messages.
DROP TABLE msg_info;
CREATE TABLE msg_info (
msgcode PLS_INTEGER,
msgtype VARCHAR2(30),
msgtext VARCHAR2(2000),
msgname VARC
www.eeworm.com/read/241364/13151424
sql nosuchrow.sql
/* Formatted on 2001/12/26 13:53 (Formatter Plus v4.5.2) */
CREATE TYPE strings_nt IS TABLE OF VARCHAR2 (100);
/
DECLARE
TYPE strings_ibt IS TABLE OF VARCHAR2 (100)
INDEX BY BINARY_INT
www.eeworm.com/read/241364/13151426
sql irdynsql.sql
/* Formatted on 2002/02/22 08:24 (Formatter Plus v4.6.0) */
SET ECHO ON
SET FEEDBACK ON
SET VERIFY ON
SPOOL whichsch.log
CONNECT SCOTT/TIGER
CREATE OR REPLACE PROCEDURE showestack
IS
BEGIN
www.eeworm.com/read/241364/13151450
sql ssoo.sql
Set serveroutput on size 1000000 format wrapped
exec dbms_java.SET_OUTPUT (1000000);
set linesize 120
set pagesize 999
set trimspool on
/*==================================================
www.eeworm.com/read/241364/13151452
sql trcfunc.sql
DROP TABLE query_trace;
CREATE TABLE query_trace (
table_name VARCHAR2(30),
rowid_info ROWID,
queried_by VARCHAR2(30),
queried_at DATE
);
CREATE OR REPLACE FUNCTION tracei
www.eeworm.com/read/241364/13151458
sql hash.sql
declare
l_in_val varchar2(2000) := 'CriticalData';
l_hash raw(2000);
begin
l_hash := dbms_crypto.hash (
src => UTL_I18N.STRING_TO_RAW (l_in_val, 'AL32UTF8'),
typ => dbms_crypto.hash_
www.eeworm.com/read/241364/13151463
sql onlyfair.sql
DROP TABLE compensation;
CREATE TABLE compensation (
name VARCHAR2(100),
title VARCHAR2(100),
salary NUMBER,
bonus NUMBER,
stock_options INTEGER,
mercedes_benz_allowance NUM