内容来源
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本地转发
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;
========================================
