楗洅鍗氬

瀵逛簬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锛夛級锛�

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

sql>select * FROM dba_users;

sql>select * FROM all_users;

sql>select * FROM user_users;

鍦� MySQL涓嬶紝鍦ㄨ繘琛屼腑鏂囨ā绯婃绱㈡椂锛岀粡甯镐細杩斿洖涓�浜涗笌涔嬩笉鐩稿叧鐨勮褰曪紝濡傛煡鎵� “%a%” 鏃讹紝杩斿洖鐨勫彲鑳芥湁涓枃瀛楃锛屽嵈娌℃湁a瀛楃瀛樺湪銆傛湰浜轰互鍓嶄篃鏇鹃亣鍒拌繃绫讳技闂锛岀粡璇︾粏闃呰MySQL鐨凪anual锛屽彂鐜板彲浠ユ湁涓�绉嶆柟娉曞緢鏂逛究鐨勮В鍐冲苟寰楀埌婊℃剰鐨勭粨鏋溿��
渚嬪瓙锛�
甯屾湜閫氳繃鈥滄爣棰樷�濆鏂伴椈搴撹繘琛屾绱紝鍏抽敭瀛楀彲鑳藉寘鍚槸涓嫳鏂囷紝濡備笅SQL璇彞锛�

SELECT id,title,name

FROM achech_com.news

WHERE title LIKE '%a%'

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

SQL> SHOW RECYCLEBIN

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