1 / 18
Oracl
e
瀛樺偍杩囩▼瀛︿範
鐩綍
Oracle
瀛樺偍杩囩▼
..............................................................................................................................
1
Oracle
瀛樺偍杩囩▼鍩虹鐭ヨ瘑
...............................................................................................................
1
Oracle
瀛樺偍杩囩▼鐨勫熀鏈娉?/p>
...........................................................................................................
2
鍏充簬
Oracle
瀛樺偍杩囩▼鐨勮嫢骞查棶棰樺蹇?/p>
..........................................................................................
4
1.
鍦?/p>
Oracle
涓紝鏁版嵁琛ㄥ埆鍚嶄笉鑳藉姞
as
銆?/p>
..........................................................................
4
2.
鍦ㄥ瓨鍌ㄨ繃绋嬩腑锛?/p>
select
鏌愪竴瀛楁鏃讹紝鍚庨潰蹇呴』绱ц窡
into
锛屽鏋?/p>
select
鏁翠釜璁板綍锛屽埄
鐢ㄦ父鏍囩殑璇濆氨鍙﹀綋鍒浜嗐�?/p>
.
..................................................................................................
5
3.
鍦ㄥ埄鐢?/p>
select...into...
璇硶鏃讹紝
蹇呴』鍏堢‘淇濇暟鎹簱涓湁璇ユ潯璁板綍锛?/p>
鍚﹀垯浼氭姤鍑?/p>
"no data
found"
寮傚父銆?/p>
...........................................................................................................................
5
4.
鍦ㄥ瓨鍌ㄨ繃绋嬩腑锛?/p>
鍒悕涓嶈兘鍜屽瓧娈靛悕绉扮浉鍚岋紝
鍚﹀垯铏界劧缂栬瘧鍙互閫氳繃锛?/p>
浣嗗湪杩愯闃舵
浼氭姤閿?/p>
.......................................................................................................................................
5
5.
鍦ㄥ瓨鍌ㄨ繃绋嬩腑锛屽叧浜庡嚭鐜?/p>
null
鐨勯棶棰?/p>
.
..........................................................................
5
6.
Hibernate
璋冪敤
Oracle
瀛樺偍杩囩▼
.....................................................................................
6
鐢?/p>
Java
璋冪敤
Oracle
瀛樺偍杩囩▼鎬荤粨
..................................................................................................
6
涓�銆?/p>
鏃犺繑鍥炲�肩殑瀛樺偍杩囩▼
.
..............................................................................................
6
浜屻�?/p>
鏈夎繑鍥炲�肩殑瀛樺偍杩囩▼锛堥潪鍒楄〃锛?/p>
.
..........................................................................
8
涓夈�?/p>
杩斿洖鍒楄〃
.
..................................................................................................................
9
鍦ㄥ瓨鍌ㄨ繃绋嬩腑鍋氱畝鍗曞姩鎬佹煡璇?/p>
.
....................................................................................................
1
1
涓�銆?/p>
鏈湴鍔ㄦ�?/p>
SQL .........................................................................................................
1
2
浜屻�?/p>
浣跨敤
DBMS_SQL
鍖?/p>
.
................................................................................................
1
3
Oracle
瀛樺偍杩囩▼璋冪敤
Java
鏂规硶
.....................................................................................................
1
6
Oracle
楂樻晥鍒嗛〉瀛樺偍杩囩▼瀹炰緥
.....................................................................................................
1
7
Oracle
瀛樺偍杩囩▼鍩虹鐭ヨ瘑
鍟嗕笟瑙勫垯鍜屼笟鍔￠�昏緫鍙互閫氳繃绋嬪簭瀛樺偍鍦?/p>
Oracle
涓紝杩欎釜绋嬪簭灏辨槸
瀛樺偍杩囩▼
銆?/p>
瀛樺偍杩囩▼鏄?/p>
SQL, PL/SQL, Java
璇彞鐨勭粍鍚堬紝
瀹冧娇浣犺兘灏嗘墽琛屽晢涓氳鍒欑殑浠ｇ爜浠庝綘鐨勫簲鐢?/p>
绋嬪簭涓Щ鍔ㄥ埌鏁版嵁搴撱�傝繖鏍风殑缁撴灉灏辨槸锛?/p>
浠ｇ爜瀛樺偍涓�娆′絾鏄兘澶熻澶氫釜绋嬪簭浣跨敤
銆?/p>
瑕佸垱寤轰竴涓繃绋嬪璞?/p>
锛?/p>
procedural object
锛?/p>
锛?/p>
蹇呴』鏈?/p>
CREATE PROCEDURE
绯荤粺鏉冮檺銆?/p>
濡傛灉
杩欎釜杩囩▼瀵硅薄闇�瑕佽鍏朵粬鐨勭敤鎴?/p>
schema
浣跨敤锛岄偅涔堜綘蹇呴』鏈?/p>
CREATE
ANY
PROCEDURE
鏉?/p>
闄愩�傛墽琛?/p>
procedure
鐨勬椂鍊欙紝鍙兘闇�瑕?/p>
excute
鏉冮檺銆傛垨鑰?/p>
EXCUTE ANY PROCEDURE
鏉冮檺銆?/p>
濡傛灉鍗曠嫭璧嬩簣鏉冮檺锛屽涓嬩緥鎵�绀猴細
grant
execute on MY_PROCEDURE
to Jelly
璋冪敤涓�涓瓨鍌ㄨ繃绋嬬殑渚嬪瓙锛?/p>
execute MY_PROCEDURE( 'ONE PARAMETER');
瀛樺偍杩囩▼
(PROCEDURE)
鍜屽嚱鏁?/p>
(FUNCTION)
鐨勫尯鍒�?/p>