摘要： 根据编程语言的惯性思维一般会这样写CREATE OR REPLACE PROCEDURE PRO_NAME()但很可惜编译不通过PLS-00103: Encountered the symbol ")" when expecting one of the following: current delete exists prior将其改成CREATE OR REPLACE PROCEDURE PRO_NAME去掉括号就OK了另外在PL/SQL中语句块之间如果没有代码的话也是会报错比如CREATE OR REPLACE PROCEDURE PRO_NAMEISBEGINEND 阅读全文

摘要： Oracle9i :ProgramwithPL/SQL Additional Practices 第11题Create a PL/SQL block to retrieve the last name and department ID of each employee from the EMPLOYEES table for those employees whose EMPLOYEE_ID is less than 114. From the values retrieved from the EMPLOYEES table, populate two PL/SQL tables, one 阅读全文