https://blog.youkuaiyun.com/spongcerzh-cnhttps://blog.youkuaiyun.com/https://blog.youkuaiyun.com/spongcer/article/details/43700299https://blog.youkuaiyun.com/spongcer/article/details/43700299spongcerTue, 10 Feb 2015 10:41:24 +0800https://blog.youkuaiyun.com/spongcer/article/details/43700205https://blog.youkuaiyun.com/spongcer/article/details/43700205spongcerTue, 10 Feb 2015 10:35:34 +0800https://blog.youkuaiyun.com/spongcer/article/details/9044709https://blog.youkuaiyun.com/spongcer/article/details/9044709spongcerSat, 08 Jun 2013 09:55:34 +0800https://blog.youkuaiyun.com/spongcer/article/details/9044679https://blog.youkuaiyun.com/spongcer/article/details/9044679spongcerFri, 07 Jun 2013 09:50:42 +0800https://blog.youkuaiyun.com/spongcer/article/details/9044663https://blog.youkuaiyun.com/spongcer/article/details/9044663spongcerFri, 07 Jun 2013 09:46:57 +0800 select mod(10 , 2) from dual; lower（char）：将字符串转化为小写格式； upper（char） ：将字符串转化为大写格式； length（char）：返回字符串长度： substr（chat ，m ， n）：去字符串子串；（从地m个开始取]]>https://blog.youkuaiyun.com/spongcer/article/details/9044651https://blog.youkuaiyun.com/spongcer/article/details/9044651spongcerFri, 07 Jun 2013 09:44:34 +0800https://blog.youkuaiyun.com/spongcer/article/details/9044637https://blog.youkuaiyun.com/spongcer/article/details/9044637spongcerFri, 07 Jun 2013 09:43:28 +0800https://blog.youkuaiyun.com/spongcer/article/details/9044627https://blog.youkuaiyun.com/spongcer/article/details/9044627spongcerFri, 07 Jun 2013 09:42:17 +0800https://blog.youkuaiyun.com/spongcer/article/details/9044551https://blog.youkuaiyun.com/spongcer/article/details/9044551spongcerFri, 07 Jun 2013 09:40:31 +0800https://blog.youkuaiyun.com/spongcer/article/details/9044543https://blog.youkuaiyun.com/spongcer/article/details/9044543spongcerFri, 07 Jun 2013 09:32:13 +0800https://blog.youkuaiyun.com/spongcer/article/details/9044527https://blog.youkuaiyun.com/spongcer/article/details/9044527spongcerFri, 07 Jun 2013 09:31:21 +0800https://blog.youkuaiyun.com/spongcer/article/details/9044507https://blog.youkuaiyun.com/spongcer/article/details/9044507spongcerFri, 07 Jun 2013 09:29:04 +0800https://blog.youkuaiyun.com/spongcer/article/details/9044487https://blog.youkuaiyun.com/spongcer/article/details/9044487spongcerFri, 07 Jun 2013 09:27:05 +0800https://blog.youkuaiyun.com/spongcer/article/details/9044465https://blog.youkuaiyun.com/spongcer/article/details/9044465spongcerFri, 07 Jun 2013 09:25:27 +0800https://blog.youkuaiyun.com/spongcer/article/details/9044373https://blog.youkuaiyun.com/spongcer/article/details/9044373spongcerFri, 07 Jun 2013 09:21:11 +0800 --建表book； SQL> create table book( 2 bookId number , 3 bookN]]>https://blog.youkuaiyun.com/spongcer/article/details/9044363https://blog.youkuaiyun.com/spongcer/article/details/9044363spongcerFri, 07 Jun 2013 09:14:34 +0800https://blog.youkuaiyun.com/spongcer/article/details/9044343https://blog.youkuaiyun.com/spongcer/article/details/9044343spongcerFri, 07 Jun 2013 09:13:48 +0800https://blog.youkuaiyun.com/spongcer/article/details/9044333https://blog.youkuaiyun.com/spongcer/article/details/9044333spongcerFri, 07 Jun 2013 09:10:07 +0800 create procedure sp_pro3(spName varchar]]>https://blog.youkuaiyun.com/spongcer/article/details/9044317https://blog.youkuaiyun.com/spongcer/article/details/9044317spongcerFri, 07 Jun 2013 09:08:10 +0800 --函数案例； SQL> --输入雇员的姓名，返回该雇员的年薪； SQL> create or replace function myfun1(spName varchar2)]]>https://blog.youkuaiyun.com/spongcer/article/details/9044313https://blog.youkuaiyun.com/spongcer/article/details/9044313spongcerFri, 07 Jun 2013 09:04:31 +0800 --编写一个过程，可以输入一个员工名， SQL> --如果该员工工资低于2000，就给该员工增加10%； SQL> create or replace procedure mypro(spN]]>