Posted on 2012-01-18 18:00
哈希 閱讀(325)
評論(0) 編輯 收藏 所屬分類:
sql 總結
PL/SQL Developer是一個集成開發環境，專門面向Oracle數據庫存儲程序單元的開發。如今，有越來越多的商業邏輯和應用邏輯轉向了Oracle Server，因此，PL/SQL編程也成了整個開發過程的一個重要組成部分。PL/SQL Developer側重于易用性、代碼品質和生產力，充分發揮Oracle應用程序開發過程中的主要優勢。PL/SQL(Procedural Language/SQL)是一種過程化語言，屬于第三代語言，它與C、C++、Java等語言一樣關注于處理細節，可以用來實現比較復雜的業務邏輯。它允許SQL的數據操縱語言和查詢語句包含在塊結構(block_structured)和代碼過程語言中，使PL/SQL成為一個功能強大的事務處理語言。在甲骨文數據庫管理方面，PL/SQL是對結構化查詢語言（SQL）的過程語言擴展。PL/SQL的目的是聯合數據庫語言和過程語言。PL/SQL的基本單位叫做一個區段，由三個部份組成：一個申明部份，一個可運行部份，和排除－構建部分。 因為PL/SQL允許混合SQL申明和過程結構，因此可以在將申明發送到甲骨文系統去執行之前使用PL/SQL區段和副程序來組合SQL申明，沒有PL/SQL，甲骨文需要就每次處理SQL申明，在網絡環境中，這將影響交通流量，而且增加響應時間。PL/SQL區段只被編譯一次并且以可運行的形式儲存，以降低響應時間。
Enhancements in PL/SQL Developer 8.0.4
======================================
* SQL Window would always print SQL text, disregarding "Print SQL"
preference
* Searching within special text (strings, comments) could be slow
* Key Configuration preference could reset to default instead of
using the defined keys when using multiple preference sets
* Export to Excel would interpret data beginning with = as formula
* Column names starting with a digit were not implicitly quoted in
SQL statements
* Fixed issue with search in selection where incorrect characters
could be replaced
* Duplicate items removed from description window
* View/Edit Data for tables with an owner with special characters
would not add quotes to the owner
* UTFE characters were displayed incorrectly when Unicode support
was enabled
* Loading the Macro Library could fail on Windows 7/Vista,
resulting in a "list index out of bounds" error message
* Debugger could hang after an exception on oracle11g
* Code Assistant can now complete database link names
* Copy all to Excel in the SQL Window would not have correct
formatting on the second sheet
* To-Do Item List was not up-to-date when opening a package spec &
body
下載地址如下
源程序：
http://allroundautomations.swmirror.com/plsqldev804.exe語言文件及手冊：
http://www.allroundautomations.com/plsqldevlang/80/chinese.exe注冊信息如下
product code：kfqtle46lqzbbvlzuvsrutst66yn6m7kl8s2trrtsapr
password：xs374ca
serial number：1775341736