在plsql中怎样输出信息 oracle存储过程如何输出信息
plsql\u600e\u4e48\u5bfc\u51fa\u6570\u636e\u5e93\u4e2d\u7684\u6570\u636e1.\u5b8c\u6574\u7684\u5bfc\u51fa\u6574\u4e2a\u6570\u636e\u5e93\u8868\u7ed3\u6784\u5373dmp\u6587\u4ef6\u65b9\u6cd5\uff1a
Tools-->Export Tables ,\u9009\u62e9Oracle Export \u9ed8\u8ba4\u9009\u9879\u5373\u53ef\uff0c\u5728Output file\u9009\u62e9\u4e00\u4e2a\u8f93\u51fa\u76ee\u6807
\u70b9\u51fbExport,\u5373\u53ef\u5bfc\u51fa\u8868\u7ed3\u6784
2.\u5bfc\u51fa\u8868\u4e2d\u6570\u636e:
Tools-->Export Tables :\u9009\u62e9SQL Inserts \u9047\u5230\u5927\u5b57\u6bb5(clob,blob)\u4f1a\u51fa\u95ee\u9898\u5bfc\u4e0d\u51fa\u6765\uff0c\u5728\u6b64\u53ef\u4ee5
\u9009\u62e9\u9700\u8981\u5bfc\u51fa\u7684\u8868\uff0c\u5728Output file\u4e2d\u9009\u62e9\u5bfc\u51fa\u7684\u76ee\u6807\uff0c\u70b9\u51fbExport\u5373\u53ef\u5bfc\u51fa\uff0c\u5728\u6b64\u6709\u51e0\u4e2a\u9009\u9879
\u53ef\u4ee5\u53bb\u6389\u6240\u6709\u7684\u53ef\u9009\u9879\u76f4\u63a5\u5bfc\u51fa
3.\u5bfc\u51fa\u6570\u636e\u5e93\u4e2d\u6240\u6709\u7684\u6216\u662f\u6240\u9009\u8868\u7684\u6570\u636e\u5e93\u5efa\u8868\u811a\u672c\uff1a
Tools-->Export User Objects\u53bb\u6389\u4e0b\u9762\u4e09\u4e2ainclude *\u53ef\u9009\u9879\uff0c\u9009\u62e9Single file)\u5728Output file
\u4e2d\u9009\u62e9\u8f93\u51fa\u76ee\u6807\uff0c\u70b9\u51fbExport\u5373\u53ef
\u53ef\u7528DBMS_OUTPUT.PUT_LINE()\u5bf9\u5b58\u50a8\u8fc7\u7a0b\u7684\u8fdb\u884c\u8f93\u51fa\u3002
\u7f16\u5199\u5b58\u50a8\u8fc7\u7a0b\uff1a
create or replace procedure test_pro(in_num number)
as
M number\uff1b
begin
M := in_num\uff1b
if 0 < M then
dbms_output.put_line('\u8f93\u51faSQL\u8bed\u53e51')\uff1b
elsif M < 3 then
dbms_output.put_line('\u8f93\u51faSQL\u8bed\u53e52')\uff1b
else
dbms_output.put_line('nothing')\uff1b
end if\uff1b
end\uff1b
\u6269\u5c55\u8d44\u6599\uff1b
\u5b58\u50a8\u5728\u6570\u636e\u5e93\u7684\u6570\u636e\u5b57\u5178\u4e2d\uff0c\u5b58\u50a8\u5728\u5f53\u524d\u7684\u5e94\u7528\u4e2d\u5b89\u5168\u6027\u7531\u6570\u636e\u5e93\u63d0\u4f9b\u5b89\u5168\u4fdd\u8bc1\uff0c\u5fc5\u987b\u901a\u8fc7\u6388\u6743\u624d\u80fd\u4f7f\u7528\u5b58\u50a8\u5b50\u7a0b\u5e8f\uff0c\u5b89\u5168\u6027\u9760\u5e94\u7528\u7a0b\u5e8f\u6765\u4fdd\u8bc1\uff0c\u5982\u679c\u80fd\u6267\u884c\u5e94\u7528\u7a0b\u5e8f\uff0c\u5c31\u80fd\u6267\u884c\u8be5\u5b50\u7a0b\u5e8f\u3002\u6a21\u5f0f\u63cf\u8ff0IN\u53c2\u6570\u7528\u6765\u4ece\u8c03\u7528\u73af\u5883\u4e2d\u5411\u5b58\u50a8\u8fc7\u7a0b\u4f20\u9012\u503c\uff0c\u4e0d\u80fd\u7ed9IN\u53c2\u6570\u8d4b\u503c\uff0c\u7ed9\u6b64\u53c2\u6570\u4f20\u9012\u7684\u503c\u53ef\u4ee5\u662f\u5e38\u91cf\u3001\u6709\u503c\u7684\u53d8\u91cf\u3001\u8868\u8fbe\u5f0f\u7b49\u3002
\u53c2\u8003\u8d44\u6599\u6765\u6e90\uff1a\u767e\u5ea6\u767e\u79d1-Oracle\u5b58\u50a8\u8fc7\u7a0b
绛旓細select a.trade_date,a.batch_no, (select org from tabname b where a.trade_date = b.trade_date and a.batch_no = b.batch_no and flat = 'D' and org='鍊熸満鏋1' -- 鏈鍚庝竴涓猳rg鐨勬潯浠舵湁鐐瑰鎬,浣嗘槸杩欏効鑲畾闇瑕佷竴涓潯浠剁殑) 鍊熸満鏋1, (select org from tabname b where ...
绛旓細浣犺鏄dmp鏂囦欢鐨勮瘽锛屽湪鍙宠竟鐨勬祻瑙堝櫒涓婄偣tables鐨勫姞鍙凤紝鎵惧埌浣犵殑琛紝鐒跺悗鍙抽敭鐐瑰嚮锛岀偣瀵煎嚭锛岄夋嫨浣犺瀵煎嚭鐨勪笢瑗匡紝鐒跺悗鍦杈撳嚭鏂囦欢涓婄偣閭ｄ釜鏂囦欢澶瑰浘鏍囷紝閫夎矾寰勮捣涓悕瀛楋紝鐐逛繚瀛橈紝鐐瑰鍑哄氨琛屻備綘瑕佸彧瑕佹暟鎹殑璇濓紝鎶婃暟鎹厛鏌ヨ鍑烘潵锛岀偣琛ㄦ牸涓婅竟鐨勫掓暟绗簩涓伐鍏凤紝閫夋嫨涓涓牸寮忥紝閫夎矾寰勮緭涓枃浠跺悕锛岀偣淇濆瓨...
绛旓細PLSQL瀵煎嚭oracle琛ㄧ粨鏋勭殑鍏蜂綋姝ラ濡備笅锛氭垜浠渶瑕佸噯澶囩殑鏉愭枡鍒嗗埆鏄細鐢佃剳銆丳L/SQL Developer杞欢銆1銆侀鍏堟垜浠墦寮闇瑕佺紪杈戠殑oracle鏁版嵁搴擄紝鐐瑰嚮鎵撳紑鈥渢ools鈥濄2銆佺劧鍚庢垜浠湪寮瑰嚭鏉ョ殑绐楀彛涓偣鍑绘墦寮鈥渆xport user objects鈥濄3銆佺劧鍚庢垜浠湪寮瑰嚭鏉ョ殑绐楀彛涓缃敤鎴枫佸鍑哄璞°佸鍑鸿矾寰勭瓑鍙傛暟锛屼箣鍚庡崟鍑诲鍑猴紙...
绛旓細鑷繁鍐plsql绋嬪簭杈撳嚭鍒版枃浠堕噷闈紝浣跨敤澶氱嚎绋嬬瓑鍔熻兘浼氬緢蹇殑銆備篃鍙互浣跨敤exp鎴栬卐xpdp瀵兼暟鎹傛渶蹇殑褰撶劧鏄痳man浜嗐備富瑕佺湅浣犲鍑虹殑鏁版嵁瑕佸仛浠涔堬紝瑕佸鍑轰粈涔堟牸寮忕殑銆
绛旓細鎴戞噦鎮ㄧ殑鎰忔濓紝鏄兂鏈変竴涓儚ecplise涓鏍锋帶鍒杈撳嚭鍙般傚彲浠ュ厛璇曡瘯SELECT SYSDATE FROM dual锛涚劧鍚庡氨浼氳嚜鍔ㄥ嚭鐜般備絾杩欎釜鎰忎箟涓嶅ぇ锛屽洜涓烘暟鎹簱涓昏鏄搷浣滄湇鍔″櫒鏁版嵁锛屽苟涓嶉渶瑕佽緭鍑烘潵娴嬭瘯銆傚鏋滃彧鏄畝鍗曠殑鏌ョ湅鎵ц鎯呭喌锛屽彸涓嬭浼氭湁鏄剧ず锛屽寘鎷墽琛岄渶瑕佺殑鏃堕棿銆
绛旓細宸ュ叿-->瀵煎嚭鐢ㄦ埛瀵硅薄-->閫夋嫨鐩稿簲琛-->涓嬮潰閫夋嫨杈撳嚭鍒板摢涓湴鏂 浠ュ強鏂囦欢鍚-->鐐瑰嚮瀵煎嚭鎸夐挳 鍗冲彲
绛旓細棣栧厛鍦ㄤ綘鐨刾l/sql涓蹇呴』鎵ц璇彞锛歴et serveroutput on;鍏舵鏈杈撳嚭璇彞dbms_output.put_line('杈撳嚭鍐呭');4. plsql鎬庢牱璁剧疆蹇嵎閿 鎵撳紑PLSQL,鐐瑰嚮鑿滃崟鏍"Tools"閫夋嫨绗竴椤"Preferences銆傛壘鍒"user interface"閫夋嫨"Editor"鍦ㄥ彸渚ф壘鍒"AutoReplace"鎵撳紑PL...
绛旓細> options > "Oracle Home" and "OCI Library",渚嬪锛歄racle10g瑁呭湪D:\oracle\ 鍒欙細Oracle Home涓篋:\oracle\product\10.2.0 OCI Library涓篋:\oracle\product\10.2.0\Db_1\BIN\oci.dll 閰嶇疆瀹屼互鍚庨噸鏂板惎鍔PLSQL Developer锛屼細鍙戠幇鐧诲綍鐣岄潰澶氫簡涓鏍廋onnect as 鐨勫唴瀹广傜劧鍚庡彲浠ヨ繘琛岀櫥褰曘
绛旓細鎴戠敤鐨勬槸鑻辨枃鐗鐨凱LSQL锛屽鏋滀綘鐢ㄤ腑鏂囩増锛屽搴旂殑涔熶竴鏍锋搷浣滀簡銆俆OOLS->PERFERMANCE->USER INTERFACE->EDITOR->AUTO REPLACE 鐐瑰嚮涓嬮潰鐨凟DIT鎸夐挳锛屽姞鍏ヤ竴琛宻 =select * from锛屼繚瀛樸傜劧鍚庣‘瀹氾紝搴旂敤鍗冲彲銆傝繖涓氨鏄嚜鍔ㄦ浛鎹㈢殑涓涓鐓ц〃锛屽彲浠ュ皢鑷繁甯哥敤鐨勪竴浜涜鍙ュ姞杩涙潵銆
绛旓細1銆佹墦寮PL/SQL DEV锛岀劧涓杩涜瀵煎嚭鐨勮〃锛岀偣鍑诲彸閿紝鍦ㄥ脊鍑虹殑鑿滃崟涓紝閫変腑Export data锛堝涓嬪浘鎵绀猴級銆2銆佸湪鍗曞嚮Export data鍚庯紝鍦ㄥ彸渚у氨鍑虹幇浜嗗鍑鸿缃殑绐楀彛锛屽涓嬪浘鎵绀猴細鍦ㄧ獥鍙ｄ笅鏂癸紝閫変腑SQL Inserts鏍囩椤碉紝璁剧疆瀵煎嚭鏉′欢銆3銆佽缃畬鎴愬悗锛岀偣鍑籈xport鎸夐挳锛屽嵆鍙鍑恒俹racle鐢ㄥ懡浠よ瀵煎嚭sql璇彞鏂囨湰 ...
