using(select+)+oracle,copy from.. to..using后跟的select是否不能太复杂了?

最新推荐文章于 2023-02-20 11:00:46 发布
最新推荐文章于 2023-02-20 11:00:46 发布
阅读量106 收藏
点赞数
文章标签： using(select+)+oracle

SUM(ab1101.rab_stp_fa_cs_v_iub_aal2 + ab1101.rab_stp_fa_cs_co_iub_aal2 +

ab1101.rab_stp_fa_cs_st_iub_aal2 + ab1101.rab_stp_fa_ps_st_iub_aal2) iub_block_ratio_x,

SUM((ab1101.avg_rab_hld_tm_cs_voice) / (ab1101.period_duration * 100 * 60)) amr_erland,

SUM((ab1101.rab_hold_time_cs_conv_64) / (ab1101.period_duration * 100 * 60)) vp_erland

FROM   bsc_ps_servlev_mnc1_raw ab1101,

object         bsc,

object         bts,

object         cell

WHERE  bsc.co_gid = ab1101.bsc_id

AND    bts.co_gid = ab1101.wbts_id

AND    cell.co_gid = ab1101.cel_id

and bsc.co_name like DECODE('&&aaa','','aaa%','&&aaa')

AND    ab1101.period_start_time  >= decode(to_date('&&startDATE_yyyymmdd','yyyy-mm-dd'),'',TRUNC(SYSDATE-1,'dd'),to_date('&&startDATE_yyyymmdd','yyyy-mm-dd'))

AND    ab1101.period_start_time < decode(to_date('&&endDATE_yyyymmdd','yyyy-mm-dd'),'',TRUNC(SYSDATE,'dd'),to_date('&&endDATE_yyyymmdd','yyyy-mm-dd'))

GROUP  BY to_char(ab1101.period_start_time,'yyyy-mm-dd'),

bsc.co_name,

bts.co_object_instance,

cell.co_object_instance) ab1101,

(SELECT bsc.co_name  bsc_id,

bts.co_object_instance  bts_id,

cell.co_object_instance cell_id

,

to_date(to_char(ab1102.period_start_time,'yyyy-mm-dd'),'yyyy-mm-dd') pdate,

SUM(ab1102.allo_success_edch_int + ab1102.allo_success_edch_bgr) hsupa_rab_setup_succ_ratio_x,

SUM(ab1102.allo_success_edch_int + ab1102.allo_success_edch_bgr + ab1102.setup_fa_edch_ue_int +

ab1102.setup_fa_edch_ue_bgr) hsupa_rab_setup_succ_ratio_y

FROM   bsc_ps_traffic_mnc1_raw ab1102,

object         bsc,

object         bts,

object         cell

WHERE  bsc.co_gid = ab1102.bsc_id

AND    bts.co_gid = ab1102.wbts_id

AND    cell.co_gid = ab1102.cel_id

and bsc.co_name like DECODE('&&aaa','','aaa%','&&aaa')

AND    ab1102.period_start_time  >=decode(to_date('&&startDATE_yyyymmdd','yyyy-mm-dd'),'',TRUNC(SYSDATE-1,'dd'),to_date('&&startDATE_yyyymmdd','yyyy-mm-dd'))

AND    ab1102.period_start_time < decode(to_date('&&endDATE_yyyymmdd','yyyy-mm-dd'),'',TRUNC(SYSDATE,'dd'),to_date('&&endDATE_yyyymmdd','yyyy-mm-dd'))

GROUP  BY to_char(ab1102.period_start_time,'yyyy-mm-dd'),

bsc.co_name,

bts.co_object_instance,

cell.co_object_instance) ab1102,

