代码搜索:PLSQL
找到约 265 项符合「PLSQL」的源代码
代码结果 265
www.eeworm.com/read/161040/5563959
txt join_练习.txt
----------------------------------------
--以下表达式是错误的!
SELECT prod.product_name,
prod.product_price,
purc.purchase_date,
purc.quantity
FROM plsql101_product prod,
www.eeworm.com/read/161040/5564009
txt script_66.txt
--在以后的练习中,我们经常要用到以下两个表,所以先讲解一下这两个表的结构及含意
名称 产品库存表 :plsql101_product用于存放产品信息
---------------------------------------------------------------
PRODUCT_NAME
www.eeworm.com/read/161040/5564010
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 value
www.eeworm.com/read/241364/13151470
sql plw7203.sql
ALTER SESSION SET PLSQL_WARNINGS = 'ENABLE:ALL'
/
CREATE OR REPLACE PACKAGE plw7203
IS
TYPE collection_t IS TABLE OF VARCHAR2 (100);
PROCEDURE proc (collection_in IN OUT collection_t);
E
www.eeworm.com/read/306645/13740673
sps plgsrchash.sps
CREATE OR REPLACE PACKAGE plgsrchash
IS
FUNCTION onerow (
drv_in IN VARCHAR2, srcstring_in IN VARCHAR2
)
RETURN PLGdoir.src_rectype;
PROCEDURE addrow (
drv_in IN
www.eeworm.com/read/464740/7155877
cfg oracle.cfg
sys_include=($ORACLE_HOME/precomp/public,/usr/include,/usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/include)
include=$ORACLE_HOME/precomp/public
include=$ORACLE_HOME/precomp/hdrs
include=$ORACLE_HOM
www.eeworm.com/read/241364/13151374
sql plw5001.sql
CREATE OR REPLACE PROCEDURE plw5001
IS
a BOOLEAN;
a PLS_INTEGER;
BEGIN
a := 1;
DBMS_OUTPUT.put_line ('Will not compile?');
END plw5001;
/
SHOW ERRORS
ALTER SESSION SET
www.eeworm.com/read/306645/13740684
tst srcinfo.tst
declare
rec plgdoir.src_rectype;
begin
plgerr.reset;
rec := plgdoir.srcinfo ('&1', '&2'/*, false*/);
p.l (PLGdoir.column_specific_src ('&1', rec));
p.l (rec.srcstring);
p.l (r
www.eeworm.com/read/161040/5563853
txt script_65.txt
--在以后的练习中,我们经常要用到以下两个表,所以先讲解一下这两个表的结构及含意
名称 产品库存表 :plsql101_product用于存放产品信息
---------------------------------------------------------------
PRODUCT_NAME
www.eeworm.com/read/161040/5563963
txt 多表查询练习.txt
名称 plsql101_product 商品库存信息表
--------------------
PRODUCT_NAME 商品名称
PRODUCT_PRICE 商品单价
QUANTITY_ON_HAND 商品库存
LAST_STOCK_DATE 商品最后采购日期
名称