代码搜索: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 商品最后采购日期 名称