(SELECT bsc.co_name   bsc_id,

bts.co_object_instance bts_id,

cell.co_object_instance cell_id,

to_date(to_char(ab1106.period_start_time,'yyyy-mm-dd'),'yyyy-mm-dd') pdate,

SUM(ab1106.succ_rb_setup_hsdpa) hsdpa_rab_setup_succ_ratio_x,

SUM(ab1106.att_rb_setup_hsdpa) hsdpa_rab_setup_succ_ratio_y,

SUM(0) intsys_amr_out_succ_ratio_y2

FROM   bsc_ps_rr_mnc1_raw ab1106,

object     bsc,

object     bts,

object     cell

WHERE  bsc.co_gid = ab1106.bsc_id

AND    bts.co_gid = ab1106.wbts_id

AND    cell.co_gid = ab1106.cel_id

and bsc.co_name like DECODE('&&aaa','','aaa%','&&aaa')

AND    ab1106.period_start_time  >= decode(to_date('&&startDATE_yyyymmdd','yyyy-mm-dd'),'',TRUNC(SYSDATE-1,'dd'),to_date('&&startDATE_yyyymmdd','yyyy-mm-dd'))

AND    ab1106.period_start_time < decode(to_date('&&endDATE_yyyymmdd','yyyy-mm-dd'),'',TRUNC(SYSDATE,'dd'),to_date('&&endDATE_yyyymmdd','yyyy-mm-dd'))

GROUP  BY to_char(ab1106.period_start_time,'yyyy-mm-dd'),

bsc.co_name,

bts.co_object_instance,

cell.co_object_instance) ab1106,

(SELECT bsc.co_name  bsc_id,

bts.co_object_instance  bts_id,

cell.co_object_instance cell_id

,

to_date(to_char(ab1122.period_start_time,'yyyy-mm-dd'),'yyyy-mm-dd') pdate,

SUM(ab1122.ps_rel_rl_fa_hs_e_int + ab1122.ps_rel_rl_fa_hs_e_bgr + ab1122.ps_rel_rl_fa_hs_d_int +

ab1122.ps_rel_rl_fa_hs_d_bgr + ab1122.ps_rel_oth_fa_hs_e_int + ab1122.ps_rel_oth_fa_hs_e_bgr +

ab1122.ps_rel_oth_fa_hs_d_int + ab1122.ps_rel_oth_fa_hs_d_bgr) hsdpa_drop_ratio_x,

SUM(ab1122.ps_rel_rl_fa_hs_e_int + ab1122.ps_rel_rl_fa_hs_e_bgr + ab1122.ps_rel_rl_fa_hs_d_int +

ab1122.ps_rel_rl_fa_hs_d_bgr + ab1122.ps_rel_oth_fa_hs_e_int + ab1122.ps_rel_oth_fa_hs_e_bgr +

ab1122.ps_rel_oth_fa_hs_d_int + ab1122.ps_rel_oth_fa_hs_d_bgr + ab1122.ps_rel_norm_hs_e_int +

ab1122.ps_rel_norm_hs_e_bgr + ab1122.ps_rel_norm_hs_d_int + ab1122.ps_rel_norm_hs_d_bgr +

ab1122.ps_swi_hs_e_to_d_d_int + ab1122.ps_swi_hs_e_to_d_d_bgr + ab1122.ps_swi_hs_d_to_d_d_int +

ab1122.ps_swi_hs_d_to_d_d_bgr) hsdpa_drop_ratio_y

,

SUM(ab1122.ps_rel_rl_fa_hs_e_int + ab1122.ps_rel_rl_fa_hs_e_bgr + ab1122.ps_rel_oth_fa_hs_e_int +

ab1122.ps_rel_oth_fa_hs_e_bgr) hsupa_drop_ratio_x,

SUM(ab1122.ps_rel_rl_fa_hs_e_int + ab1122.ps_rel_rl_fa_hs_e_bgr + ab1122.ps_rel_oth_fa_hs_e_int +

ab1122.ps_rel_oth_fa_hs_e_bgr + ab1122.ps_rel_norm_hs_e_int + ab1122.ps_rel_norm_hs_e_bgr +

ab1122.ps_swi_hs_e_to_d_d_int + ab1122.ps_swi_hs_e_to_d_d_bgr) hsupa_drop_ratio_y

FROM   bsc_ps_pktcall_mnc1_raw ab1122,

object         bsc,

object         bts,

object         cell

WHERE  bsc.co_gid = ab1122.bsc_id

AND    bts.co_gid = ab1122.wbts_id

AND    cell.co_gid = ab1122.cel_id

and bsc.co_name like DECODE('&&aaa','','aaa%','&&aaa')

AND    ab1122.period_start_time  >= decode(to_date('&&startDATE_yyyymmdd','yyyy-mm-dd'),'',TRUNC(SYSDATE-1,'dd'),to_date('&&startDATE_yyyymmdd','yyyy-mm-dd'))

AND    ab1122.period_start_time < decode(to_date('&&endDATE_yyyymmdd','yyyy-mm-dd'),'',TRUNC(SYSDATE,'dd'),to_date('&&endDATE_yyyymmdd','yyyy-mm-dd'))

GROUP  BY to_char(ab1122.period_start_time,'yyyy-mm-dd'),

bsc.co_name,

bts.co_object_instance,

cell.co_object_instance) ab1122,

