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

°²×°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


Ïà¹ØÎÊ´ð£º

PHP Á¬½ÓOracle ³ö´í

<?php
  getenv("ORACLE_HOME");
  $conn=ocilogon("test","test","test_db");
  if($conn)  
  echo success;  
&nb ......

ÇóÖúORACLEÅúÁ¿Çå³ý±íÊý¾ÝµÄÎÊÌâ - Oracle / ¿ª·¢

±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í
ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼
ÄÄλ¸ßÈË°ïÖúÏ°¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ²
SQL code:
......

ÇóʹÓÃt-sqlÓï¾ä½«paradoxÊý¾Ýµ¼ÈëoracleµÄ°ì·¨

ʹÓÃt-sqlÓï¾ä½«sqlserver2kÊý¾Ýµ¼ÈëparadoxµÄ¹¦ÄÜÎÒÒÑʵÏÖ£¬ÓõÄÊÇinsert into ... from table in [ODBC][ODBC;Driver=SQL Server...]µÄ°ì·¨£¬µ±ÎÒ×¼±¸Èç·¨ÅÚÖÆÍê³Éparadoxµ¼Èëoracleʱȴ²»ÐУ¬²»±¨´íµ«ÊÇÖ´ÐкóÃ»Ó ......

ÖªµÀÔõô°Ñsasµ¼ÈëoracleµÄ½øÀ´¿´¿´

ÎÒÏÖÔÚÓÐһЩsasÉÏÃæµÄÊý¾ÝÎļþ ÏÖÔÚÎÒÐèÒª°Ñsasµ¼Èëµ½oracle
ÏÖÔÚ°ÑÒ»¸ösasÎļþµ¼Èëµ½Ò»¸öoracleÖеÄÒ»¸ö±íÖÐÎÒÒѾ­ÖªµÀÔõôŪÁË
µ«ÊÇ ÎÒÏÖÔÚÐèÒª°ÑsasÖеÄÁíÒ»¸öÎļþ×·¼Óµ½oracleÖеÄÒ»¸öÓÐÊý¾ÝµÄÒ»¸ö±íÉÏà ......

sqlplusÁ¬½ÓoracleÊý¾Ý¿âÔ­Àí£¿

sqlplusÁ¬½ÓOracleÊý¾Ý¿âµÄÕû¸öÁ÷³Ì£¬
ÀýÈç sqlplus /nolog
    conn system/oracle£¨ÃÜÂ룩

Õâ¸öÁ¬½ÓOracleµÄÕû¸ö»úÖÆÊÇʲô£¨×¢ÖØÓÚÁ¬½ÓµÄÔ­ÀíÉÏ£©

Èç¹ûÓÐË­¶®»òÓÐÏà¹ØÄÚÈݸøÓèÌáÊ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