02 2017 档案

查看job的运行日志
摘要：--sys用户执行以下sql语句，查看job的运行日志select t.owner, t.job_name, t.status, to_char(t.actual_start_date, 'yyyy-mm-dd hh24:mi:ss'), t.additional_info, t.error# fr 阅读全文

posted @ 2017-02-17 17:25 Oracle-fans 阅读(730) 评论(0) 推荐(0)

谈谈oracle里的join、left join、right join、full join-版本2
摘要：--1.left join 左表为主表，左表返回全部数据，右表只返回与左表相匹配的数据select t1.fpdm,t1.fphm ,t1.zjr,t1.zjsj,t1.zjjx,t1.zjje,t1.zflx,t1.zfid,t2.fpdm,t2.fphm,t2.zflx from yw_zjfp 阅读全文

posted @ 2017-02-16 21:43 Oracle-fans 阅读(3932) 评论(0) 推荐(0)

谈谈oracle里的join、left join、right join
摘要：create table l as select 'left_1' as str,'1' as v from dual union allselect 'left_2' ,'2' as v from dual union allselect 'left_3' ,'3' as v from dual 阅读全文

posted @ 2017-02-13 22:20 Oracle-fans 阅读(19692) 评论(0) 推荐(0)

查看job的运行日志
摘要：--sys用户执行以下sql语句，查看job的运行日志select t.owner, t.job_name, t.status, to_char(t.actual_start_date, 'yyyy-mm-dd hh24:mi:ss'), t.additional_info, t.error# fr 阅读全文

posted @ 2017-02-03 14:48 Oracle-fans 阅读(14999) 评论(0) 推荐(0)