(SELECT bsc.co_name  bsc_id,

bts.co_object_instance  bts_id,

cell.co_object_instance cell_id

,

to_date(to_char(ab1107.period_start_time,'yyyy-mm-dd'),'yyyy-mm-dd') pdate,

SUM(ab1107.succ_updates_on_sho_for_rt + ab1107.succ_updates_on_sho_for_nrt) sho_succ_ratio_x,

SUM(ab1107.cell_add_req_on_sho_for_rt + ab1107.cell_del_req_on_sho_for_rt +

ab1107.cell_repl_req_on_sho_for_rt + ab1107.cell_add_req_on_sho_for_nrt +

ab1107.cell_del_req_on_sho_for_nrt + ab1107.cell_repl_req_on_sho_for_nrt) sho_succ_ratio_y

FROM   bsc_ps_softho_mnc1_raw ab1107,

object        bsc,

object        bts,

object        cell

WHERE  bsc.co_gid = ab1107.bsc_id

AND    bts.co_gid = ab1107.wbts_id

AND    cell.co_gid = ab1107.cel_id

and bsc.co_name like DECODE('&&aaa','','aaa%','&&aaa')

AND    ab1107.period_start_time  >= decode(to_date('&&startDATE_yyyymmdd','yyyy-mm-dd'),'',TRUNC(SYSDATE-1,'dd'),to_date('&&startDATE_yyyymmdd','yyyy-mm-dd'))

AND    ab1107.period_start_time < decode(to_date('&&endDATE_yyyymmdd','yyyy-mm-dd'),'',TRUNC(SYSDATE,'dd'),to_date('&&endDATE_yyyymmdd','yyyy-mm-dd'))

GROUP  BY to_char(ab1107.period_start_time,'yyyy-mm-dd'),

bsc.co_name,

bts.co_object_instance,

cell.co_object_instance) ab1107,

