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 · 113 阅读 · 0 评论 -
oracle学习--存储过程.sql
[code="sql"]create or replace procedure testas 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 评论