sqldeveloper

内容来源
1.help center
2.e12152-08

===========================
快捷键
ctrl+shift+quote(引号键)　　转换选中的单词或字符大小写，大写，小写，首字母大写之间转换
ctrl+d　　清除
ctrl+/　　注释
ctrl+F7　　格式化sql代码

===========================
软件本身单词
properties　　属性
preferences　　首选项，参数
panes 　窗格
tabs　　标签，选项卡
pin　　别针，钉住
detach,move,dock
分离，移动，停靠
find database object pane　　查找数据库对象　　view menu中找

responsible parties　　责任主体
tree view　　树形视图
tabular view　　表格视图
dialog box, tab, or field

tab
pane
navigator
files navigator
reports navigator
connections navigator
tooltip


deprecated　　v. 不赞成；弃用；不宜用
preferred　　adj. 优先的；首选的
添加一个弯头，就是一个节点
elbow　　n. 肘部；弯头；扶手
vertex　　n. 顶点；[昆] 头顶；[天] 天顶
intuitive　　adj. 直觉的；凭直觉获知的
insights　　n. 洞察力；眼力；深刻见解（insight的复数）,思考
deliberately　　adv. 故意地；谨慎地；慎重地
oversimplified　　adj. 过于简单化的
a deliberately oversimplified
patron 　　n. 赞助人；保护人；主顾

两种表示法
bachman notation　　巴赫曼表示法
barker notation
embodies graphically　　生动地体现


============================

1、添加第三方jdbc驱动
Note that to connect to a MySQL database, you must first download the appropriate MySQL connection driver, and then click Tools, then Preferences, and use the SQL Developer user preference pane for Database: Third Party JDBC Drivers to add the driver
2、cart的用途。Cart window

cart与导出向导有相同的作用
cart主要用于重复性的动作
export一次性动作

The dialog boxes and wizards are not presented here in any rigorous order
rigorous    adj. 严格的，严厉的；严密的；严酷的
vehicle
cart


两种copy方式

To copy table data to the clipboard, click the column header (for all column data) or select specific cells and press Ctrl+C;
to copy the column header text along with the table data, press Ctrl+Shift+C


========================================

问题

如果查询某个表时，结果某些中文字是方框，某些正常显示。
选择合适的字体就可以了，preferences>code editor>fonts>cjk sc regular

更改界面语言
刚升级了SQL_DEVELOPER，发现它读取了系统用户默认的语言，出现中文界面，可是那个字体……真叫一个囧啊！
改回英文吧，特地记下改回去的方法，在Oracle官方论坛找到的。
在sqldeveloper\sqldeveloper\bin\sqldeveloper.conf文件中加入
AddVMOption -Duser.language=EN
AddVMOption -Duser.region=US

win8,win2k8自带jdk的sqldeveloper的解压不能启动问题
报错：丢失msvcr100.dll ，不能启动jvm.dll,
总共弹出两个窗口
解决办法如下：
Solution:
    Run regedit as the Administrator
    Expand HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\App Paths
    Add a new Key to App Paths called sqldeveloper.exe
    Set the (Default) value to the full path to the executable (including the executable name).
    Create a new String value for sqldeveloper.exe calledPath and set its value to thejre / bin folder in the SQLDeveloper files.

And here’s what it looks like:
This problem isn’t limited to Oracle SQLDeveloper. It will be common to any application distributed without an installation process that is dependent on a runtime file that was formerly located in the Windows folder.


tools>preferences>database>navigation filter中过滤导航树的项目，即schema对象与非schema对象的显示与否

enter a cell in the grid
in the table data grid

You can copy and paste data between table grid cells and cells in a Microsoft Excel worksheet
grid cells　　网格中的单元格
cells in a microsoft excel worksheet　　单元格

==========================
业务表及字段英文解释
appeal　　投诉，申诉
cashback　　返现
recharge　　充值
withdraw　　提现
waybill　　运单
settlement　　结算
specialline　　专线
freight　　运费
penalty　　罚款，处罚
deduct　　vt. 扣除，减去；演绎
freeze advance amount 　　冻结预付款
refund　　n. 退款；偿还，偿还额


===============================
用过，熟悉的对话框（参考e12152-08）
1.菜单命令-tools-database export　　对话框-export wizard
export ddl中的 add byte keyword,
add force to views　　　　

其中LCPSYS.就是指show schema,

