Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Linux ƽ̨Ï Spoolµ¼³öÊý¾Ý²¢·¢Ë͵½ÓÊÏä

 
Spool³£ÓõÄÉèÖÃ
set colsep' ';¡¡¡¡¡¡ //ÓòÊä³ö·Ö¸ô·û
set echo off;¡¡¡¡¡¡¡¡//ÏÔʾstartÆô¶¯µÄ½Å±¾ÖеÄÿ¸ösqlÃüÁȱʡΪon
set feedback off;¡¡¡¡//»ØÏÔ±¾´ÎsqlÃüÁî´¦ÀíµÄ¼Ç¼ÌõÊý£¬È±Ê¡Îªon
set heading off;¡¡¡¡ //Êä³öÓò±êÌ⣬ȱʡΪon
set pagesize 0;¡¡¡¡¡¡//Êä³öÿҳÐÐÊý£¬È±Ê¡Îª24,ΪÁ˱ÜÃâ·ÖÒ³£¬¿ÉÉ趨Ϊ0¡£
set termout off;¡¡¡¡ //ÏÔʾ½Å±¾ÖеÄÃüÁîµÄÖ´Ðнá¹û£¬È±Ê¡Îªon
set trimout on;¡¡¡¡¡¡//È¥³ý±ê×¼Êä³öÿÐеÄÍÏβ¿Õ¸ñ£¬È±Ê¡Îªoff
set trimspool on;¡¡¡¡//È¥³ýÖØ¶¨Ïò£¨spool£©Êä³öÿÐеÄÍÏβ¿Õ¸ñ£¬È±Ê¡Îªoff
set wrap off;      //µ±Ò»ÐÐÏÔʾ²»ÏÂʱ²»·ÖÐÐÏÔʾ£¬ÕâÖÖÇé¿öÏ¿ÉÄܻᵼÖÂÐнضÏ
set long 999999       //ÏÔʾ²»ÍêÕû
 
 
×¢Ò⣺LINESIZEÒªÉÔ΢ÉèÖôóЩ£¬ÃâµÃÊý¾Ý±»½Ø¶Ï£¬ËüÓ¦ºÍÏàÓ¦µÄTRIMSPOOL½áºÏʹÓ÷ÀÖ¹µ¼³öµÄÎı¾ÓÐÌ«¶àµÄβ²¿¿Õ¸ñ¡£µ«ÊÇÈç¹û LINESIZEÉèÖÃÌ«´ó£¬»á´ó´ó½µµÍµ¼³öµÄËÙ¶È£¬ÁíÍâÔÚWINDOWSϵ¼³ö×îºÃ²»ÒªÓÃPLSQLµ¼³ö£¬ËٶȱȽÏÂý£¬Ö±½ÓÓÃCOMMENDÏ嵀 SQLPLUSÃüÁî×îС»¯´°¿ÚÖ´ÐС£
 
Èç¹ûÎÒÃDz»²ÉÓÃcolsep ·Ö¸ô·û£¬Ò²¿ÉÒÔÖ±½ÓÉèÖÃ×ֶεĿí¶ÈÀ´Ö´ÐС£
È磺column ÁÐÃû format a10
 
¶ÔÓÚ×Ö¶ÎÄÚ°üº¬ºÜ¶à»Ø³µ»»ÐзûµÄÓ¦¸Ã¸øÓë¹ýÂË£¬ÐÎ³É±È½Ï¹æ¾ØµÄÎı¾Îļþ¡£Í¨³£Çé¿öÏ£¬ÎÒÃÇʹÓÃSPOOL·½·¨£¬½«Êý¾Ý¿âÖÐµÄ±íµ¼³öΪÎı¾ÎļþµÄʱºò»á²ÉÓÃÁ½ÖÖ·½·¨£¬ÈçÏÂÊö£º
 
·½·¨Ò»£º²ÉÓÃÒÔϸñʽ½Å±¾¡¡
        set colsep '|'               --ÉèÖÃ|ΪÁзָô·û
¡¡¡¡set trimspool on
¡¡¡¡set linesize 9999     -- Èç¹ûÏÔʾ²»ÍêÈ«£¬¿ÉÒÔÊʵ±Ôö¼Ó¸Ã²ÎÊý
¡¡¡¡set pagesize 2000         
¡¡¡¡set newpage 1
¡¡¡¡set heading off           
¡¡¡¡set term off
        set num 18                 
        set feedback off          &nbs


Ïà¹ØÎĵµ£º

ÔÚ64λLinux»·¾³Ï°²×°OracleÊý¾Ý¿â10g

