oracle
iteye_8024
这个作者很懒,什么都没留下…
展开
-
oracle学习——PL/SQL
[code="sql"] --绝对值,取余,判断数值正负函数 select abs(100),abs(-100),abs('100') from dual; select mod(100,10),mod(100,0) ,mod(34,7) from dual; select sign(-9),sign(10) from dual; --四舍五入截取函数 select round(9...原创 2014-11-21 16:45:03 · 103 阅读 · 0 评论 -
oracle学习——游标.sql
[code="sql"]set serveroutput on; declare cursor myCursor is select * from categoryinfo; myRow categoryinfo%rowtype; v_count number(8,0); begin -- select count(*) into v_count from categor...原创 2014-11-27 13:45:10 · 112 阅读 · 0 评论 -
oracle学习--存储过程.sql
[code="sql"]create or replace procedure test as begin dbms_output.put_line('hello world!'); end; show serveroutput; set serveroutput on; begin test; end; select * from user_source w...原创 2014-11-27 13:45:41 · 99 阅读 · 0 评论