楗洅鍗氬

瀵逛簬rownum鏉ヨ瀹冩槸oracle绯荤粺椤哄簭鍒嗛厤涓轰粠鏌ヨ杩斿洖鐨勮鐨勭紪鍙凤紝杩斿洖鐨勭涓�琛屽垎閰嶇殑鏄�1锛岀浜岃鏄�2锛屼緷姝ょ被鎺紝杩欎釜浼瓧娈靛彲浠ョ敤浜庨檺鍒舵煡璇㈣繑鍥炵殑鎬昏鏁帮紝鑰屼笖rownum涓嶈兘浠ヤ换浣曡〃鐨勫悕绉颁綔涓哄墠缂�銆�
涓句緥璇存槑锛�

EXECUTE IMMEDIATE 浠ｆ浛浜嗕互鍓峅racle8i涓璂BMS_SQL package鍖�.
瀹冭В鏋愬苟椹笂鎵ц鍔ㄦ�佺殑SQL璇彞鎴栭潪杩愯鏃跺垱寤虹殑PL/SQL鍧�.鍔ㄦ�佸垱寤哄拰鎵цSQL璇彞鎬ц兘瓒呭墠锛孍XECUTE IMMEDIATE鐨勭洰鏍囧湪浜庡噺灏忎紒涓氳垂鐢ㄥ苟鑾峰緱杈冮珮鐨勬�ц兘锛岃緝涔嬩互鍓嶅畠鐩稿綋瀹规槗缂栫爜.灏界DBMS_SQL浠嶇劧鍙敤锛屼絾鏄帹鑽愪娇鐢‥XECUTE IMMEDIATE,鍥犱负瀹冭幏鐨勬敹鐩婂湪鍖呬箣涓娿��

濡傛灉浣犱笉璁板緱浜唎racle鐢ㄦ埛鐨勫瘑鐮�,鎴戜滑鍙互杩欐牱杩涜閲嶆柊璁剧疆:
鍦ㄥ懡浠よ鎵ц濡備笅鍛戒护锛�
sqlplus “/@鏈嶅姟鍚� as sysdba”
鐒跺悗鍦╯qlplus涓�

涓�鑸垵瀛﹁�呭Oracle 鐨凬O_DATA_FOUND 鍜�%NOTFOUND 涓や釜淇濈暀瀛楃殑鐢ㄦ硶涓嶅浜� 瑙ｏ紝涓昏鏄畠浠粠鎰忎箟涓婃槸鏈変簺绫讳技銆傚叾瀹炲畠浠殑鐢ㄦ硶鏄湁鍖哄埆鐨勶紝灏忕粨濡備笅锛�
1 SELECT . . . INTO 璇彞瑙﹀彂 NO_DATA_FOUND锛�
2 褰撲竴涓樉绀哄厜鏍囩殑 where 瀛愬彞鏈壘鍒版椂 瑙﹀彂 %NOTFOUND锛�

SQL>create TABLE t(abc varchar2(100));

琛ㄥ凡鍒涘缓銆�

SQL>insert INTO t(abc) VALUES('abcdef'||chr(10)||chr(13)||'hjkml');

宸插垱寤� 1 琛屻��

SQL>select * FROM t;

ABC

abcdef

hjkml

绀轰緥锛�

SELECT table_name,tablespace_name,TEMPORARY

FROM user_tables

WHERE table_name LIKE '%PROV%'

鍒嗘瀽锛�
銆�銆�table_name:琛ㄥ悕锛坴archar2(30)锛�;
銆�銆�tablespace_name:瀛樺偍琛ㄥ悕鐨勮〃绌洪棿锛坴archar2锛�30锛夛級锛�

鐢查鏂囧湪鏃ュ墠鍙戝竷鐨勪竴浠紽AQ涓粓浜庨�忛湶浜嗗SUN鍏徃鍚勪釜鎶�鏈拰浜у搧鐨勭瓥鐣ワ紝鍏朵腑鍖呮嫭浜哊etBeans锛孏lassfish锛孫penOffice鍜� VirtualBox绛塖UN鐨勪骇鍝併�備箣鍓嶅ぇ瀹跺叧蹇冪殑MySQL锛孲PARC鍜孲olaris閮藉凡缁忛噸鐢宠繃澶氭浜嗭紝浣嗗杩欏嚑涓骇鍝佺殑绛栫暐杩欒繕鏄涓�娆￠�忔紡銆備笅闈㈡潵鐪嬬湅鐢查鏂囧杩欏嚑涓骇鍝佺殑鏈潵瑙勫垝鍚с��
銆�銆�NetBeans
銆�銆�鐢查鏂囨墦绠楀皢NetBeans浣滀负 JDeveloper鍜孫racle Enterprise Pack for Eclipse鐨勨�滈澶栫殑寮�婧愰�夋嫨鈥濓紝鐢查鏂囬潪甯告竻妤氾紝JDeveloper鎵嶆槸Oracle铻嶅悎鏈潵浼佷笟绾у紑鍙戠殑鎴樼暐鎬у紑鍙戝伐鍏枫�傜敳楠ㄦ枃琛ㄧずJDeveloper锛孍nterprise Pack鍜� NetBeans閮藉皢鏄疛ava鍜孞avaEE寮�鍙戠殑鏈夋晥閫夋嫨銆�

1.鏌ョ湅鎵�鏈夌敤鎴凤細

sql>select * FROM dba_users;

sql>select * FROM all_users;

sql>select * FROM user_users;

浣跨敤oracle10g鐨勬湅鍙嬪彲鑳戒細鍙戠幇浠ュ墠鍒犻櫎鐨勮〃鍦ㄦ暟鎹簱涓嚭鐜颁簡寰堝鍨冨溇琛紝濡傦細BINjR8PK5HhrrgMK8KmgQ9nw==涔嬬被鐨勮〃鏃犳硶鍒犻櫎鏃犳硶鐢╠elete 鍒犻櫎,涓�鑸笉褰卞搷姝ｅ父浣跨敤锛屼絾鏄湁浠ヤ笅鎯呭喌浣挎垜浠繀椤诲垹闄ゅ畠
1,杩欎簺琛ㄥ崰鐢ㄧ┖闂�
2,濡傛灉浣跨敤Middlegen-Hibernate-r5鐨勬湅鍙嬩細鍙戠幇涓�浜涢棶棰橈紝涓嶄綘璞′互鍓嶇敤oracle9鏃堕偅涔堥『鐨勭敓鎴恏ibernate閰嶇疆鏂囦欢,鍘熷洜灏卞湪杩欓噷灏嗗畠鍒犻櫎灏辨病鏈夐棶棰樹簡锛�
3,鍏跺畠鎯呭喌
BINjR8PK5HhrrgMK8KmgQ9nw==涔嬬被鐨勮〃杩欎釜鏄�10g 鐨勬柊鐗规�с��
Drop Table 鍚庯紝娌℃湁鐪熸鐨勫垹闄よ〃锛岃�屾槸鍦ㄢ�滃瀮鍦剧珯鈥濅腑浜嗐�傚彲浠ラ�氳繃锛�

SQL> SHOW RECYCLEBIN

鐪嬪埌銆傚鏋滆褰诲簳鍒犻櫎锛屼娇鐢細