PLSQL Developer简单使用及常用快捷键

叁歲伎倆 2021-09-28 12:06 3497阅读 0赞

一、**在对象浏览器选择“my objects”**，表示当前用户

注：[https://blog.csdn.net/love\_xsq/article/details/42148891][https_blog.csdn.net_love_xsq_article_details_42148891]

二、执行sql语句快捷键，选中，按F8

注：[https://blog.csdn.net/YHC2113/article/details/80779789][https_blog.csdn.net_YHC2113_article_details_80779789]

三、查看表结构，按住Ctrl键，用鼠标点击表名即显示表结构

注：同上

四、执行插入、修改会涉及到commit、rollback

注：[https://blog.csdn.net/ideality\_hunter/article/details/64444811][https_blog.csdn.net_ideality_hunter_article_details_64444811]

[https://blog.csdn.net/hzhsan/article/details/9719307][https_blog.csdn.net_hzhsan_article_details_9719307]

五、plsql 导出表和表数据

注：[https://blog.csdn.net/pddzming/article/details/78413764][https_blog.csdn.net_pddzming_article_details_78413764]

六：PLSql显示Oracle中存在的所有表

[https://blog.csdn.net/qq\_37385585/article/details/80591659][https_blog.csdn.net_qq_37385585_article_details_80591659]

七：PL/SQL恢复默认窗口样式

[https://blog.csdn.net/hello\_word2/article/details/55212377][https_blog.csdn.net_hello_word2_article_details_55212377]

注：注释快捷键（ctrl+o、ctrl+n）

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xfZGVnZWdl_size_16_color_FFFFFF_t_70][]![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xfZGVnZWdl_size_16_color_FFFFFF_t_70 1][]

八：将当前选项卡设置为全屏（ctrl+f11）

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xfZGVnZWdl_size_16_color_FFFFFF_t_70 2][]

九、添加字段

**1.SQL命令**  
在运行窗口执行SQL “ALTER TABLE TEST ADD A varchar2(20)”  
**2.通过PL/SQL工具**  
a. 选中表名  
b.右键-EDIT  
c.切换到Columns页签，添加新字段，点击apply即可

[https://blog.csdn.net/chenlang02/article/details/75670510][https_blog.csdn.net_chenlang02_article_details_75670510]

十、美化sql按钮

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xfZGVnZWdl_size_16_color_FFFFFF_t_70 3][]

[https_blog.csdn.net_love_xsq_article_details_42148891]: https://blog.csdn.net/love_xsq/article/details/42148891
[https_blog.csdn.net_YHC2113_article_details_80779789]: https://blog.csdn.net/YHC2113/article/details/80779789
[https_blog.csdn.net_ideality_hunter_article_details_64444811]: https://blog.csdn.net/ideality_hunter/article/details/64444811
[https_blog.csdn.net_hzhsan_article_details_9719307]: https://blog.csdn.net/hzhsan/article/details/9719307
[https_blog.csdn.net_pddzming_article_details_78413764]: https://blog.csdn.net/pddzming/article/details/78413764
[https_blog.csdn.net_qq_37385585_article_details_80591659]: https://blog.csdn.net/qq_37385585/article/details/80591659
[https_blog.csdn.net_hello_word2_article_details_55212377]: https://blog.csdn.net/hello_word2/article/details/55212377
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xfZGVnZWdl_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20201209150058211.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xfZGVnZWdl,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xfZGVnZWdl_size_16_color_FFFFFF_t_70 1]: /images/20210923/c6465fa337ec43558670d6bcddbe9794.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xfZGVnZWdl_size_16_color_FFFFFF_t_70 2]: /images/20210923/11786d517b0b43408967f3dcb6653c86.png
[https_blog.csdn.net_chenlang02_article_details_75670510]: https://blog.csdn.net/chenlang02/article/details/75670510
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xfZGVnZWdl_size_16_color_FFFFFF_t_70 3]: /images/20210923/4a90e39a3332474fb33caaf2e159b744.png