(SELECT bsc.co_name   bsc_id,

bts.co_object_instance bts_id,

cell.co_object_instance cell_id,

to_date(to_char(ab1108.period_start_time,'yyyy-mm-dd'),'yyyy-mm-dd') pdate,

SUM(ab1108.succ_if_hho_ul_dch_q_rt + ab1108.succ_if_hho_ue_trx_pwr_rt + ab1108.succ_if_hho_dl_dpch_pwr_rt +

ab1108.succ_if_hho_cpich_rscp_rt + ab1108.succ_if_hho_cpich_ecno_rt + ab1108.succ_if_hho_im_ims_rt +

ab1108.succ_if_hho_lb_res_lim_rt + ab1108.succ_if_hho_lb_prx_tot_rt + ab1108.succ_if_hho_lb_ptx_tot_rt +

ab1108.succ_if_hho_sb_rt + ab1108.succ_if_hho_lb_rsvr_sc_rt + ab1108.succ_if_hho_lb_capa_ul_rt +

ab1108.succ_if_hho_lb_capa_dl_rt + ab1108.succ_if_hho_ul_dch_q_nrt + ab1108.succ_if_hho_ue_trx_pwr_nrt +

ab1108.succ_if_hho_dl_dpch_pwr_nrt + ab1108.succ_if_hho_cpich_rscp_nrt +

ab1108.succ_if_hho_cpich_ecno_nrt + ab1108.succ_if_hho_im_ims_nrt + ab1108.succ_if_hho_lb_res_lim_nrt +

ab1108.succ_if_hho_lb_prx_tot_nrt + ab1108.succ_if_hho_lb_ptx_tot_nrt + ab1108.succ_if_hho_sb_nrt +

ab1108.succ_if_hho_lb_rsvr_sc_nrt + ab1108.succ_if_hho_lb_capa_ul_nrt +

ab1108.succ_if_hho_lb_capa_dl_nrt) ifho_succ_ratio_x,

SUM(ab1108.if_hho_att_ul_dch_q_rt + ab1108.if_hho_att_ue_trx_pwr_rt + ab1108.if_hho_att_dl_dpch_pwr_rt +

ab1108.if_hho_att_cpich_rscp_rt + ab1108.if_hho_att_cpich_ecno_rt + ab1108.if_hho_att_im_ims_rt +

ab1108.if_hho_att_lb_res_lim_rt + ab1108.if_hho_att_lb_prx_tot_rt + ab1108.if_hho_att_lb_ptx_tot_rt +

ab1108.if_hho_att_sb_rt + ab1108.if_hho_att_lb_rsvr_sc_rt + ab1108.if_hho_att_lb_capa_ul_rt +

ab1108.if_hho_att_lb_capa_dl_rt + ab1108.if_hho_att_ul_dch_q_nrt + ab1108.if_hho_att_ue_trx_pwr_nrt +

ab1108.if_hho_att_dl_dpch_pwr_nrt + ab1108.if_hho_att_cpich_rscp_nrt + ab1108.if_hho_att_cpich_ecno_nrt +

ab1108.if_hho_att_im_ims_nrt + ab1108.if_hho_att_lb_res_lim_nrt + ab1108.if_hho_att_lb_prx_tot_nrt +

ab1108.if_hho_att_lb_ptx_tot_nrt + ab1108.if_hho_att_sb_nrt + ab1108.if_hho_att_lb_rsvr_sc_nrt +

ab1108.if_hho_att_lb_capa_ul_nrt + ab1108.if_hho_att_lb_capa_dl_nrt) ifho_succ_ratio_y

FROM   bsc_ps_intsysho_mnc1_raw ab1108,

object          bsc,

object          bts,

object          cell

WHERE  bsc.co_gid = ab1108.bsc_id

AND    bts.co_gid = ab1108.wbts_id

AND    cell.co_gid = ab1108.cel_id

and bsc.co_name like DECODE('&&aaa','','aaa%','&&aaa')

AND    ab1108.period_start_time  >= decode(to_date('&&startDATE_yyyymmdd','yyyy-mm-dd'),'',TRUNC(SYSDATE-1,'dd'),to_date('&&startDATE_yyyymmdd','yyyy-mm-dd'))

AND    ab1108.period_start_time < decode(to_date('&&endDATE_yyyymmdd','yyyy-mm-dd'),'',TRUNC(SYSDATE,'dd'),to_date('&&endDATE_yyyymmdd','yyyy-mm-dd'))

GROUP  BY to_char(ab1108.period_start_time,'yyyy-mm-dd'),

bsc.co_name,

bts.co_object_instance,

cell.co_object_instance) ab1108,

