代码搜索：PLSQL
找到约 265 项符合「PLSQL」的源代码
代码结果 265
www.eeworm.com/read/161040/5563944
txt join.txt
SELECT plsql101_purchase.product_name,
plsql101_product.product_price,
plsql101_purchase.quantity,
plsql101_person.last_name
FROM plsql101_product,
plsql101_person,
www.eeworm.com/read/161040/5563936
txt multi_table.txt
SELECT plsql101_purchase.product_name,
plsql101_person.last_name,
plsql101_person.first_name,
plsql101_purchase.quantity
FROM plsql101_purchase,
plsql101_person
WHE
www.eeworm.com/read/353017/10477979
sql 54005.sql
-- -------------------------------------------------
-- Filename: 54005.sql
--
-- Script file for PL/SQL 101 for Oracle 10g
-- Chapter 05
-- Created by Christopher Allen
-- Copyright Oracle Pres
www.eeworm.com/read/438748/7727536
sql 54005.sql
-- -------------------------------------------------
-- Filename: 54005.sql
--
-- Script file for PL/SQL 101 for Oracle 10g
-- Chapter 05
-- Created by Christopher Allen
-- Copyright Oracle Pres
www.eeworm.com/read/241364/13151150
sql cc_opt_level_check.sql
CREATE OR REPLACE PROCEDURE long_compilation
IS
BEGIN
$IF $$plsql_optimize_level != 1
$THEN
$error 'This program must be compiled with optimization level = 1' $end
$END
NULL;
END long_co
www.eeworm.com/read/241363/13151647
sql 54005.sql
-- -------------------------------------------------
-- Filename: 54005.sql
--
-- Script file for PL/SQL 101 for Oracle 10g
-- Chapter 05
-- Created by Christopher Allen
-- Copyright Oracle Pres
www.eeworm.com/read/161040/5563791
txt sub_string.txt
drop table PLSQL101_OLD_ITEM;
CREATE TABLE plsql101_old_item (
item_id CHAR(20),
item_desc CHAR(25)
)
;
INSERT INTO plsql101_old_item VALUES
('LA-101', 'Can, Small');
www.eeworm.com/read/161040/5563800
txt sysdate_trunc.txt
-- 当前日期为标准格式
SELECT * FROM plsql101_product
WHERE TRUNC(last_stock_date) = '当前日期';
DELETE FROM plsql101_product
WHERE product_name = 'Square Zinculator';
INSERT INTO plsql101_product VALUE
www.eeworm.com/read/161040/5563850
txt 用to_date只更新年份.txt
---只更新年份err!
UPDATE plsql101_product
SET last_stock_date
= TO_DATE('2000',
'yyyy');
UPDATE plsql101_product
SET last_stock_date
= TO_DATE('2002',
'yyyy')
whe
www.eeworm.com/read/161040/5563851
txt 练习1.txt
--从采购信息表plsql101_purchase中取出在一季度采购的产品
select product_name,quantity,salesperson from plsql101_purchase
where to_char(purchase_date,'mon')
in ('1月','2月','3月');
insert into plsql101_purchase valu