pl/sql developer 9.0新特性

9680阅读 0评论2011-05-29 zhongtang
分类:Oracle

今天登陆plsql提示有9.0beta版出来了,于是去看了看他的新特性,还真发现几个比较实用的更新。

挑了几个感兴趣的特性意译了下,E文好的朋友还是去看原文吧。

Ok,follow me ……

What's new in 9.0?

Multiple simultaneous connections

The major new feature in PL/SQL Developer 9.0 is that you can now be connected with more than one user at more than one database at a time. Each window has its own connection, and you can easily switch the connection of a window by using the connection selector at the bottom-left of the window:

最重要的新特性:支持多连接,多用户,多数据库。

每一个窗口都有它自己的连接,而且在窗口的底部有连接切换器,可以方便的切换当前连接。

Support for multiple connections can be enabled or disabled through a preference. When disabled, behavior reverts to 8.0 and earlier behavior where changing the PL/SQL Developer connection also changes the connection of all windows.

Connection List

The new Connection List allows you to quickly access connections from a dockable or floating tool:

连接列表浮动窗口允许你快速切换连接。

The connection list gives you a quick overview of all connections and their associated windows. Connections will automatically be added to the list when logging on, but they can also be explicitly added as a user-defined connection. By right-clicking on a connection you can quickly open windows, create objects, and launch tools for a connection:

You can explicitly define connections and connection folders by pressing the "Define Connections" button. For each connection you can define the display name, username, password, database, sysdba/sysoper connection, or whether the connection is identified externally:

使用“自定义连接”可以手动建立连接或连接文件夹,每个连接都可以自定义显示名,数据库用户名,密码,数据库等。

If the password is omitted, PL/SQL Developer will prompt you for the password when the connection is used. For connection folders you can define a display name and optionally the criteria to automatically add connections to the folder. You can for example specify "SYS*" for the username to indicate that all connections for users that start with "SYS" should automatically be added to a folder:

如果某连接设置中密码未输入,在使用该连接时plsql提示你输入密码。

而且连接文件夹支持按照通配符分组,例如把以sys*开头的连接都分组到system users中。


XLSX format support (Excel 2007 / 2010)

PL/SQL Developer 9.0 adds support for Excel 2007 / 2010 XLSX format for exporting SQL Window result sets and saving Report Window results. Previous Excel formats had a restriction of 65,000 rows so that multiple sheets were required for larger result sets. The XLSX format allows for an unlimited number of rows per sheet. Both the SQL Window and Report Window allow you to explicitly choose between the old XLS format and the new XLSX format:

支持xlsx格式,无论是sql窗口还是报告窗口,都可以选择把结果存成xls或者xlst。

窃以为,这个功能应该算是本次更新中最实用的新特性。

众所周知xls有著名的“65535行数限制”问题,而从excle2007开始新推出的xlst格式已经支持无限制行数,当我们有一个非常大的结果集,现在可以直接save一个sheet里,而在以前,我们只有选择存到多个sheet,或者存到access。


Diagram Window enhancements

The following enhancements have been made to the Diagram Window:

  • Explicitly sort items with drag & drop.
  • Automatically sort items by id or alphabetically.
  • Additional zoom levels for smoother zooming.
  • Show or hide item types at group or diagram level.
  • Table and View level comments included.
Command Window enhancements

The following enhancements have been made to the Command Window:

  • ZIP Archive [File | Directory] command added.
  • Support for SIZE UNLIMITED added for the SET SERVEROUTPUT command.
  • ZIP option added to the SPOOL command.
  • SHOW CONNECTION command added to show information about all connections.
Table Definition Editor enhancements

The table definition editor now supports Oracle11g virtual columns. You can mark a column as virtual, en enter the expression in the Default/Expression field:

表编辑窗口开始支持oracle11g的虚拟列,而且查询结果中某序列的原值一旦更新,结果列会实时更新。

这应该也算是一个重大更新吧。

anyway,虚拟列是啥?呵呵,表问我,还是去翻翻书吧。

In this case the virtual column "email" will return the "ename" lowercase column value followed by "@acme.com".

Other enhancements include:

  • Support for local partitioned indexes added.
  • Support for logging/nologging added.
  • Support for rowdependencies added.
  • Comments can now be edited in a text editor.
