代码搜索:PLSQL
找到约 265 项符合「PLSQL」的源代码
代码结果 265
www.eeworm.com/read/161040/5563935
txt alter_null.txt
ALTER TABLE plsql101_person MODIFY (first_name NULL);
ALTER TABLE plsql101_person MODIFY (first_name NOT NULL);
ALTER TABLE plsql101_person MODIFY (last_name NULL);
www.eeworm.com/read/277141/10664911
htm otl3_wa01.htm
OTL 3.1, Workaround 1 (PL/SQL tables as parameters)
www.eeworm.com/read/399906/7825777
htm otl3_wa01.htm
OTL 3.1, Workaround 1 (PL/SQL tables as parameters)
www.eeworm.com/read/241364/13150962
sql cc_static_expr.sql
CREATE OR REPLACE PROCEDURE check_expressions
IS
BEGIN
-- =, !=, OR works fine.
$IF $$plsql_optimize_level != 1 OR $$plsql_optimize_level = 2
$THEN
-- Placeholder
$END
NULL;
END check_
www.eeworm.com/read/161040/5563786
txt round.txt
SELECT product_name, product_price
FROM plsql101_product;
SELECT product_name, ROUND(product_price, 0)
FROM plsql101_product;
SELECT ROUND(1234.5678, 4) FROM DUAL;
SELECT ROUND(1234.5678,
www.eeworm.com/read/161040/5563796
txt length.txt
SELECT product_name, LENGTH(product_name) NAME_LENGTH
FROM plsql101_product
WHERE LENGTH(product_name) >15
ORDER BY product_name;
www.eeworm.com/read/161040/5563817
txt script_64.txt
--在以后的练习中,我们经常要用到以下两个表,所以先讲解一下这两个表的结构及含意
名称 产品库存表 :plsql101_product用于存放产品信息
---------------------------------------------------------------
PRODUCT_NAME
www.eeworm.com/read/161040/5563938
txt primary_key.txt
-- 在建立表时用建立主键
CREATE TABLE plsql101_product2 (
product_name VARCHAR2(25) PRIMARY KEY,
product_price NUMBER(4,2),
quantity_on_hand NUMBER(5,0),
last_stock_date DATE
www.eeworm.com/read/385012/8824355
doc tsql与plsql的比较(不完全版).doc
www.eeworm.com/read/161040/5563939
txt multi_table_j.txt
SELECT plsql101_purchase.product_name,
plsql101_person.last_name,
plsql101_person.first_name,
plsql101_purchase.quantity
FROM plsql101_purchase,
plsql101_person
;