代码搜索:PLSQL
找到约 265 项符合「PLSQL」的源代码
代码结果 265
www.eeworm.com/read/353017/10477939
sql a.sql
DROP TABLE plsql101_purchase;
DROP TABLE plsql101_product;
DROP TABLE plsql101_person;
DROP TABLE plsql101_old_item;
DROP TABLE plsql101_purchase_archive;
CREATE TABLE plsql101_person (
p
www.eeworm.com/read/353017/10477961
sql b.sql
-- Startup text at beginning of chapter
DROP TABLE plsql101_purchase;
DROP TABLE plsql101_product;
DROP TABLE plsql101_person CASCADE CONSTRAINTS;
DROP TABLE plsql101_old_item;
DROP TABLE plsql10
www.eeworm.com/read/438748/7727530
sql 54008.sql
-- -------------------------------------------------
-- Filename: 54008.sql
--
-- Script file for PL/SQL 101 for Oracle 10g
-- Chapter 08
-- Created by Christopher Allen
-- Copyright Oracle Pres
www.eeworm.com/read/438748/7727532
sql 54007.sql
-- -------------------------------------------------
-- Filename: 54007.sql
--
-- Script file for PL/SQL 101 for Oracle 10g
-- Chapter 07
-- Created by Christopher Allen
-- Copyright Oracle Pres
www.eeworm.com/read/241364/13151040
sql plw5004.sql
ALTER SESSION SET plsql_warnings = 'ENABLE:ALL'
/
CREATE OR REPLACE PROCEDURE plw5004
IS
INTEGER NUMBER;
PROCEDURE TO_CHAR
IS
BEGIN
INTEGER := 10;
END TO_CHAR;
BEG
www.eeworm.com/read/241364/13151152
pkg dynvar.pkg
CREATE OR REPLACE PACKAGE dynvar
AUTHID CURRENT_USER
IS
PROCEDURE assign (expr_in IN VARCHAR2, var_inout IN OUT VARCHAR2);
FUNCTION val (var_in IN VARCHAR2) RETURN VARCHAR2;
PROCEDURE
www.eeworm.com/read/241363/13151631
sql 54008.sql
-- -------------------------------------------------
-- Filename: 54008.sql
--
-- Script file for PL/SQL 101 for Oracle 10g
-- Chapter 08
-- Created by Christopher Allen
-- Copyright Oracle Pres
www.eeworm.com/read/241363/13151636
sql 54007.sql
-- -------------------------------------------------
-- Filename: 54007.sql
--
-- Script file for PL/SQL 101 for Oracle 10g
-- Chapter 07
-- Created by Christopher Allen
-- Copyright Oracle Pres
www.eeworm.com/read/161040/5563787
txt sysdate_err.txt
INSERT INTO plsql101_product VALUES
('Square Zinculator', 45, 1, SYSDATE);
SELECT * FROM plsql101_product;
-- 当天日期输入为测试日期
SELECT * FROM plsql101_product
WHERE last_stock_date = '当天日期
www.eeworm.com/read/161040/5563924
txt insert_data.txt
-- ======================== PERSON ==================================
DROP TABLE plsql101_person;
CREATE TABLE plsql101_person (
person_code VARCHAR2(3),
first_name VARCHAR2(15),