代码搜索：PLSQL
找到约 265 项符合「PLSQL」的源代码
代码结果 265
www.eeworm.com/read/241363/13151651
sql 54006.sql
-- -------------------------------------------------
-- Filename: 54006.sql
--
-- Script file for PL/SQL 101 for Oracle 10g
-- Chapter 06
-- Created by Christopher Allen
-- Copyright Oracle Pres
www.eeworm.com/read/161040/5563790
txt data_insert.txt
DROP TABLE plsql101_product;
CREATE TABLE plsql101_product (
product_name VARCHAR2(25),
product_price NUMBER(4,2),
quantity_on_hand NUMBER(5,0),
last_stock_date DATE
www.eeworm.com/read/161040/5563941
txt not_null.txt
-- NOT NULL CONSTRAINT
ALTER TABLE plsql101_person MODIFY (first_name NOT NULL);
ALTER TABLE plsql101_person MODIFY (last_name NOT NULL);
INSERT INTO plsql101_person VALUES (
'XL', 'Xaviera
www.eeworm.com/read/161040/5563945
txt unique.txt
ALTER TABLE plsql101_person
ADD CONSTRAINT plsql101_person_unique UNIQUE (
first_name,
last_name,
hire_date
)
;
INSERT INTO plsql101_person VALUES (
'LN', 'Linda',
www.eeworm.com/read/161040/5563956
txt insert_data.txt
------------------------ PERSON ------------------------
DROP TABLE plsql101_person;
CREATE TABLE plsql101_person (
person_code VARCHAR2(3),
first_name VARCHAR2(15),
last_name V
www.eeworm.com/read/161040/5563960
sql insert_data.sql
------------------------ PERSON ------------------------
DROP TABLE plsql101_person;
CREATE TABLE plsql101_person (
person_code VARCHAR2(3),
first_name VARCHAR2(15),
last_name V
www.eeworm.com/read/161040/5563986
txt data.txt
delete from plsql101_purchase;
insert into plsql101_purchase values('豆腐','张',to_date('2002/01/01','yyyy/mm/dd'),10);
insert into plsql101_purchase values('钢笔','张',to_date('2002/02/01','yyyy/mm/dd'
www.eeworm.com/read/353017/10477920
sql 54004.sql
-- -------------------------------------------------
-- Filename: 54004.sql
--
-- Script file for PL/SQL 101 for Oracle 10g
-- Chapter 04
-- Created by Christopher Allen
-- Copyright Oracle Pres
www.eeworm.com/read/353017/10477946
sql 54009.sql
-- -------------------------------------------------
-- Filename: 54009.sql
--
-- Script file for PL/SQL 101 for Oracle 10g
-- Chapter 09
-- Created by Christopher Allen
-- Copyright Oracle Pres