oracle
文章平均质量分 51
lzun007
这个作者很懒,什么都没留下…
展开
-
oracle查询列名 输出文件
insertselect b.column_name||',' from user_col_comments b where b.table_name='WEB_EDR_RSN';select lower(REPLACE(b.column_name,'_','')) ||',' from user_col_comments b where b.table_nam...原创 2012-04-27 20:11:30 · 252 阅读 · 0 评论 -
oracle 数组
Oracle数组一般可以分为固定数组和可变数组 固定数组 Sql代码 declare type v_ar is varray(10) of varchar2(30); my_ar v_ar:=v_ar('g','m','d','龚','帅'); begin for i in 1..my_ar.count loop ...原创 2012-03-31 11:14:35 · 68 阅读 · 0 评论 -
oracle package比较
动态SQL TABLE使用判断数据===========================================2011-10-19判断 函数create or replace function F_CAN_APPNO_RECALL(app_no in varchar2) return boolean is app_count number; v_SQLStatemen...原创 2012-03-31 11:49:34 · 80 阅读 · 0 评论 -
oracle merge
MERGE INTO EHR_STAFF_ATTEND_DETAIL A USING (SELECT 'LOVE001' AS STAFF_ID, 2 AS ATTEND_DETAIL_ID, '1011' AS ATTEND_NO, '02' AS ATTEND_STYLE, '41' AS PERMUTE_ID, '1' AS IS_VALID, USER AS C...原创 2012-03-31 13:05:23 · 55 阅读 · 0 评论 -
oracle sequence job
declarejob1 number;startdate date:=to_date('2011-10-20 00:00:00','yyyy-mm-dd hh24:mi:ss');begin--创建序列drop sequence seq_epcis_web_undr_opn;create sequence seq_epcis_web_undr_opn --创建序列名字...原创 2012-03-31 13:06:29 · 136 阅读 · 0 评论 -
oracle 动态查询 多维数组
declare/* * 遍历数据库可以打开的表 收集数据 需要延时函数 * * */ --数组--TYPE Type_Array IS TABLE OF VARCHAR2(50) INDEX BY BINARY_INTEGER; --循环变量j number:=1;table_target NVARCHAR2(50):=''; --多维数...原创 2012-03-31 13:57:42 · 748 阅读 · 0 评论