摘要： create or replace package my_pack isprocedure my_pro2(v_sal in number,v_name varchar2);function my_fun(v_name varchar2) return number;end;create or replace package body my_pack isprocedure my_pro2(v_sal in number,v_name varchar2) isbegin update test set sal=v_sal where name=v_name;end;function my_fu 阅读全文

摘要： create or replace function my_fun(v_name varchar2)return number isv_annual_sal number;begin select sal*13 into v_annual_sal from test where name=v_name; return v_annual_sal;end;select my_fun('Allen') from test; 阅读全文

摘要： create or replace procedure my_pro6(v_empno number) isv_job emp.job%type;begin select job into v_job from emp where empno=v_empno; if v_job='PRESIDENTt' then update emp set sal=sal+1000 where empno=v_empno; else if v_job='MANAGER' then update emp set sal=sal+500 where empno=v_empno; 阅读全文

摘要： 1 注释单行--多行/*...*/2 命名规则变量：v_name常量：c_name游标：name_cursor异常：e_nameBlock(pl/sql编程基本单元)(过程、函数、触发器、包)set serveroutput on;/***控制台显示开启***/declarev_name varchar2(20);begin select name into v_name from test where id=&id; dbms_output.put_line(v_name);exception when no_data_found then dbms_output.put_line( 阅读全文

摘要： create procedure my_pro isbegin insert into test values(6,'Ivan',3800);end;exec my_pro;create or replace procedure my_pro2(v_sal in number,v_name varchar2) isbegin update test set sal=v_sal where name=v_name;end;exec my_pro2(2000,'Ivan');/***参数默认in，也可以执行call my_pro2(2000,'Ivan 阅读全文