在plsql里如何查看打印出 电脑如何查看打印机软件在哪?
\u7535\u8111\u5982\u4f55\u67e5\u770b\u6253\u5370\u673a\u8f6f\u4ef6\u5728\u54ea?\u7535\u8111\u67e5\u770b\u6253\u5370\u673a\u8f6f\u4ef6\u4f4d\u7f6e\u7684\u65b9\u6cd5\uff1a
\u70b9\u51fb\u5f00\u59cb\u83dc\u5355\u2014\u2014\u8bbe\u7f6e\u2014\u2014\u63a7\u5236\u9762\u677f\u2014\u2014\u6253\u5370\u673a\u548c\u4f20\u771f\uff0c\u5c31\u4f1a\u5f39\u51fa\u6253\u5370\u673a\u548c\u4f20\u771f\u5bf9\u8bdd\u6846\uff0c\u91cc\u9762\u5c31\u662f\u7535\u8111\u5b89\u88c5\u7684\u6253\u5370\u673a\u8f6f\u4ef6\u4e86\u3002
1\u3001"\u5f00\u59cb"-"\u6253\u5370\u673a\u548c\u4f20\u771f"\uff0c\u70b9\u51fb\u5de6\u8fb9\u7a97\u683c\u4e2d"\u6dfb\u52a0\u6253\u5370\u673a", \u6253\u5f00"\u6b22\u8fce\u6dfb\u52a0\u6253\u5370\u673a\u5411\u5bfc"\u5bf9\u8bdd\u6846\uff0c\u70b9\u51fb"\u4e0b\u4e00\u6b65"\uff0c\u6253\u5f00"\u672c\u5730\u6216\u7f51\u7edc\u6253\u5370\u673a"\u9009\u62e9\u8fde\u63a5\u5bf9\u8bdd\u6846\uff1b \u3000\u3000
2\u3001\u9009\u62e9\u7b2c\u4e00\u9879"\u8fde\u63a5\u5230\u6b64\u8ba1\u7b97\u673a\u7684\u672c\u5730\u6253\u5370\u673a"\uff0c\u52fe\u9009"\u81ea\u52a8\u68c0\u6d4b\u5e76\u5b89\u88c5\u5373\u63d2\u5373\u7528\u6253\u5370\u673a"\uff0c\u70b9"\u4e0b\u4e00\u6b65"\uff0c\u6253\u5f00"\u65b0\u6253\u5370\u673a\u68c0\u6d4b"\u5bf9\u8bdd\u6846\uff1b \u3000\u3000
3\u3001\u68c0\u6d4b\u540e\uff0c\u6253"\u4e0b\u4e00\u6b65"\uff0c\u6253\u5f00"\u9009\u62e9\u6253\u5370\u673a\u7aef\u53e3"\u5bf9\u8bdd\u6846\uff1b
4\u3001\u70b9\u9009"\u4f7f\u7528\u4ee5\u4e0b\u7aef\u53e3"\uff0c\u5728\u53f3\u8fb9\u7684\u4e0b\u62c9\u5217\u8868\u4e2d \u3000\u3000\u9009\u62e9\u63a8\u8350\u7684\u6253\u5370\u673a\u7aef\u53e3"LPT1:"\uff0c\u70b9\u51fb"\u4e0b\u4e00\u6b65"\uff0c\u6253\u5f00"\u5b89\u88c5\u6253\u5370\u673a\u8f6f\u4ef6"\u5bf9\u8bdd\u6846\uff1b \u3000\u3000
5\u3001\u5728"\u5382\u5546"\u5217\u8868\u4e2d\uff0c\u70b9\u51fb\u5382\u5546\u540d\uff0c\u5728"\u6253\u5370\u673a"\u5217\u8868\u4e2d\uff0c\u70b9\u51fb\u6253\u5370\u673a\u540d\uff0c\u70b9\u51fb"\u4e0b\u4e00\u6b65"\uff0c\u6253\u5f00"\u547d\u540d\u6253\u5370\u673a"\u5bf9\u8bdd\u6846\uff1b \u3000\u3000
6\u3001\u5728"\u6253\u5370\u673a\u540d"\u6587\u672c\u6846\u4e2d\u8f93\u5165\u6253\u5370\u673a\u540d\uff0c\u70b9\u51fb"\u4e0b\u4e00\u6b65"\uff0c\u6253\u5f00"\u6253\u5370\u673a\u5171\u4eab"\u5bf9\u8bdd\u6846\uff1b \u3000\u3000
7\u3001\u70b9\u9009"\u4e0d\u5171\u4eab\u8fd9\u53f0\u6253\u5370\u673a"\uff0c\u6253"\u4e0b\u4e00\u6b65"\uff0c\u6253\u5f00"\u6253\u5370\u6d4b\u8bd5\u9875"\u5bf9\u8bdd\u6846\uff1b \u3000\u3000
8\u3001\u9009\u5426"\u5426"\uff0c\u6253"\u4e0b\u4e00\u6b65"\uff0c\u7edf\u5373\u65e5\u81ea\u52a8\u641c\u7d22\u7535\u8111\u81ea\u5e26\u6253\u5370\u673a\u8f6f\u4ef6\u8fdb\u884c\u5b89\u88c5\uff1b \u3000\u3000
9\u3001\u70b9\u51fb'\u5b8c\u6210'\u3002
绛旓細娴嬭瘯鍌ㄥ瓨杩囩▼锛屼紶鍏ョ浉搴斿弬鏁帮紝璁剧疆鏂偣锛屽湪姝よ繃绋嬩腑锛屽彲浠ョ湅鍒板彉閲忕殑鍊硷紙鍖呮嫭缁撴灉闆嗭級銆
绛旓細璇曡瘯 dbms_output.put_line(to_date('1999-01-01'));
绛旓細鏌ヨ杈撳嚭鎵鏈夊憳宸ョ紪鍙凤紝濮撳悕锛屽伐璧勶紙PLSQL琛ㄧ被鍨嬶級DECLARE TYPE emp_table_type IS TABLE OF employees%ROWTYPE INDEX BY BINARY_INTEGER;e emp_table_type;CURSOR emp_cursor IS SELECT * FROM employees;BEGIN OPEN emp_cursor;FETCH emp_cursor BULK COLLECT INTO e;FOR i IN 1 .. e.count LOO...
绛旓細瑕佷箞鐢 sys.diutil.bool_to_int(is_true) 鎶婂竷灏旇浆鎴恑nt锛0: false 1: true dbms_output.put_line(sys.diutil.bool_to_int(is_true));瑕佷箞鍋氬垽鏂 dbms_output.put_line(case when is_true then 'TRUE'when is_true is null then 'NULL'else 'FALSE'end );
绛旓細浠ｇ爜锛歞eclare cursor c_job is select ename, sal from emp; c_row c_job%rowtype;begin for c_row in c_job loop dbms_output.put_line('濮撳悕:' || c_row.ename || ' 宸ヨ祫:' || c_row.sal); end loop;end;缁撴灉锛
绛旓細SQL*PLUS璨屼技鏄笉鑳鎵撳嵃鍑琛ㄦ牸鐨勶紝涓嶈繃鍙互缁欎綘鎺ㄨ崘涓娆鹃潪甯镐笉閿欑殑oracle绗笁鏂硅蒋浠PLSQL Developer锛岃繖娆捐蒋浠舵瘮oracle鑷甫鐨剆ql*plus瑕佸ソ鐢ㄨ澶氾紝鑰屼笖鍔熻兘鏇村己澶с傜綉涓婂彲浠ヤ笅杞斤紝鑰屼笖娉ㄥ唽鐮佸暐鐨勪篃濂芥悳锛屽鏋滄悳涓嶅埌鎴戝彲浠ュ彂缁欎綘
绛旓細鏄笉鏄綘浠ｈ繘鍘荤殑鍙傛暟鏈夐棶棰橈紝涓嶆弧瓒宠蛋exception鐨勬潯浠讹紝鍦ㄦ祴璇曠獥鍙ｉ噷闈唬鍙傛暟杩涘幓瀹氫綅涓涓嬪紓甯革紝鐪嬬湅鏈夋病銆
绛旓細dbms_output.enable(buffer_size => NULL);
绛旓細鍦ㄥ懡浠よ涓嬭緭鍏hell鎸囦护锛歸hereisoracle銆傛渶鍚庯紝鎸変笅鍥炶溅閿墽琛宻hell鎸囦护锛屾鏃朵細鐪嬪埌鏁版嵁搴搊racle鐨勫叿浣撲綅缃鎵撳嵃浜鍑烘潵銆5銆佸療鐪嬫湰鏈簅racle瀹夎鐩綍涓嬬殑tns閰嶇疆銆侶OME/network/admin/tnsnames.ora銆6銆乷racle鏌ョ湅鏈嶅姟鍣↖P鏂规硶銆傚伐鍏凤細plsql姝ラ锛氭墦寮plsql锛岀櫥褰曞埌鎸囧畾鏁版嵁搴撱
绛旓細浣犳渶濂藉湪debug妯″紡涓幏鍙栬繖涓彉閲忕殑鍏蜂綋鍊硷紝鎴栬呭湪瀛樺偍杩囩▼涓璬bms_output鎵撳嵃鍑烘潵浣犺繖涓sql璇彞銆
