oracle sql developer如何打开多个tab

temp220 2010-10-19 11:15:29

每次打开一张表就替换了上一个

...全文

562 9 打赏收藏转发到动态举报

写回复

用AI写文章

9 条回复

切换为时间正序

请发表友善的回复…

发表回复

xiaoyaobihai 2010-10-20

打赏
举报

使用toad更方便，呵呵

minitoy 2010-10-20

打赏
举报

tools->windows list 是显示打开窗口的列表,便于切换.
楼主是说在sql windows里同时查询几个表?
选中所要执行的所有sql,然后执行就可以了.

inthirties 2010-10-20

打赏
举报

plsql dev里没有tab的概念，打开的都是window。

你可以通过在window菜单里切换。

或者用上面的方法。让window list显示在你的窗口里。

inthirties 2010-10-20

打赏
举报

[Quote=引用 2 楼 zhuomingwang 的回复:]

我也没明白，你是要意思是要查询多个表吗？
你可以现在Tools里把Window List勾上，然后再Window里save layout.
[/Quote]

这个正点。

da21 2010-10-20

打赏
举报

用toad吧

hao1hao2hao3 2010-10-20

打赏
举报

在窗口列表中会显示你打开的所有的表的Tab页。

真的不知道取什么名 2010-10-20

打赏
举报

我也没明白，你是要意思是要查询多个表吗？
你可以现在Tools里把Window List勾上，然后再Window里save layout.

心中的彩虹 2010-10-20

打赏
举报

[Quote=引用楼主 temp220 的回复:]
每次打开一张表就替换了上一个
[/Quote]
打开的是窗口需“工具”--“窗口切换”

Oracle SQL Developer, v1.5.0.54.40 Release Notes 完整版下载：http://www.oracle.com/technology/global/cn/software/products/sql/index.html 1. Known Issues 1.1 General - Print prints only one page that is a truncation of the current tab. - Can't invoke SQL*Plus on Windows 2003. - The menu item, and right-click off a Connection node, for invoking SQL*Plus does not work with connections whose passwords are not persisted. 1.2 Connections - Cannot connect to remote database as OPS$ account. 1.3 Browse - If connected as sys with sysdba role, Types node displays built in data-types (e.g. BLOB, DATE, DECIMAL, etc.) If clicked on, will only see "create or replace". 1.4 Creating and Modifying Objects - Editing Triggers - If you have comments before the 'BEGIN' they will be lost if you edit. You will see when you click edit that they will not be there. To preserve them, they need to be below the BEGIN or you will need to edit via the SQL Worksheet. 1.5 Table > Data - Tables > Your_Table > Data - PageUp and PageDown buttons not working correctly if cursor is in the rownum column. 1.6 Export - Cannot export if result set contains duplicate column names. 2. Workarounds 2.1 To disable Code Insight Run SQL Developer from a command line using the following statement: Windows : sqldeveloper -J-Dsdev.insight=false Linux or Mac: Run sh sqldeveloper -J-Dsdev.insight=false or edit sqldeveloper.conf and add "AddVMOption -J-Dsdev.insight=false" 2.2 If DDL tab is null for all objects in a Connection Your dbms_metadata might be loaded incorrectly. If this statement fails when executed in a SQL Worksheet against the Connection select dbms_metadata.get_ddl('TABLE',table_name , user ) from user_tables; You need to reload $ORACLE_HOME/rdbms/admin/catmeta.sql 2.3 If Snippets are not accessible You may have not done a clean install. SQL Developer needs to be installed into a clean directory, not over a previous release. 3. Accessibility Issues The following is a li

oracle 导出数据字典的小工具能导成word形式的带表格的数据字典，非常好用从网上转载的，不会的可以留言啊

用mapinfo7.8上传tab文件到oracle

PL/SQL Developer 11.0 - New Features Below you can find a brief description of the most important new features in PL/SQL Developer 11.0. New features SQL Window enhancements The result set toolbar has a new Compare records button to easily compare records in the result set: By default this will highlight identical field values in the result set when compared to the current record. If you move to a different row, the highlighted fields will be updated accordingly. Pressing the Compare records button again will clear the highlights. The arrow button next to the Compare records button controls whether identical or different values are highlighted, whether only the current column or all columns of the records are highlighted, and whether the field values are compare case sensitive. In Single Record mode, the SQL Window will now also display the column comments in the result set grid: Other enhancements include: A Refresh result set button has been added to refresh (re-execute) the result set of the currently selected result tab page Column totals (sum, count, min, max, avg) are now persistent after re-executing a query Added Excel exporter (both xls and xlsx support) Support has been added for Oracle12c extended strings (> 4000 bytes) The align button has a new Hide editor option to show only the result set The align button has a new Window width option to resize the SQL Window width to match the result set width You can now use an AltRowColor=[RRGGBB | name] directive in a comment section of the SQL Window to control the alternate row color You can now use a Records=[all|page|] directive in a comment section of the SQL Window to control the number of initially fetched records You can now use a Totals=[mode:column] directive in a comment section of the SQL Window to display column totals

数据库导出表结构的工具 Oracle db export

基础和管理

17,382

社区成员

95,118

社区内容

发帖

与我相关

我的任务

社区管理员

加入社区

近7日
近30日
至今

加载中

查看更多榜单

社区公告

暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章