plsql 源代码

PL/SQL也是一种程序语言，叫做过程化SQL语言（ProceduralLanguage/SQL）。PL/SQL是Oracle数据库对SQL语句的扩展。在普通SQL语句的使用上增加了编程语言的特点，所以PL/SQL把数据操作和查询语句组织在PL/SQL代码的过程性单元中，通过逻辑…

收录资源 107 份全站深度检索

共匹配 107 份工程资源 · 第 5 / 11 页

源码文件

SELECT product_name, LENGTH(product_name) NAME_LENGTH FROM plsql101_product WHERE LENGTH(product_name) >15 ORDER BY pr…

源码文件

SELECT 'Item ' || item_id || ' is described as a ' || item_desc || '.' "Item Description Senten…

源码文件

SELECT item_desc, INSTR(item_desc, ',', 1 ) FROM plsql101_old_item; …

源码文件

-- 当前日期为标准格式 SELECT * FROM plsql101_product WHERE TRUNC(last_stock_date) = '当前日期'; DELETE FROM plsql101_product WHERE pro…

源码文件

edit d:\plsql101_test2.sql /* Insert the following commands into the script file SET VERIFY OFF SELECT product_name, quanti…

源码文件

EDIT d:\plsql101_test.sql -- Insert the following commands into the script file CREATE TABLE plsql101_temp ( first_name …

源码文件

edit d:\plsql101_test4.sql /* Insert the following commands into the script file SET VERIFY OFF SET ECHO OFF ACCEPT v_earl…

源码文件

edit d:\plsql101_test5.sql /* Insert the following commands into the script file SET ECHO OFF SET VERIFY OFF @d:\sm_emp_var1…

源码文件

edit d:\plsql101_test3.sql /* Insert the following commands into the script file SET VERIFY OFF SELECT product_name, quanti…

源码文件

--在以后的练习中，我们经常要用到以下两个表，所以先讲解一下这两个表的结构及含意名称产品库存表 :plsql101_product用于存放产品信息 -------------…