PLSQL Developer
鑻ュ共浣跨敤鎶�宸?/p>
1
銆佸彸閿彍鍗?/p>
鍦?/p>
PL/SQL Developer(
涓嬮潰绠�绉?/p>
PLD
涓殑姣忎竴涓枃鏈紪杈戠獥鍙?/p>
,
濡?/p>
SQL Window,
Command Window
鍜?/p>
Porgram Window,
鍙抽敭鐐瑰嚮鏌愪釜瀵硅薄鍚嶇О
,
浼氬脊鍑轰竴涓寘鍚搷浣?/p>
瀵硅薄鍛戒护鐨勮彍鍗?/p>
,
鎴戜滑杩欓噷绉颁箣涓哄彸閿彍鍗曘�?/p>
瀵硅薄绫诲瀷鍙互鏄〃
,
瑙嗗浘
,
鍚屼箟璇?/p>
,
瀛樺偍杩囩▼鍜屽嚱鏁扮瓑銆傛牴鎹璞＄被鍨嬬殑涓嶅悓
,
寮瑰嚭
鐨勮彍鍗曚篃鏈夊尯鍒�傝〃鍜岃鍥炬湁
View, Edit, Rename, Drop, Query data
鍜?/p>
Edit data
绛?/p>
鍔熻兘銆?/p>
View
鍜?/p>
Edit
鍒嗗埆鏄煡鐪嬪拰淇敼琛ㄧ殑缁撴瀯淇℃伅
,
濡傚瓧娈?/p>
,
涓婚敭
,
绱㈠紩鍜岀害鏉熺瓑銆?/p>
Query data
鐩稿綋浜庢柊鎵撳紑涓�涓獥鍙?/p>
,
骞舵墽琛?/p>
select * from
琛ㄣ�?/p>
Edit data
鐩稿綋浜庢柊鎵撳紑
涓�涓獥鍙?/p>
,
骞舵墽琛?/p>
select * from
琛?/p>
for update
銆傚瓨鍌ㄨ繃绋嬪拰鍑芥暟鏈?/p>
Test
鍔熻兘
,
閫変腑鍚庡彲
浠ヨ繘鍏ヨ皟璇曠姸鎬併�傛湁鏃剁敱浜?/p>
PLD
璇嗗埆閿欒
,
鍙抽敭鐐瑰嚮瀵硅薄骞朵笉鑳藉嚭鏉ユ纭殑鑿滃崟
,
鍙?/p>
浠ュ湪瀵硅薄鎵�鍦ㄧ殑
DDL
鎴?/p>
DML
璇彞鐨勫墠闈?/p>
,
鍔犱笂鍒嗗彿
,
杩欐牱
PLD
灏辫兘姝ｇ‘鐨勫垽鏂嚭
瀵硅薄鐨勭被鍨?/p>
2
銆?/p>
Select for Update
鏈夋椂鎴戜滑闇�瑕佹妸涓�浜涙暟鎹鍏ユ暟鎹簱涓?/p>
,
濡傛灉鐢?/p>
UE
鎷?/p>
Insert
璇彞
,
浼氭瘮杈冮夯鐑?/p>
,
鑰屼笖鎿嶄綔鎬т笉寮恒�?/p>
PLD
鐨?/p>
SQL Window
鍙互鏌ヨ
,
鏂板
,
淇敼鍜屽垹闄よ〃鐨勫唴瀹广�傛煡璇?/p>
鑷笉蹇呰
,
鑰屾柊澧?/p>
,
鍒犻櫎鍜屼慨鏀?/p>
,
鍙渶鍦?/p>
select
璇彞鍚庡姞鍏?/p>
for update,
瀵硅〃杩涜琛岀骇閿?/p>
瀹?/p>
,
鐒跺悗鐐瑰嚮绐楀彛鐨勯攣鍨嬪浘鏍?/p>
,
鍗冲彲杩涘叆缂栬緫鐘舵�併�備笅闈粙缁嶄竴涓嬪浣曚粠
Excel
涓彁
鍙栨枃鏈彃鍏ュ埌鏁版嵁搴撲腑鎴戜滑鐨?/p>
Excel
鏂囦欢涓湁涓夊垪
:
鍦ㄦ暟鎹簱涓缓绔嬩复鏃惰〃
:create
table t1 (cino varchar2(100, contno varchar2(100, loanno varchar2(100
鐒跺悗鍦?/p>
SQL
Window
涓緭鍏?/p>
select t1 for update,
骞剁偣鍑婚攣鍨嬮紶鏍?/p>
,
杩涘叆缂栬緫鐘舵�?/p>
:
鐢ㄩ紶鏍囩偣鍑?/p>
绗竴琛岀殑杈撳叆绐楀彛
,
杩欐椂
PLD
浼氭閿佸嚑绉掗挓
,
鐒跺悗鍙互瑙佸埌鍏夋爣鍦ㄧ涓�琛岀殑杈撳叆妗嗕腑
闂姩
,
鐢ㄩ紶鏍囨妸
CINO, CONTNO, LOANNO
閫変腑
:
杩涘叆
Excel
涓?/p>
,
鎶婇渶瑕佹彃鍏ユ暟鎹簱鐨?