¾­¹ýÊýÌ첻иµÄŬÁ¦£¬LINUXÀú¾¡Èý´Î֨װ£¬ORACLE֨װN´ÎÖÕÓÚÔÚLiNUXAS4 update6 x86_64 ϰ²×°ºÃORACLE10g R 2 (64λ) ÁË¡£
ÏÂÃæ°Ñ°²×°¹ý³ÌºÍ´ó¼Ò·ÖÏíһϣ¬ÒÔÃâ¸ü¶àÈËÏñÎÒÒ»Ñù»¨·Ñ´óÁ¿µÄʱ¼äÔÚĪÃûÆäÃîµÄÎÊÌâÉÏ¡£
Ê×ÏÈҪ˵Ã÷µÄÊÇ£¬¹Ù·½Ò²ÓÐÏàÓ¦µÄÎĵµ°²×°µ«ÊÇʵ¼Ê¹ý³ÌÖУ¬»áÓÐһЩÎÊÌâÐèÒª½â¾ö¡£
±¾Îĵµ²ÎÕÕÁËÏà¹ØËµ ......

75%µÄLinux´úÂë¾­Óɸ¶·Ñ¿ª·¢Õß²úÉú


LinuxÊÀ½çÒ»Ö±³ÖÓÐ×ÔÓɵijç¸ßÀíÏ룬µ«ÏÖʵÉú»î×ÜÊÇÄÇô²Ð¿á£ºÃ»ÓÐÇ®ÊÇÍòÍò²»Äܵġ£
APC
Magazineµ÷²é·¢ÏÖ£¬LinuxµÄ¾ø´ó¶àÊýÄں˴úÂëÊÇÓÉ´ó¹«Ë¾·¢Õ¹µÄ£¬Êý×Ö´ïµ½Á˾ªÈ˵Ä75%£¬ÕæÕýµÄÎÞ³¥Ö¾Ô¸Õß¹±Ï׵ĴúÂëÖ»Õ¼´óÔ¼²»µ½20%£¬¾ø
´ó¶àÊý´úÂëÀ´×ÔÄù¤×ʵĹ«Ë¾Ô±¹¤£¬LinuxÄÚºËÿÌìÒÔ7000ÐеÄÊý¾ÝµÝÔö£¬½ö½ö´Ó2.6.28µ½2.6.32°æ ......

Linuxµç×ÓÊéÏÂÔØ

Linuxµç×ÓÊéÏÂÔØ——µÚÒ»²¿·Ö£º Linux»ù´¡Ó¦ÓÃ
µÚÒ»²¿·Ö£ºLinux»ù´¡Ó¦ÓÃ
1¡¢¡¶Linux´ÓÈëÃŵ½¾«Í¨¡·
http://www.gouhuo.com/study/linuxbook.zip
2¡¢ Linux ϵͳ°²È«ÓëÓÅ»¯ÖÐÎİæ
Õâ±¾ÊéµÄÓ¢Îİæ“Get Acquainted with Linux Security and Optimization System”£¨¼ò³ÆLinuxSOS£©ÊÇLinuxÎĵµ¼Æ»®£¨ ......

linuxÒÆÖ²¿ª·¢¼òµ¥²½Öè

LinuxÒÆÖ²¿ª·¢ ×¼±¸¹¤×÷£º ×¼±¸½»²æ±àÒ빤¾ßÁ´£ºÕâÀïÎÒÃÇÑ¡ÔñDENXÈí¼þ¹¤³ÌÌṩµÄELDK½»²æ±àÒë»·¾³£¬²Î¿¼µØÖ·£ºhttp://ftp.denx.de/pub/eldk/4.2/£¬ÎÒÃÇʹÓÃÆäÖеÄÒ»Ì×¹¤¾ß¡£×¼±¸¹¤×÷²½ÖèÈçÏ£º 1. ½¨Á¢¹¤×÷Îļþ¼ÐNewMsg2410,²¢½¨Á¢×ÓĿ¼sources works tools mkdir NewMsg2410 mkdir sources works tools 2. ×¼±¸arm- ......

linuxÍøÂçѧϰ±Ê¼Ç Íø¿¨Çý¶¯Êý¾Ý½ÓÊÕ[zz]

ת×Ôhttp://blog.chinaunix.net/u3/105004/showart_2088056.html
Êý¾Ý½ÓÊÕ
Íø¿¨Çý¶¯µÄÊý¾Ý½ÓÊÕ£¬Êµ¼ÊÉÏÊÇÒ»¸öÉú²úÕß/Ïû·ÑÕßÄ£ÐÍ¡£ºËÐÄÊÇÊäÈë¶ÓÁУ¨È«¾ÖµÄ£¬»òÕßÍø¿¨Ë½Óеģ©¡£Íø¿¨ÊÕµ½Êý¾Ýʱ£¬´¥·¢Öжϡ£ÔÚÖжÏÖ´ÐÐÀý³ÌÖУ¬°Ñskb¹ÒÈëÊäÈë¶ÓÁУ¬²¢³ö·¢ÈíÖжϡ£ÉÔºóµÄij¸öʱ¿Ì£¬µ±ÈíÖжÏÖ´ÐÐʱ£¬ÔٴӸöÓÁÐÖаÑskbÈ¡ÏÂÀ´£¬Í ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