![](https://img-blog.csdnimg.cn/20201014180756926.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
oracle数据库
qflamj
曾經有個女孩和我誓同生死:
展开
-
oracle数据库2个时间段的时间差函数
[code="sql"] create or replace FUNCTION DATEDIFF (date1 IN DATE,date2 IN DATE) RETURN NUMBER IS datesx NUMBER(10); secondsx NUMBER(20); stra VARCHAR2(19); strb VARCHAR2(19);...2010-07-23 14:06:45 · 399 阅读 · 0 评论 -
oracle数据库存储过程实例(包含游标遍历的应用)
[code="sql"] create or replace PROCEDURE "RAW_LOSEMONTH" ( dotime IN DATE) --输入参数 AS ammeterIdx VARCHAR2(30);--定义变量 BEGIN --定义游标 DECLARE CURSOR cursorbdz IS SELECT...2010-07-23 14:46:13 · 137 阅读 · 0 评论 -
oracle数据库查询、删除、创建作业
1、查询作业 [code="sql"] select job,what,next_date,next_sec,failures,broken from user_jobs; [/code] 2、删除作业 [code="sql"] begin dbms_job.remove(:JOB_NUM); end; [/code] 3、创建作业 [code="sql"] --...2010-07-23 14:38:51 · 428 阅读 · 0 评论 -
oracle数据库十进制转十六进制
[code="sql"] create or replace FUNCTION "TENTOHX" (ix IN NUMBER) RETURN VARCHAR2 IS rx VARCHAR2(10); ixx NUMBER(10); BEGIN rx:=''; ixx:=ix; WHILE MOD(i...2010-07-23 14:21:41 · 479 阅读 · 0 评论 -
oracle数据库十进制转二进制
[code="sql"] create or replace FUNCTION "TENTOBIN" (ix IN NUMBER) RETURN VARCHAR2 IS vars VARCHAR2(1000); xs NUMBER(10); BEGIN vars:=''; ...2010-07-23 14:20:39 · 515 阅读 · 0 评论 -
oracle数据库2个数的最小值的函数
[code="sql"] create or replace FUNCTION "MIN_TWO" (paramone IN NUMBER,paramtwo IN NUMBER) RETURN NUMBER IS min_param NUMBER(18,2); BEGIN IF paramone>0 AND paramtwo>0...2010-07-23 14:18:41 · 1741 阅读 · 0 评论 -
oracle数据库2个数的最大值的函数
[code="sql"] create or replace FUNCTION "MAX_TWO" (paramone IN NUMBER,paramtwo IN NUMBER) RETURN NUMBER IS max_param NUMBER(18,2); BEGIN IF paramone>=paramtwo THEN max_param:=par...2010-07-23 14:17:32 · 2114 阅读 · 0 评论 -
oracle数据库判断是否是数字函数
[code="sql"] create or replace FUNCTION "ISNUMERIC" (str IN VARCHAR2) RETURN NUMBER IS v_str FLOAT; BEGIN IF str IS NULL THEN RETURN 0; ELSE BEGIN SELECT ...2010-07-23 14:14:49 · 238 阅读 · 0 评论 -
oracle数据库十六进制转十进制函数
[code="sql"] create or replace FUNCTION "HXTOTEN" (str_a IN VARCHAR2) RETURN NUMBER IS str_b NUMBER(10); str_c VARCHAR2(100); BEGIN str_c:=REPLACE(str_a,'0x',''); ...2010-07-23 14:11:39 · 751 阅读 · 0 评论 -
oracle数据库二进制转十进制函数
[code="sql"] create or replace FUNCTION "BINTOTEN" (strbin in varchar2) return NUMBER IS decvalue NUMBER(10); binlen NUMBER(10); indexa NUMBER(10); currb...2010-07-23 14:09:27 · 267 阅读 · 0 评论 -
oracle触发器实例
1、delete触发器 [code="sql"] create or replace TRIGGER "TRWATCH" AFTER DELETE ON WATCH FOR EACH ROW DECLARE watchname VARCHAR2(30); watchphone VARCHAR2(30); starttime DATE; endtime DATE; ...原创 2010-07-23 17:15:58 · 112 阅读 · 0 评论