SQL Window enhancements

  • You can now lock one or more columns so that they remain visible when the grid is scrolled horizontally. In the example above the "empno" and "ename" key columns are the first 2 columns, but they remain visible even though the grid is scrolled horizontally. You can also scroll lock rows to keep key rows visible or to easily compare 2 rows that are not adjacent.

SQL查询窗口的重大更新:

1.查询结果窗口,支持列、行锁定。例如在横向滚动查询结果时,可以锁定id列不滚动。很方便的一个更新,尤其是结果集列数很多的时候。

又是一个仿excel式的新特性,不得不承认,microsoft非常棒,其某些特性虽然过去多年,还在被模仿。

  • Virtual columns are read-only and will immediately update when you change the value of a source column. In the example above the virtual "email" column is immediately updated to "bates@acme.com" when the "ename" column is changed to "BATES".

2.前文提到的结果集,虚拟列自动更新特性。

  • If a table has a before insert or update trigger that modifies column values, or if the table has default values for newly inserted records, the SQL Window grid will now immediately display these server-generated values after posting the new or modified record.
  • You can now use a "Tab=" comment to define result tab titles. In the example above the first tab is named "All employees" and the second tab is named "DEPT Salary". </LI></UL> <P><FONT color=#0000f0>3.支持自定义结果集表头。用法如下:</FONT></P> <P><FONT color=#0000f0>-- tab=商品字典</FONT></P> <P><FONT color=#0000f0>select * from waredict ;</FONT></P> <P><FONT color=#0000f0>这样结果集就会显示成汉字“商品字典”</FONT></P> <UL> <LI>A function key has been added to invoke the Large Data Editor from the result grid. <LI>The Output Buffer Size can be set to 0 for Unlimited. </LI></UL></TD></TR></TBODY></TABLE></DIV> <TABLE id=table28 border=0 cellSpacing=6 cellPadding=0> <TBODY> <TR> <TD></TD></TR></TBODY></TABLE> <DIV align=left> <TABLE style="WIDTH: 100%" id=table29 class=TABEL1 border=0> <TBODY> <TR> <TD><B class=TITEL>Test Manager enhancements</B> <P class=MsoNormal>The following enhancements have been made to the Test Manager:</P> <UL> <LI>Global variables added to pass variable values from one test script to another. <LI>A "New Session" property is added to isolate test scripts from session state changes. <LI>A Log pane is added on the Run tab page to show variable input and output values. <LI>The definition page now contains a splitter to resize the top and bottom half. </LI></UL></TD></TR></TBODY></TABLE></DIV> <TABLE id=table30 border=0 cellSpacing=6 cellPadding=0> <TBODY> <TR> <TD></TD></TR></TBODY></TABLE> <DIV align=left> <TABLE style="WIDTH: 100%" id=table31 class=TABEL1 border=0> <TBODY> <TR> <TD><B class=TITEL>Editor enhancements</B> <P>The following enhancements have been made to the editors:</P> <UL> <LI>Syntax highlighting now works correctly for alternative quote delimiters. <LI>The Code Assistant is now invoked for database links after typing @. <LI>Code Assistant "Describe Context" queries can now be modified through CANames.sql. <LI>The editor now detects Unicode encoding from the file contents in addition to the file header ("BOM"). <LI>The macro recorder now supports edit functions like Find, Bookmark, and so on. <LI>Ctrl-Del is now assigned to "Editor / Delete next word". </LI></UL></TD></TR></TBODY></TABLE></DIV> <TABLE id=table32 border=0 cellSpacing=6 cellPadding=0> <TBODY> <TR> <TD></TD></TR></TBODY></TABLE> <DIV align=left> <TABLE style="WIDTH: 100%" id=table35 class=TABEL1 border=0> <TBODY> <TR> <TD><B class=TITEL>Object Browser enhancements</B> <P>The following enhancements have been made to the Object Browser:</P> <UL> <LI>A "Suppress owner" property has been added for user-defined Object Browser Folders <LI>The list of users for the User selector can now be limited by specifying a where clause in the Preferences </LI></UL></TD></TR></TBODY></TABLE></DIV> <TABLE id=table36 border=0 cellSpacing=6 cellPadding=0> <TBODY> <TR> <TD></TD></TR></TBODY></TABLE> <DIV align=left> <TABLE style="WIDTH: 100%" id=table71 class=TABEL1 border=0> <TBODY> <TR> <TD><B class=TITEL>File Browser enhancements</B> <P>The following enhancements have been made to the File Browser:</P> <UL> <LI>Popup menu item "Open with" added to open a file with an external program. <LI>Popup menu item "Properties" added to show the file properties. <LI>Popup menu item "Open in Explorer" added to show a file or directory in the Windows Explorer. </LI></UL></TD></TR></TBODY></TABLE></DIV> <TABLE id=table73 border=0 cellSpacing=6 cellPadding=0> <TBODY> <TR> <TD></TD></TR></TBODY></TABLE> <DIV align=left> <TABLE style="WIDTH: 100%" id=table74 class=TABEL1 border=0> <TBODY> <TR> <TD><B class=TITEL>Data Generator enhancements</B> <P>The following enhancements have been made to the Data Generator:</P> <UL> <LI>SQL() expression now accepts bind variables for other field values.<BR>For example: SQL('Department ' || :deptno) <LI>LIST(select) expression now accepts bind variables for other field values.<BR>For example: LIST(select empno from emp where deptno = :deptno) <LI>SQL() expression now accepts a select statement with a single column/row result.<BR>For example: SQL(select count(*) from order_lines where order_id = :order_id) </LI></UL></TD></TR></TBODY></TABLE></DIV> <TABLE id=table72 border=0 cellSpacing=6 cellPadding=0> <TBODY> <TR> <TD></TD></TR></TBODY></TABLE> <DIV align=left> <TABLE style="WIDTH: 100%" id=table37 class=TABEL1 border=0> <TBODY> <TR> <TD><B class=TITEL>Compare User Objects enhancements</B> <P>The Compare User Objects tool now allows you to compare PL/SQL source objects with or without case, white space, and comments. Simply select the corresponding items on the options tab page:</P> <P><IMG border=0 src="http://www.allroundautomations.com/images/pls90compareuser.png" width=629 height=421></P> <P>The difference viewer will also compare with or without case and white space. If you are using your own difference viewer, you can configure which command-line switches need to be used for each option.<BR></P></TD></TR></TBODY></TABLE></DIV> <TABLE id=table46 border=0 cellSpacing=6 cellPadding=0> <TBODY> <TR> <TD></TD></TR></TBODY></TABLE> <TABLE id=table76 border=0 cellSpacing=6 cellPadding=0> <TBODY> <TR> <TD></TD></TR></TBODY></TABLE> <DIV align=left> <TABLE style="WIDTH: 100%" id=table77 class=TABEL1 border=0> <TBODY> <TR> <TD><B class=TITEL>PL/SQL Beautifier enhancements</B> <P>PL/SQL Beautifier enhancements have been postponed to version 9.1 later this year.<BR></P></TD></TR></TBODY></TABLE></DIV></DIV><FONT color=#0000f0>最后一个更新,代码美化器更新到了9.1版本。与之前有什么差别,嘿嘿,发掘中……</FONT></TD></TR></TBODY></TABLE></P> </div> <div class="page">上一篇:<a href="/uid-74941-id-336144.html">TSM常用命令研究之三</a><br> 下一篇:<a href="/uid-74941-id-352470.html">全面解析裸设备</a></div> <footer> <a href="http://blog.itpub.net/">ITPUB博客</a> | <a href="http://www.itpub.net">ITPUB论坛</a> | <a href="http://bbs.chinaunix.net/">chinaunix论坛</a><br> 北京皓辰网域网络信息技术有限公司. 版权所有 </footer> <script> $(function(){ $("#fenlei").click(function(){ $("#left_1").show(); $("#left_2").show(); }); }) </script> </body> </html> <script language="javascript" src="http://stat.it168.com/pv.js"></script> <script> function sendPV(){ var pvTrack = new PvTrack(); pvTrack.type = 35; // 频道类别ID pvTrack.channel = 531; // 频道ID pvTrack.pageType = 0; pvTrack.track(); } window.setTimeout("sendPV()", 1000); </script>