oracle - 随笔分类 - zfzf1

oracle 反向索引

摘要：create index ix_ba_emp_code_re on t_base_employee(reverse(employee_code)); select * from t_base_employee t where t.employee_code like 'dss%' or revers 阅读全文

posted @ 2018-03-18 15:46 zfzf1 阅读(143) 评论(0) 推荐(0)

oracle 导出数据

摘要：阅读全文

posted @ 2018-03-03 22:34 zfzf1 阅读(114) 评论(0) 推荐(0)

ORACLE截取时间

摘要：--hcm 修复hcm 当天入职原工,当天凌晨生效问题CREATE OR REPLACE FUNCTION BDM.F_VI_HCM_FOR_BDM_REAL_OPTTIME(V_TIME IN TIMESTAMP) RETURN TIMESTAMP AS V_TIME_STR VARCHAR2(2 阅读全文

posted @ 2018-02-06 18:48 zfzf1 阅读(361) 评论(0) 推荐(0)

oracle to_timestamp

摘要：to_timestamp('2018-02-04 12:00:00.00','yyyy-mm-dd hh24:mi:ss.ff') 阅读全文

posted @ 2018-02-06 16:13 zfzf1 阅读(283) 评论(0) 推荐(0)

oracle to_date

摘要：select to_date('2005-01-01 13:14:20','yyyy-MM-dd HH24:mi:ss') from dual; 阅读全文

posted @ 2018-02-06 15:59 zfzf1 阅读(85) 评论(0) 推荐(0)

oracle 无效字符

摘要：多写了; 阅读全文

posted @ 2018-02-02 15:13 zfzf1 阅读(537) 评论(0) 推荐(0)

创建 oracle dblin

摘要：create public database link link_fokf_sit connect to YCGCE identified by YCGCE using '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.36.23)(PORT = 1521)) ) (CONNECT_DATA = ... 阅读全文

posted @ 2017-11-01 10:09 zfzf1 阅读(383) 评论(0) 推荐(0)

oracle lengthb

摘要：select lengthb('南通70ZZM-南通通州区骑岸镇营业部') from dual; 阅读全文

posted @ 2017-09-13 12:21 zfzf1 阅读(476) 评论(0) 推荐(0)

oracle loop 关键字

摘要：return 退出方法,函数 continue 继续下一次循环 exit 退出当前循环阅读全文

posted @ 2017-09-07 15:53 zfzf1 阅读(295) 评论(0) 推荐(0)

oracle 遍历每字符串的每一个字符

摘要：declare v_str varchar2(50):='00xxx'; v_char varchar2(50):=null; v_count number(10):=0; begin v_count:=length(v_str); for i in 1..v_count loop v_char:= substr(v_str,i,1); dbms_output.put_l... 阅读全文

posted @ 2017-09-07 15:11 zfzf1 阅读(2610) 评论(0) 推荐(0)

oracle异常

摘要：declare v_str varchar2(50):='00xxx'; v_char varchar2(1):=null; v_count number(10):=0; begin v_count:=length(v_str); for i in 1..v_count loop begin v_char:=substr(v_str,0,i); dbms_outp... 阅读全文

posted @ 2017-09-07 14:45 zfzf1 阅读(142) 评论(0) 推荐(0)

oracel分页

摘要：select * from (select a1.*,rownum rn from ( xx ) a1 where rownum <=5) where rn>=2; 阅读全文

posted @ 2017-09-07 14:21 zfzf1 阅读(126) 评论(0) 推荐(0)

oracle改表语句

摘要：alter table t_fin_month_conn_bill add bill_time_month number(2) default 9 not null ;comment on column t_fin_month_conn_bill.bill_time_month is '账单关联运单阅读全文

posted @ 2017-09-04 09:47 zfzf1 阅读(137) 评论(0) 推荐(0)

oracle 表空间扩展

摘要：select a.tablespace_name, a.bytes / 1024 / 1024 "sum MB", (a.bytes - b.bytes) / 1024 / 1024 "used MB", b.bytes / 1024 / 1024 "free MB", round(((a.byte 阅读全文

posted @ 2017-08-07 13:49 zfzf1 阅读(136) 评论(0) 推荐(0)

oracle 无法从套接字读取更多的数据

摘要：alter system set "_optimizer_connect_by_cost_based" = false scope=both ; alter system set "_optimizer_connect_by_cost_based" = false scope=both ; alte 阅读全文

posted @ 2017-07-17 11:15 zfzf1 阅读(10855) 评论(0) 推荐(1)

oracle dblinik 表快速同步

摘要：create public database link link_mm_devconnect to stl identified by fosssitusing '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 192. 阅读全文

posted @ 2017-06-28 11:33 zfzf1 阅读(303) 评论(0) 推荐(0)

oralce sysdate转number

摘要：to_char(sysdate,'yyyymmddhh24missSSS') 阅读全文

posted @ 2017-06-04 13:59 zfzf1 阅读(263) 评论(0) 推荐(0)

oracl删除最新数据

摘要：delete from t_dictionary_type t where sysdate-t.create_time<=1;delete from t_dictionary_data t where sysdate-t.create_time<=1; 阅读全文

posted @ 2017-05-04 00:52 zfzf1 阅读(123) 评论(0) 推荐(0)

oracle开启远程连接访问

摘要：方法/步骤首先，您应该确定有一台安装好Oracle的服务器。并且此服务器和要连接它的计算机在同一个网络中（一般来说，在一个局域网中，如果服务器在公网中也没有问题）。设置Oracel的连接模式为【共享服务器模式】。步骤为：首先【用管理员身份】打开database configuration as 阅读全文

posted @ 2017-04-09 13:04 zfzf1 阅读(1318) 评论(0) 推荐(0)

oracle触发器

摘要：--:new 新记录,--:old 老记录create or replace trigger tr_tab_user_timestamp before insert or update on tab_user for each row declare begin :new.time_stamp:=sysdate; end; 阅读全文

posted @ 2017-03-31 15:39 zfzf1 阅读(103) 评论(0) 推荐(0)

zfzf1

随笔分类 - oracle

公告