(SELECT bsc.co_name   bsc_id,

bts.co_object_instance bts_id,

cell.co_object_instance cell_id,

to_date(to_char(ab1110.period_start_time,'yyyy-mm-dd'),'yyyy-mm-dd') pdate,

SUM(ab1110.is_hho_cs_rt_success) intsys_amr_out_succ_ratio_x,

SUM(ab1110.is_hho_cs_rt_attempts - ab1110.utran_not_able_exec_ishho_rt) intsys_amr_out_succ_ratio_y

,

SUM(ab1110.succ_is_hho_ul_dch_q_nrt + ab1110.succ_is_hho_ue_trx_pwr_nrt + ab1110.succ_is_hho_dl_dpch_pwr_nrt +

ab1110.succ_is_hho_cpich_rscp_nrt + ab1110.succ_is_hho_cpich_ecno_nrt + ab1110.succ_is_hho_im_ims_nrt +

ab1110.succ_is_hho_lb_capa_dl_nrt + ab1110.succ_is_hho_lb_capa_ul_nrt +

ab1110.succ_is_hho_lb_prx_tot_nrt + ab1110.succ_is_hho_lb_ptx_tot_nrt +

ab1110.succ_is_hho_lb_res_lim_nrt + ab1110.succ_is_hho_lb_rsvr_sc_nrt + ab1110.succ_is_hho_sb_nrt) intsys_ps_out_succ_ratio_x,

SUM(ab1110.is_hho_att_ul_dch_q_nrt + ab1110.is_hho_att_ue_trx_pwr_nrt + ab1110.is_hho_att_dl_dpch_pwr_nrt +

ab1110.is_hho_att_cpich_rscp_nrt + ab1110.is_hho_att_cpich_ecno_nrt + ab1110.is_hho_att_im_ims_nrt +

ab1110.is_hho_att_lb_capa_dl_nrt + ab1110.is_hho_att_lb_capa_ul_nrt + ab1110.is_hho_att_lb_prx_tot_nrt +

ab1110.is_hho_att_lb_ptx_tot_nrt + ab1110.is_hho_att_lb_res_lim_nrt + ab1110.is_hho_att_lb_rsvr_sc_nrt +

ab1110.is_hho_att_sb_nrt) intsys_ps_out_succ_ratio_y

FROM   bsc_ps_intersho_mnc1_raw ab1110,

object          bsc,

object          bts,

object          cell

WHERE  bsc.co_gid = ab1110.bsc_id

AND    bts.co_gid = ab1110.wbts_id

AND    cell.co_gid = ab1110.cel_id

and bsc.co_name like DECODE('&&aaa','','aaa%','&&aaa')

AND    ab1110.period_start_time  >= decode(to_date('&&startDATE_yyyymmdd','yyyy-mm-dd'),'',TRUNC(SYSDATE-1,'dd'),to_date('&&startDATE_yyyymmdd','yyyy-mm-dd'))

AND    ab1110.period_start_time < decode(to_date('&&endDATE_yyyymmdd','yyyy-mm-dd'),'',TRUNC(SYSDATE,'dd'),to_date('&&endDATE_yyyymmdd','yyyy-mm-dd'))

GROUP  BY to_char(ab1110.period_start_time,'yyyy-mm-dd'),

bsc.co_name,

bts.co_object_instance,

cell.co_object_instance) ab1110,

(SELECT bsc.co_name  bsc_id,

bts.co_object_instance  bts_id,

cell.co_object_instance cell_id

,

to_date(to_char(ab1123.period_start_time,'yyyy-mm-dd'),'yyyy-mm-dd') pdate,

SUM(ab1123.nrt_dch_dl_data_vol / 1000000) ps_r99_dl_throughput,

SUM((ab1123.nrt_dch_ul_data_vol + ab1123.nrt_dch_hsdpa_ul_data_vol) / 1000000) ps_r99_ul_throughput,

SUM(ab1123.hs_dsch_data_vol / 1000000) hsdpa_throughput,

SUM(ab1123.nrt_edch_ul_data_vol / 1000000) hsupa_throughput

FROM   bsc_ps_celltp_mnc1_raw ab1123,

object        bsc,

object        bts,

object        cell

WHERE  bsc.co_gid = ab1123.bsc_id

AND    bts.co_gid = ab1123.wbts_id

AND    cell.co_gid = ab1123.cel_id

and bsc.co_name like DECODE('&&aaa','','aaa%','&&aaa')

AND    ab1123.period_start_time  >= decode(to_date('&&startDATE_yyyymmdd','yyyy-mm-dd'),'',TRUNC(SYSDATE-1,'dd'),to_date('&&startDATE_yyyymmdd','yyyy-mm-dd'))

AND    ab1123.period_start_time < decode(to_date('&&endDATE_yyyymmdd','yyyy-mm-dd'),'',TRUNC(SYSDATE,'dd'),to_date('&&endDATE_yyyymmdd','yyyy-mm-dd'))

GROUP  BY to_char(ab1123.period_start_time,'yyyy-mm-dd'),

bsc.co_name,

bts.co_object_instance,

cell.co_object_instance) ab1123

