°²×°OracleµÄsqlplus°ïÖúϵͳ
ÔÚlinuxϵͳϵÄʱºò£¬ÎÒÃÇ¿ÉÒÔͨ¹ýmanÃüÁ»ñµÃϵͳÀï¶Ôij¸öÃüÁîµÄusageµÄ½âÊÍ¡£
ÔÚsqlplusÀïÎÒÃÇÒ²¿ÉÒÔͨ¹ýhelpºÍ?ÃüÁî¡£
sqlplusµÄ°ïÖúÖ÷Ìâ¶ÔÓ¦µÄÊÇÊý¾Ý¿âÀïµÄÒ»Õűí(system.help)¡£
ÔÚ$ORACLE_HOME/sqlplus/admin/help/Ŀ¼ÏµÄhelpus.sql°üº¬ÁËÕâ¸ö±íµÄ°ïÖúÖ÷Ìâ
²»¹ýoracle×Ô´øµÄhelpºÍ?µÄ½âÊÍÌ«ÉÙÁË
ÔÚÍøÉÏÕÒÁ˺ܾÃÖÕÓÚÕÒµ½Ò»¸öºÜÈ«µÄhelp.sqlß·
ÏÂÔØÎÄÖи½¼þ£¬ÓÃsystemµÇ¼£¬ÒòΪÕâ¸öÊǽ¨Á¢ÔÚsystemµÄschemaÀïµÄhelp±íÀïµÄ¡£
Ö±½ÓÖ´Ðнű¾¾Í¿ÉÒÔÁË¡£±ÈÈçÎÒ°ÑÕâ¸ösql±£´æµ½$ORACLE_HOME\sqlplus\admin\helpÀ
´ó¼ÒÔÚÕâÀï¿ÉÒÔ¿´µ½ÓÐ
helpbld.sql
helpdrop.sql
helpus.sql
hlpbld.sql
ÕâËĸöÎļþ£¬Õâ¾ÍÊÇoracle×Ô´øµÄhelp½Å±¾¡£¿ÉÒÔÖ´ÐÐ
helpbld.sqlÀ´°²×°oracleĬÈϵÄhelp£¬ ÕâÀï»áÌáʾÄãÊäÈëÁ½¸ö²ÎÊý£¬¿´ÁËÕâ¸öÔ´Îļþ¡£
Á½¸ö²ÎÊýÒ»¸öÊǵ±Ç°Â·¾¶£¬Ò»¸öÊÇhelpus.sql£¬ »¹ÊÇÓÃsystemÀ´Ö´ÐУ¬Ö´ÐÐÍê¾Í°²×°ÁËhelp£¬
¾Í¿ÉÒÔʹÓÃÎÒÉÏÃæµÄÄÇЩ·½Ê½¡£Õâ¸öÊÇĬÈϻᰲװµÄ¡£
Òª°²×°ÎÒÕâ¸ö×îеÄhelpÎļþ£¬Ö»ÐèÒªÖ´ÐоͿÉÒÔÁË
SQL>conn system/systempwd;
SQL>@?/sqlplus/admin/help/helpbld.sql
ÊäÈë 1 µÄÖµ: F:\developer\oracle\product\10.2.0\db_1\sqlplus\admin\help
ÊäÈë 2 µÄÖµ: F:\developer\oracle\product\10.2.0\db_1\sqlplus\admin\help\help.sql
ÕâÀï¾Í»áÖ´ÐÐÁË£¬Ö´ÐÐÊÇÓÐһЩºÍĬÈϵÄÓгåÍ»£¬¿ÉÒÔºöÂÔÕâЩ´íÎó¡£
³É¹¦ÒÔºó£¬ÎÒÃÇÖ´ÐÐÒ»ÏÂ
SQL> select count(*) from system.help ;
COUNT(*)
----------
5085
Ïà¹ØÎÊ´ð£º
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......
delphi Ôõô½«oracleµÄlong raw ×Ö¶ÎÖµ µ¼Èëblob×Ö¶Î
http://blog.csdn.net/zxf_feng/archive/2008/12/21/3571961.aspx
¿´¿´Õâ¸ö
ÒýÓÃ
vStream := TMemorySt ......
with adod_dict do
begin
close;
commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......
sqlplusÁ¬½ÓOracleÊý¾Ý¿âµÄÕû¸öÁ÷³Ì£¬
ÀýÈç sqlplus /nolog
conn system/oracle£¨ÃÜÂ룩
Õâ¸öÁ¬½ÓOracleµÄÕû¸ö»úÖÆÊÇʲô£¨×¢ÖØÓÚÁ¬½ÓµÄÔÀíÉÏ£©
Èç¹ûÓÐ˶®»òÓÐÏà¹ØÄÚÈݸøÓèÌáÊ ......