7 BYTE就是指 include BYTE keyword,字节与字符

  CREATE TABLE "LCPSYS"."TEAA"
   (    "FILE#" NUMBER,
    "STATUS" VARCHAR2(7 BYTE),


popup describles　　ctrl+f4

Popup Describe, if the name of a database object is completely selected, displays a
window with tabs and information appropriate for that type of object

 
tools>data modeler>domain administrator,添加，save之后，默认在下面的目录中，找defaultdomains.xml文件，就是了
并可以将此文件复制到其它位置，并重命名。当你创建其它设计时，后面就可以从这个文件中导入domains。
D:\Program Files (x86)\ZIP\sqldeveloper-4.1.5.21.78-x64\sqldeveloper\sqldeveloper\extensions\oracle.datamodeler\types

=================================
使用报告库

先在报告库所在的数据库上执行下面的语句
Create or specify a database schema to hold the reporting repository.

创建data modeler reporting schema

select * from v$tablespace;
create tablespace repo;
create user dm identified by 123456 default tablespace repo;
CREATE OR REPLACE DIRECTORY OSDDM_REPORTS_DIR AS '/home/oracle/repo/';
GRANT READ, WRITE ON DIRECTORY OSDDM_REPORTS_DIR TO dm;
GRANT CREATE SESSION TO dm;
GRANT RESOURCE TO dm;
GRANT CREATE TABLE TO dm;
GRANT CREATE SEQUENCE TO dm;
GRANT CREATE VIEW TO dm;
GRANT CREATE PROCEDURE TO dm;
select * from dba_directories;

##############################
pl/sql加分号的原因

The statement or statements that you intend to execute. For multiple statements, each non-PL/SQL statement must be terminated with either a semicolon or (on a new line) a slash (/), and each PL/SQL statement must be terminated with a slash (/) on a new line. SQL keywords are automatically highlighted. To format the statement, right-click in the statement area and select Format SQL.

Tabs display panes with the following information:

Results: Displays the results of the most recent Execute Statement operation.

Explain: Displays the output if you clicked the Explain Execution Plan icon (see Execution Plan).

Script Output: Displays the output if you clicked the Run Script icon (see Script Runner).

DBMS Output: Displays the output of DBMS_OUTPUT package statements (see DBMS Output Pane).

OWA Output: Displays Oracle Web Agent (MOD_PLSQL) output (see OWA Output Pane).

To toggle the relative heights of the Enter SQL Statement area and the area for tabs and display panes, press Ctrl+Alt+L. You can also manually adjust the heights.


=================================
ssh本地转发
http://blog.csdn.net/sunansheng/article/details/50927687
ssh -L 7001:localhost:389 LdapServerHost

ssh -R 7001:localhost:389 123.138.111.146 -p50090
sqldeveloper的ssh连接，先在ssh windows中建立ssh连接，只能建立本地端口连接，然后在数据库连接中选择。
ssh server上不需要做什么
端口转发默认是开启的
105 #AllowAgentForwarding yes
106 #AllowTcpForwarding yes
除非要关
AllowTcpForwarding no
107 GatewayPorts no//与这个没有关系

ssh hosts中的ssh连接如果断了，db连接也会断

===============================

X11forward

只要xserver中的显示号与windows中的putty中的x11的显示号一样就可以了，与xclient中的display无关
这三个号
Xming server:16.0
localhost:16.0
[root@oracle4 ~]# echo $DISPLAY
localhost:10.0

========================================

help center中的内容

unit testing

startup action    启动动作
teardown action    拆除动作
commissions    n. [会计] 佣金，[会计] 手续费；现金奖励情况（commission的复数）
bonus    n. 奖金；红利；额外津贴
Clashes    冲突，碰撞
decomposition     n. 分解，腐烂；变质
coverage    n. 覆盖，覆盖范围；新闻报道
reasonableness    n. 合理；妥当
incorporating    v. 合并（incorporate的ing形式）

create role UT_REPO_ADMINISTRATOR;
create role UT_REPO_USER;
grant create public synonym,drop public synonym to UT_REPO_ADMINISTRATOR;
grant select on dba_role_privs to UT_REPO_USER;
grant select on dba_role_privs to UT_REPO_ADMINISTRATOR;
grant select on dba_roles to UT_REPO_ADMINISTRATOR;
grant select on dba_roles to UT_REPO_USER;
grant select on dba_tab_privs to UT_REPO_ADMINISTRATOR;
grant select on dba_tab_privs to UT_REPO_USER;
grant execute on dbms_lock to UT_REPO_ADMINISTRATOR;
grant execute on dbms_lock to UT_REPO_USER;
grant UT_REPO_USER to UT_REPO_ADMINISTRATOR with admin option;
grant UT_REPO_ADMINISTRATOR to "LOG1" with admin option;

========================================