WHERE  ab1123.bsc_id(+) = ab1100.bsc_id

AND    ab1106.bsc_id(+) = ab1100.bsc_id

AND    ab1110.bsc_id(+) = ab1100.bsc_id

AND    ab1102.bsc_id(+) = ab1100.bsc_id

AND    ab1107.bsc_id(+) = ab1100.bsc_id

AND    ab1108.bsc_id(+) = ab1100.bsc_id

AND    ab1101.bsc_id(+) = ab1100.bsc_id

AND    ab1123.bts_id(+) = ab1100.bts_id

AND    ab1106.bts_id(+) = ab1100.bts_id

AND    ab1122.bts_id(+) = ab1100.bts_id

AND    ab1110.bts_id(+) = ab1100.bts_id

AND    ab1102.bts_id(+) = ab1100.bts_id

AND    ab1107.bts_id(+) = ab1100.bts_id

AND    ab1108.bts_id(+) = ab1100.bts_id

AND    ab1101.bts_id(+) = ab1100.bts_id

AND    ab1123.cell_id(+) = ab1100.cell_id

AND    ab1106.cell_id(+) = ab1100.cell_id

AND    ab1122.cell_id(+) = ab1100.cell_id

AND    ab1110.cell_id(+) = ab1100.cell_id

AND    ab1102.cell_id(+) = ab1100.cell_id

AND    ab1107.cell_id(+) = ab1100.cell_id

AND    ab1108.cell_id(+) = ab1100.cell_id

AND    ab1101.cell_id(+) = ab1100.cell_id

;

