梦你所梦

摘要： 建立存储过程:create or replace procedure sp_spo3(spName varchar2,newSal number) isbegin update emp set sal = newSal where ename = spName;end;/编写java代码:/** * @title OracleProcudure.java * @description * @create 2013-7-29 下午02:52:15 By yangzhi * @package com.oracle.procudure * @version ... 阅读全文

摘要： --异常测试declarev_ename emp.empno%type;--定义变量beginselect ename into v_ename from emp where empno = &gno;dbms_output.put_line('名字:' || v_ename);exception when no_data_found then dbms_output.put_line('未找到');end;/pl/sql是什么 pl/sql(procedural language/sql)是oracle在标准的sql语言上的扩展。pl/sql不仅允许嵌 阅读全文