求助：plsqldev查询某一张表，里面某个字段为什么在有些人的机器中显示格式靠右，有的格式靠左？？？ plsql 怎么样判断一个查询结果为否空，或者判断一张表是否...
\u600e\u4e48\u67e5\u770b\u6570\u636e\u5e93\u8868\u4e2d\u67d0\u4e2a\u5b57\u6bb5\u7684\u503c\u6709\u54ea\u4e9b\u91cd\u590d\u8bb0\u5f55\u4e0b\u9762\u4ee5 sqlserver\u6570\u636e\u5e93\u4e3a\u4f8b\u8fdb\u884c\u8bf4\u660e\u3002
select * from TableA where b in (select b from TableA group by b having count(b) > 1)
\u8fd9\u6837\u5c31\u5217\u4e3e\u51fa\u4e86b\u5b57\u6bb5\u6240\u6709\u7684\u91cd\u590d\u6570\u636e\uff0c\u53ef\u4ee5\u6839\u636e\u5bf9\u5e94\u7684\u884c\u53f7\uff0c\u53d6\u5f97\u4f4d\u4e8e\u7b2c\u51e0\u884c\u3002
\u5982\u679c\u8981\u67e5\u8be2a\u5b57\u6bb5\u6216\u8005c\u5b57\u6bb5\u91cd\u590d\u6570\u636e\uff0c\u53ef\u4ee5\u76f8\u5e94\u7684\u628a\u4e0a\u9762\u7684b\u5b57\u6bb5\u66ff\u6362\u6210a\u5b57\u6bb5\u6216c\u5b57\u6bb5\u5373\u53ef\u3002
\u4e3e\u4f8b\uff1a
1\u3001\u521b\u5efa\u8868student
2\u3001\u67e5\u8be2\u8bed\u53e5: select * from student where name in (select name from student group by name having count(name ) > 1)
\u8fd9\u6837\u5c31\u67e5\u51fa\u540d\u5b57\u91cd\u590d\u5217\uff0c\u4ee5\u53ca\u884c\u53f7id\u3002
\u6269\u5c55\u8d44\u6599\uff1a
1. sqlserver\u5176\u4ed6\u76f8\u5173\u7684\u4e00\u4e9b\u67e5\u8be2\uff1a
\uff081\uff09\u5220\u9664\u8868\u4e2d\u591a\u4f59\u7684\u91cd\u590d\u8bb0\u5f55\uff0c\u91cd\u590d\u8bb0\u5f55\u662f\u6839\u636e\u5355\u4e2a\u5b57\u6bb5\uff08peopleId\uff09\u6765\u5224\u65ad\uff0c\u53ea\u7559\u6709rowid\u6700\u5c0f\u7684\u8bb0\u5f55
delete from people where peopleId in
(select peopleId from people group by peopleId having count(peopleId) > 1) and
rowid not in (select min(rowid) from people group by peopleId having count(peopleId)>1)
\uff082\uff09\u67e5\u627e\u8868\u4e2d\u591a\u4f59\u7684\u91cd\u590d\u8bb0\u5f55\uff08\u591a\u4e2a\u5b57\u6bb5\uff09
select * from vitae a where (a.peopleId,a.seq) in
(select peopleId,seq from vitae group by peopleId,seq having count(*) > 1)
\uff083\uff09\u67e5\u627e\u8868\u4e2d\u591a\u4f59\u7684\u91cd\u590d\u8bb0\u5f55\uff08\u591a\u4e2a\u5b57\u6bb5\uff09\uff0c\u4e0d\u5305\u542browid\u6700\u5c0f\u7684\u8bb0\u5f55
select * from vitae a where (a.peopleId,a.seq) in
(select peopleId,seq from vitae group by peopleId,seq havingcount(*) > 1) and
rowid not in (select min(rowid) from vitae group by peopleId,seq having count(*)>1)
2. SQL\u8bed\u8a00\u5143\u7d20
1\u3001\u5b50\u53e5\uff0c\u662f\u8bed\u53e5\u548c\u67e5\u8be2\u7684\u7ec4\u6210\u90e8\u5206\u3002
2\u3001\u8868\u8fbe\u5f0f\uff0c\u53ef\u4ee5\u751f\u6210\u6807\u91cf\u503c\uff0c\u4e5f\u53ef\u4ee5\u751f\u6210\u7531\u5217\u548c\u884c\u6570\u636e\u7ec4\u6210\u7684\u8868\u3002
3\u3001\u8c13\u8bcd\uff0c\u6307\u5b9a\u53ef\u4ee5\u8bc4\u4f30\u4e3aSQL\u4e09\u503c\u903b\u8f91\uff083VL\uff09\uff08\u771f/\u5047/\u672a\u77e5\uff09\u6216\u5e03\u5c14\u771f\u503c\u7684\u6761\u4ef6\uff0c\u7528\u4e8e\u9650\u5236\u8bed\u53e5\u548c\u67e5\u8be2\u7684\u6548\u679c\uff0c\u6216\u7528\u4e8e\u66f4\u6539\u7a0b\u5e8f\u6d41\u3002
4\u3001\u67e5\u8be2\uff0c\u6839\u636e\u7279\u5b9a\u6761\u4ef6\u68c0\u7d22\u6570\u636e\u3002\u8fd9\u662fSQL\u7684\u4e00\u4e2a\u91cd\u8981\u5143\u7d20\u3002
\u8bed\u53e5\u53ef\u80fd\u5bf9\u67b6\u6784\u548c\u6570\u636e\u4ea7\u751f\u6301\u4e45\u5f71\u54cd\uff0c\u6216\u8005\u53ef\u80fd\u63a7\u5236\u4e8b\u52a1\uff0c\u7a0b\u5e8f\u6d41\uff0c\u8fde\u63a5\uff0c\u4f1a\u8bdd\u6216\u8bca\u65ad\u3002
SQL\u8bed\u53e5\u8fd8\u5305\u62ec\u5206\u53f7\uff08\u201c;\u201d\uff09\u8bed\u53e5\u7ec8\u6b62\u7b26\u3002\u867d\u7136\u5e76\u975e\u6bcf\u4e2a\u5e73\u53f0\u90fd\u9700\u8981\uff0c\u4f46\u5b83\u88ab\u5b9a\u4e49\u4e3aSQL\u8bed\u6cd5\u7684\u6807\u51c6\u90e8\u5206\u3002\u5728SQL\u8bed\u53e5\u548c\u67e5\u8be2\u4e2d\u901a\u5e38\u4f1a\u5ffd\u7565\u65e0\u5173\u7d27\u8981\u7684\u7a7a\u683c\uff0c\u4ece\u800c\u53ef\u4ee5\u66f4\u8f7b\u677e\u5730\u683c\u5f0f\u5316SQL\u4ee3\u7801\u4ee5\u63d0\u9ad8\u53ef\u8bfb\u6027\u3002
\u53c2\u8003\u8d44\u6599\uff1a\u767e\u5ea6\u767e\u79d1-SQL\u8bed\u6cd5
\u5224\u65ad\u67e5\u8be2\u7ed3\u679c\u662f\u5426\u4e3a\u7a7a\u53ef\u4ee5\u4f7f\u7528\u3010exists\u3011\u51fd\u6570\u8fdb\u884c\u5224\u65ad\u3002
\u4f8b\u5982\uff1a
if exists(select * from Table_temp) print '\u6709\u8bb0\u5f55'else print '\u65e0\u8bb0\u5f55'
exists\u51fd\u6570\u5728\u5224\u65ad\u67e5\u8be2\u7ed3\u679c\u65f6\uff0c\u6548\u7387\u5f88\u9ad8\uff0c\u5e76\u4e14\u4e0d\u4f1a\u4ea7\u751f\u5927\u91cf\u7684IO\u64cd\u4f5c\uff0c\u56e0\u4e3a\u5f53\u67e5\u8be2\u626b\u63cf\u5230\u7b2c\u4e00\u6761\u8bb0\u5f55\u65f6\u5c31\u4f1a\u505c\u6b62\u5411\u4e0b\u626b\u63cf\u5176\u4ed6\u7b26\u5408\u6761\u4ef6\u7684\u8bb0\u5f55\u3002\u6240\u4ee5\u6bd4\uff08select count(*) from Table_Temp\uff09\u6548\u7387\u9ad8\u4e86\u4e0d\u5c11
2、靠右的是数值型（Number）字段，如"CDXH"，导出sql，不带单引号
这与SQL的语法有关。
绛旓細1銆佸瓧娈靛兼樉绀洪潬宸︾殑鏄瓧绗﹀瀷(Varchar2)瀛楁锛屽鈥淐DLX鈥濓紝瀵煎嚭sql锛屽繀椤诲甫鍗曞紩鍙凤紝2銆侀潬鍙崇殑鏄暟鍊煎瀷锛圢umber锛夊瓧娈碉紝濡"CDXH"锛屽鍑簊ql锛屼笉甯﹀崟寮曞彿 杩欎笌SQL鐨勮娉曟湁鍏炽
绛旓細plsqldev璁剧疆涓哄彧鑳鏌ヨ鐨勬柟娉曟槸鍑忓皯鏉冮檺銆傛牴鎹煡璇㈢浉鍏冲叕寮淇℃伅鏄剧ず锛屽皢杩涜plsqldev鏁版嵁搴撶殑鐢ㄦ埛鐨勬潈闄愯繘琛屽噺灏戝悗锛屽啀娆¤繘琛岃闂椂鍗冲彲鍙兘鏌ヨ銆
绛旓細1. 濡傛灉鍜屼綘鍚岀郴缁(鐩祴鏄疻IN7?)鍚岀増鏈PLSQL浜哄鍙互浣犱笉鍙互锛宺pwt涓嶈В閲 2. 濡傛灉鏈変笉鍚岋紝閭ｅ彧鑳界敤鏇挎崲娉曪紝ORACLE DEVELOPER浣犺瘯杩囨病鏈夛紵鎹S浣犺瘯杩囨病鏈夛紵浣犳槸鎯宠闂暟鎹紝杩樻槸涓篜LSQL鍋氭祴璇曪紵濡傛灉鏄墠鑰咃紝璇曡瘯绗2绉嶅姙娉曟湁浣曚笉鍙 3. 濡傛灉鏄悗鑰咃紝鐪嬬湅浜嬩欢绠＄悊鍣紝锛堝紑濮->杩愯->eventvwr锛...
绛旓細宸ュ叿plsqldev 鍏蜂綋姝ラ锛氬湪select 璇彞鍚庨潰娣诲姞鍏抽敭瀛 for update;濡傦細select * from test for update;鍏蜂綋娴佺▼濡備笅锛氱涓姝ワ細鍒涘缓涓涓复鏃惰〃锛歝reate table test (id int );绗簩姝ワ細鎻掑叆鍑犳潯鏁版嵁锛歩nsert into test values(1);绗笁姝ワ細鍦ㄦ甯哥殑select 璇彞鍚庨潰娣诲姞鍏抽敭瀛梖or update 骞舵墽琛岋紱select...
绛旓細PLSQLDev鏄笓闂ㄤ负浜嗗紑鍙慜racle鏁版嵁搴撳簲鐢ㄨ岃璁＄殑涓娆捐蒋浠跺伐鍏枫備笅闈㈡槸璇︾粏鐨勮В閲婏細杞欢姒傝堪 PLSQLDev鎻愪緵浜嗗畬鏁寸殑闆嗘垚寮鍙戠幆澧冿紝鏀寔PL/SQL璇█寮鍙戯紝鏄疧racle鏁版嵁搴撳紑鍙戣呭父鐢ㄧ殑宸ュ叿涔嬩竴銆傚畠鏀寔鏁版嵁搴撶殑璁捐銆佸紑鍙戙佽皟璇曞拰閮ㄧ讲绛夊悇涓樁娈碉紝甯姪寮鍙戣呮彁楂樺紑鍙戞晥鐜囷紝绠鍖栫鐞嗘祦绋嬨備富瑕佺壒鐐 1. 闆嗘垚寮鍙戠幆澧...
绛旓細1銆佺偣鍑 "鍚姩PLSQL.exe" 鍗冲彲鍏嶈oracle浣跨敤PLSQL 鎴栬 浣跨敤qidong.bat鍚姩 锛2銆乮nstantclient_11_2涓簅racle 11 缁胯壊绮剧畝鐗堬紱3銆佽缃甌NS,鐢ㄨ浜嬫湰鎵撳紑閰嶇疆锛歩nstantclient_11_2\tnsnames.ora qidong.bat鍐呭锛歴et oracle_home=%~dp0\instantclient_11_2 set TNS_ADMIN=%~dp0\instantclient_11_2...
绛旓細PL/SQLDeveloper鏄竴涓泦鎴愬紑鍙戠幆澧冿紝涓撻棬寮鍙戦潰鍚慜racle鏁版嵁搴撶殑搴旂敤銆侾L/SQL涔熸槸涓绉嶇▼搴忚瑷锛屽彨鍋氳繃绋嬪寲SQL璇█锛圥roceduralLanguage/SQL锛夈侾L/SQL鏄疧racle鏁版嵁搴撳SQL璇彞鐨勬墿灞曘傚湪鏅歋QL璇彞鐨勪娇鐢ㄤ笂澧炲姞浜嗙紪绋嬭瑷鐨勭壒鐐癸紝鎵浠L/SQL鎶婃暟鎹搷浣滃拰鏌ヨ璇彞缁勭粐鍦≒L/SQL浠ｇ爜鐨勮繃绋嬫у崟鍏冧腑锛岄氳繃閫昏緫...
绛旓細1.鏌ョ湅鎵鏈夌敤鎴凤細select * from dba_users;select * from all_users;select * from user_users;2.鏌ョ湅鐢ㄦ埛鎴栬鑹茬郴缁熸潈闄(鐩存帴璧嬪肩粰鐢ㄦ埛鎴栬鑹茬殑绯荤粺鏉冮檺)锛歴elect * from dba_sys_privs;select * from user_sys_privs;3.鏌ョ湅瑙掕壊(鍙兘鏌ョ湅鐧婚檰鐢ㄦ埛鎷ユ湁鐨勮鑹)鎵鍖呭惈鐨勬潈闄 sql>select * from ...
绛旓細鎵撳紑鐢佃剳锛屽埌pl/sql瀹夎鐨勬寚瀹氱洰褰曘怐:\app\DZL\product\11.2.0\dbhome_1\NETWORK\ADMIN銆戞壘鍒般恡nsnames.ora銆戞墦寮銆恡nsnames.ora銆戞枃浠讹紝澧炲姞闇瑕佽繙绋嬭繛鎺ョ殑瀛楃涓层傜壒鍒閮ㄥ垎閲嶈瀛楁璇存槑锛歮yDB涓鸿繛鎺ユ暟鎹簱鍒悕HOST = 192.168.7.23涓鸿繛鎺ョ殑鏁版嵁搴搃pPORT = 1521 涓烘暟鎹殑绔彛SERVICE_NAME = ...
绛旓細浣跨敤PL/SQL Developer杩炴帴Oracle锛•1. 涓嬭浇32浣峅racle InstantClient锛屽苟灞曞紑鍒版煇鐩綍锛屼緥濡侰:\instantclient-basic-nt-11.2.0.2.0锛•2. 灏嗙郴缁熺殑tnsnames.ora鎷疯礉鍒拌鐩綍涓嬶紱•3. 鍦PLSQL Developer涓缃甇racle_Home鍜孫CI Library锛歍oolsPreferencesOracle&#...