weixin_39961636
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
Oracle中Using用法
10-27
Oracle 动态SQL介绍以及using用法示例
vs使用c#开发连接oracle数据库,Oracle.ManagedDataAccess.dll,无需安装oracle客户端
05-18
using Oracle.ManagedDataAccess.Client; private readonly string strConnection = @"Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=数据库名称)));...
SELECT INTO using Oracle
masuwen博客
03-23 926
If NEW_TABLE already exists then ... insert into new_table select * from old_table / If you want to create NEW_TABLE based on the records in OLD_TABLE ... create table new_table as select * from old...
using()用法
qq_38213692的博客
12-15 363
##using()用法 用于两张表的join查询，要求using()指定的列在两个表中均存在，用其对两个表进行等值查询 SELECT * FROM bigdata_motor.course a JOIN bigdata_motor.student_score b USING(c_id); 等价于 下面展示一些 内联代码片。 SELECT * FROM bigdata_motor.course a JOIN bigdata_motor.student_score b USING(c_id) ; // A
oracle使用using关键
ImezZ
03-22 6538
转自：https://www.2cto.com/database/201503/384694.htmlsql/92标准可以使用using关键字来简化连接查询，但是只是在查询满足下面两个条件时，才能使用using关键字进行简化。1.查询必须是等值连接。2.等值连接中的列必须具有相同的名称和数据类型。例如：使用using关键字，如下：1234567891011121314151617181920212...
SQL(use_select)
weixin_34273095的博客
02-09 179
C:\ProgramData\MySQL\MySQL Server 5.5\data UPDATE: 修改 *修改数据库的字符集 *alter database 数据库名称 alter database db6 character set utf8; show create database db6; 删除数据库 drop database 数据库名称； 判断数据库存在，存在再删除 drop database if exists 数据库名称； show database if exists db3; 使
oracle-oracle driver for go using database+sql-项目分享.zip
最新发布
01-25
本项目"oracle_oracle driver for go using database+sql"正是为了解决这个问题，它提供了Go语言访问Oracle数据库的接口。 项目的核心是`database/sql`包，这是Go标准库的一部分，提供了一个通用的SQL数据库接口。...
Oracle.ManagedDataAccess.dll.rar
10-09
Oracle.ManagedDataAccess.dll是Oracle公司为.NET开发者提供的一个托管数据访问组件，它允许C#等.NET语言的应用程序直接与Oracle数据库进行交互，无需依赖传统的Oracle客户端软件。这个RAR压缩包包含了两个不同版本...
Select Multiple Values from Combobox Using JavaScript.zip
11-08
这个压缩包“Select Multiple Values from Combobox Using JavaScript.zip”很可能包含了一个简单的示例，演示如何使用JavaScript来实现多选下拉列表的功能。在网页中，这种功能通常通过HTML的`<select>`元素配合`...
Using+Xgboost+to+predict+sales.html
05-04
如何使用xgboost实战kaggle竞赛，涉及到参数优化，交叉验证，数据预处理等完整步骤，看来后，保证你能使用xgboost进行一个完整的模型训练。
SQL使用using关键字详解
热门推荐
shadow_zed的博客
04-08 3万+
sql/92标准可以使用using关键字来简化连接查询，但是只是在查询满足下面两个条件时，才能使 用using关键字进行简化。1.查询必须是等值连接。2.等值连接中的列必须具有相同的名称和数据类型。 例如：使用using关键字，如下： select emptno,ename,sal,deptno,dname from emp e inner join dept d using(deptno);...
merge into 当using后的select结果为空时，不能执行update和insert
一生为追梦的博客
11-18 7209
今天突然发现merge into功能不起作用了，在网上找了半天，发现是merge into的一个固有bug。 无效语句如下：merge into T_WORK_DRZJ a using (select * from T_WORK_DRZJ b where b.ygbh=22209 and b.rq=20151117) on (a.ygbh = 22209 and a.rq=20151117)
Mysql using 用法
wgchen
02-16 1万+
Mysql using 用法...
SQL之SELECT FROM
Upgrade_Surprise的博客
02-20 4104
MYSQL SELECT的几种基础操作，让你轻松学会MYSQL的基础查询。
using(select+)+oracle,Oracle SQL - Generate aggregate rows for certain rows using select
weixin_39640203的博客
04-07 38
I see you already accepted an answer, but you did ask for a solution that did not involve UNION. One such solution would be to use GROUPING SETS.GROUPING SETS allow you to specify different grouping l...
SQL的USING()函数
stringKai的博客
03-07 6229
SELECT * from book join borrow USING(book_id); SELECT * from book join borrow where book.book_id=borrow.book_id; 这两条sql语句等价(但第二条语句会查出两个book_id列) using()函数的作用是简化等值连接. ...
Mysql之using用法
好吗好的~的技术博客
09-09 2万+
在平时，我们做关联表查询的时候一般是这样的 select * from 表1 inner join 表2 on 表1.相同的列=表2.相同的列; 然后可以改成这样也是同样的效果 select 表1的列 from 表1 inner join 表2 on 表1.相同的列=表2 .相同的列   然后还可以改成这样 select * from 表1 inner join 表2 using...
oracle中copy from的用法
cqh520llr的专栏
04-22 3186
[code="java"] 1.语法及使用说明 1.1 语法 下面我们来看一下SQL*Copy Command的语法及使用说明。 在解释SQL*Plus Copy Command的语法之前，我们必须要明确SQL*Plus Copy Command不是一个方法或是函数，也不是一个SQL语句，它是一个命令(command)，当然这个命令必须在SQL*Plus里运行。 SQL*Plus C...
Logging+system+failed+to+initialize+using+configuration+from+'classpath:log4j.xml'
09-28
这个问题的原因可能是找不到或无法加载 log4j.xml 配置文件。请确保该文件存在于类路径下，并检查文件的访问权限。另外，还需要确认该文件是否正确配置了日志系统的相关信息。 相关问题: 1. 如何设置 log4j.xml ...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值