DolphinHat的专栏

1.创建jobdeclare jobno number:=1;begin  --每5分钟执行  dbms_job.submit(jobno,'ProcedureName;',sysdate,'sysdate+5/1440');  --每天1点钟执行  dbms_job.submit(jobno,'ProcedureName;',trunc(sysdate),'trunc(s

--创建测试表create table t01(id integer,name varchar2(10));--创建测试数据insert into t01(id,name) values (1,'a');insert into t01(id,name) values (2,'b');insert into t01(id,name) values (3,'c');--提交commi

--创建测试表create table t01(id integer,name varchar2(10));--创建测试数据insert into t01(id,name) values (1,'a');insert into t01(id,name) values (2,'b');insert into t01(id,name) values (3,'c');--提交commi

date类型只能精确到秒，要想精确到毫秒，需要使用timestamp类型。应用举例：举例1：select to_char(systimestamp,'yyyy-mm-dd hh24:mi:ss.ff') from dual;举例2：select to_char(to_timestamp('20130425 080000','yyyy-mm-dd hh24:mi:ss.ff'),

&符号是oracle的替代字符，只要出现该字符oracle就会提示输入替代值。解决该问题有以下三种方式：1.设置会话，将&符号作为普通字符SQL> set define off;SQL> select 'a&b' from dual;2.拆分字符SQL> select 'a'||chr(38)||'b' from dual;SQL> select 'a'||'&'||'b'

有这样的一些数据：select 'fie_a' as col from dualunion allselect 'fie_b' as col from dualunion allselect 'fi_a' as col from dualunion allselect 'fi_b' as col from dual;我需要从这些数据中查找fi_开头的数据，一般写法是