代码搜索：PLSQL
找到约 265 项符合「PLSQL」的源代码
代码结果 265
www.eeworm.com/read/161040/5563855
txt group_by_后用函数.txt
--求采购信息表（plsql101_purchase）
--求各商品：采购总量,每次采购的平均数量，一共有多少次采购，单次采购的最低数量，单次采购的最高数量
SELECT product_name "商品",
SUM(quantity) "采购总量", --采购总量
AVG(quantity) "平均数量", --每次采购的平均数量
www.eeworm.com/read/161040/5563947
txt foreign_key.txt
ALTER TABLE plsql101_purchase
ADD CONSTRAINT plsql101_purchase_fk_product
FOREIGN KEY (product_name)
REFERENCES plsql101_product;
-- 练习: Fixing child values & creating the F
www.eeworm.com/read/161040/5564014
txt group_by_后用函数.txt
--求采购信息表（plsql101_purchase）
--求各商品：采购总量,每次采购的平均数量，一共有多少次采购，单次采购的最低数量，单次采购的最高数量
SELECT product_name "商品",
SUM(quantity) "采购总量", --采购总量
AVG(quantity) "平均数量", --每次采购的平均数量
www.eeworm.com/read/241364/13151446
sql plw7204.sql
ALTER SESSION SET PLSQL_WARNINGS = 'ENABLE:ALL'
/
CREATE OR REPLACE FUNCTION plw7204
RETURN PLS_INTEGER
AS
l_count PLS_INTEGER;
BEGIN
SELECT COUNT(*) INTO l_count
FROM employee
www.eeworm.com/read/161040/5563797
txt trim.txt
SELECT 'Item ' ||
item_id ||
' is described as a ' ||
item_desc ||
'.' "Item Description Sentence"
FROM plsql101_old_item;
SELECT 'Item ' ||
RTRIM(it
www.eeworm.com/read/161040/5563798
txt instr.txt
SELECT item_desc,
INSTR(item_desc,
',',
1
)
FROM plsql101_old_item;
SELECT item_desc,
SUBSTR(item_desc,
1,
www.eeworm.com/read/161040/5563820
txt script_64_没使用shangpin表.txt
--在以后的练习中，我们经常要用到以下两个表，所以先讲解一下这两个表的结构及含意
名称 产品库存表 :plsql101_product用于存放产品信息
---------------------------------------------------------------
PRODUCT_NAME
www.eeworm.com/read/161040/5563942
txt disable_enable.txt
INSERT INTO plsql101_product VALUES (
'Red Snaphoo', 1.95, 10, '30-12月-01')
;
ALTER TABLE plsql101_product DISABLE CONSTRAINT reasonable_stock_date;
INSERT INTO plsql101_product VALUES (
www.eeworm.com/read/161040/5563943
txt outer_join.txt
SELECT product_name FROM plsql101_product ORDER BY product_name;
SELECT prod.product_name,
prod.product_price,
purc.purchase_date,
purc.quantity
FROM plsql101_product pr
www.eeworm.com/read/161040/5563953
txt 多表查询练习answer.txt
--查询采购信息和对应经手人的各人信息：图形分析：补充3_product.ppt
--不仅要知道采购信息，还要知道相应采购人的信息。
SELECT plsql101_purchase.product_name,
plsql101_person.last_name,
plsql101_person.first_name,
plsql101_pu