代码搜索: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/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 ;