Posted on 2012-01-18 18:00
哈希 閱讀(328)
評(píng)論(0) 編輯 收藏 所屬分類:
sql 總結(jié)
PL/SQL Developer是一個(gè)集成開發(fā)環(huán)境，專門面向Oracle數(shù)據(jù)庫存儲(chǔ)程序單元的開發(fā)。如今，有越來越多的商業(yè)邏輯和應(yīng)用邏輯轉(zhuǎn)向了Oracle Server，因此，PL/SQL編程也成了整個(gè)開發(fā)過程的一個(gè)重要組成部分。PL/SQL Developer側(cè)重于易用性、代碼品質(zhì)和生產(chǎn)力，充分發(fā)揮Oracle應(yīng)用程序開發(fā)過程中的主要優(yōu)勢(shì)。PL/SQL(Procedural Language/SQL)是一種過程化語言，屬于第三代語言，它與C、C++、Java等語言一樣關(guān)注于處理細(xì)節(jié)，可以用來實(shí)現(xiàn)比較復(fù)雜的業(yè)務(wù)邏輯。它允許SQL的數(shù)據(jù)操縱語言和查詢語句包含在塊結(jié)構(gòu)(block_structured)和代碼過程語言中，使PL/SQL成為一個(gè)功能強(qiáng)大的事務(wù)處理語言。在甲骨文數(shù)據(jù)庫管理方面，PL/SQL是對(duì)結(jié)構(gòu)化查詢語言（SQL）的過程語言擴(kuò)展。PL/SQL的目的是聯(lián)合數(shù)據(jù)庫語言和過程語言。PL/SQL的基本單位叫做一個(gè)區(qū)段，由三個(gè)部份組成：一個(gè)申明部份，一個(gè)可運(yùn)行部份，和排除－構(gòu)建部分。 因?yàn)镻L/SQL允許混合SQL申明和過程結(jié)構(gòu)，因此可以在將申明發(fā)送到甲骨文系統(tǒng)去執(zhí)行之前使用PL/SQL區(qū)段和副程序來組合SQL申明，沒有PL/SQL，甲骨文需要就每次處理SQL申明，在網(wǎng)絡(luò)環(huán)境中，這將影響交通流量，而且增加響應(yīng)時(shí)間。PL/SQL區(qū)段只被編譯一次并且以可運(yùn)行的形式儲(chǔ)存，以降低響應(yīng)時(shí)間。
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語言文件及手冊(cè)：
http://www.allroundautomations.com/plsqldevlang/80/chinese.exe注冊(cè)信息如下
product code：kfqtle46lqzbbvlzuvsrutst66yn6m7kl8s2trrtsapr
password：xs374ca
serial number：1775341736