plsqldeveloper:pl/sql developer工具几点妙用来源: 发布时间:星期三, 2008年12月17日 浏览:2次 评论:0
="t18">
相对而言 ![]() ![]() ![]() ![]() ![]() ![]() ![]() 但在查看过程或索引、分区等时 ![]() ![]() ![]() 个人认为:pl/sql developer 是所有oracle第 3方客户端软件Software中最方便使用者的 ![]() ![]() 不动就锁死屏幕不知好出多少倍 ![]() ![]() ![]() ![]() ![]() 输入命令或较长 ![]() ![]() ![]() 过许多人都打错它俩 ![]() ![]() ![]() ![]() ![]() 在pl/sql developer中这晃晃 ![]() ![]() ![]() ![]() ![]() 气恼的下 ![]() http://www.allroundautomations.nl/plsqldev.html后, ![]() ![]() 最后终于看到了 ![]() ![]() ![]() 功能描述如下: PL/Shortcuts A handy utility that can help you ![]() things over and over again. You can create your own ![]() 'select * from') and as soon as you type a ![]() immediately replaced by the corresponding text. New version! (Fixes Ctrl-Tab problem) Developed by Tiger Requirements Download PL/SQL Developer 2.1 ![]() 迫不及待 ![]() ![]() 解压 ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() 帮助文件如下: Shortcuts PL/SQL Developer Plug-In Just copy ![]() ![]() ------------------------------------------------------------------ 安装完毕 ![]() 菜单多出个 plugIns/ ![]() 选的 ![]() ![]() 比如设 QQ=SELECT * FROM 那你在窗口中输入qq按空格 SELECT * FROM 就出来了 ![]() ![]() 我设个 bb=bb_service_relation_t 以后按 输入bb及空格就出来跳出 bb_service_relation_t来 ![]() ![]() ![]() ![]() ![]() ![]() ------------------------------------------------------------------ 注:Toad 中自带如样 ![]() 我 ![]() ![]() ![]() 文件名: ![]() /*qquser开头 ![]() ![]() ![]() qquser=select a.apply_start_date,a.service_start_date,a.service_invalid_date, a.user_id,a. ![]() from bb_service_relation_t a where service_id= SKINd=service_kind bsmenu=bs_favour_menu_t qq=SELECT * FROM bfg=bf_gather_fee_t bfgh=bf_gather_fee_his_t c_c=city_code f_d=fee_date bbms=bb_month_service_relation_t bbs=bb_service_relation_t qqlog=SELECT * FROM wcr_log_t WHERE TO_CHAR(report_time,'YYYYMMDD')=TO_CHAR(sysdate,'YYYYMMDD'); space=-----------------空行 ![]() remn=-------------------------------------------------------------------------------------------- s_k=service_kind s_b=special_bill s_id=service_id u_id=user_id a_id=account_id bbp=bb_user_prodUCt_info_t rent=hnrpt_unicom_rent_mobile_t bus=bb_bus_info_t busd=bb_bus_detail_t; event=apply_event statust=bb_serving_status_t 查=select * from bb_service_relation_t where service_id=' allfee =fee1+fee2+fee3+fee4+fee11+fee12+fee13+fee14 rent_his=hnrpt_month_all_rent_his_t his=hnrpt_month_all_rent_his_t qqc=select count(*) from pmon=TO_CHAR(ADD_MONTHS(SYSDATE,-1),'YYYYMM') ren=hnrpt_unicom_rent_mobile_t 传仁=bb_weicr_bus_info_change_t; 附:很多人都认为用pl/sql developer查询时 ![]() ![]() ![]() ![]() ![]() 其实 ![]() ![]() ![]() ![]() 实现思路方法:/Tool/Preferences/SQL Windows/选中 Auto Select Statement 确定后即可 ![]() 快键是 F8 而不是 CTR+回车 想用CTR+回车可如下设置 /Tool/Preferences/key configuration/ 设 ![]() ![]() 0
相关文章
读者评论
发表评论 |