oracle
zhaishanhui
这个作者很懒,什么都没留下…
展开
-
oracle常用操作2
declare -- 声明变量时指定初始值。 v_name varchar2(50) := '孙悟空'; begin v_name := '白骨精'; end; select * from emp; select * from emp where comm is null; -- expr1 between expr2 and expr3 -原创 2015-05-20 13:02:00 · 292 阅读 · 0 评论 -
oracle自定义函数、存储过程2
select * from dept; delete from dept where to_char(deptno) not like '%0'; commit; create or replace procedure add_dept_data(p_dname dept.dname%type , p_loc dept.loc%type , p_count out numbe原创 2015-05-20 12:58:30 · 297 阅读 · 0 评论 -
oracle包、触发器2
select * from dept; declare -- 所谓游标,其实就是指向查询结果的引用 cursor dept_cursor is select * from dept; v_deptno dept.deptno%type; v_dname dept.dname%type; v_loc dept.loc%type原创 2015-05-20 12:56:50 · 273 阅读 · 0 评论 -
oracle常用操作1
select * from emp; select * from dept; create table course_inf ( course_id number primary key, course_name varchar2(50), course_time varchar2(50), prefix_id number, foreign key(prefix_id)原创 2015-05-20 13:00:55 · 264 阅读 · 0 评论 -
oracle包、触发器
-- 创建包头,有点类似于Java的接口 create or replace package first_package is type dept_table_type is table of dept.dname%type index by binary_integer; procedure put_boolean(p_val boolean原创 2015-05-20 12:57:34 · 310 阅读 · 0 评论 -
oracle自定义函数、存储过程
declare v_name varchar2(50); v_age number; begin v_name := '孙悟空'; v_age := 40; -- 嵌套块 declare v_color varchar2(50); v_price number; begin原创 2015-05-20 12:59:02 · 362 阅读 · 0 评论