Ubuntu°²×°OracleºóÔËÐÐSqlplus±¨´íµÄ½â¾ö°ì·¨
µ±ÔËÐÐsqlplus.shµÄʱºò±¨³ö£º
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/nls_lang.sh: 114: [[: not found
ºÜÆæ¹Ö
nls_lang.shµÄ114ÐÐǰºóÊÇÕâÑùµÄ
if [[ -n "$LC_ALL" ]]; then
locale=$LC_ALL
elif [[ -n "$LANG" ]]; then
locale=$LANG
else
locale=
fi
[[ÓдíÎ󣿲»¿ÉÄÜ£¬Æäʵ´íÎóÔÚoracle_env.shÖÐ
½«ÆäÖеÄ
NLS_LANG=`$ORACLE_HOME/bin/nls_lang.sh` Ìæ»»Îª
NLS_LANG='$ORACLE_HOME/bin/nls_lang.sh' Çø±ðÔÚÓÚÄǸöµ¥ÒýºÅ
»¹ÓÐÒ»¸öÎļþ/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/config/scripts/sqlplus.sh
´íÎóÊÇÒ»ÑùµÄ£¬¸ÄÄǸöÒýºÅ£¬Èç¹ûÓдíÎó¾ÍÈ¥µôÄǸöÒýºÅ£¬Ã»ÓÐÎÊÌâµÄ¡£
Ïà¹ØÎĵµ£º
ʹÓÃCodeSmithÉú³ÉoracleÊý¾Ý¿â±íµÄʵÌå²ã(Model)
http://blog.csdn.net/dacong/archive/2009/01/27/3853663.aspx
×Ô¼ºÐ´µÄ£¬CodeSimthÖеÄÀý×Ó¶¼ÊÇmsSQL serverµÄ£¬ËùÒÔ×Ô¼ºÐ´Á˸öÖ§³ÖOracleÊý¾Ý¿â±íµÄ£¬²»Ò»¶¨ºÜÍêÉÆ£¬ÊÊÓþͺã¬Êý¾ÝÀàÐÍûÓÐÖÜÈ«¿¼ÂÇ£¬Ö»¿¼ÂÇÁ˳£ÓõÄһЩÀàÐÍ£¬Ôö¼ÓÁ˸ö±íÃû×ÖÊôÐÔ£¬²ÉÓõÄ.net2.0ÎÒ½á ......
ÔÚLinuxϰ²×°Oracle Database 9i
2009Äê05ÔÂ11ÈÕ ÐÇÆÚÒ» 20:49
http://www0.ccidnet.com/tech/guide/2001/11/20/58_3761.html
Oracle9i 2000Äê10ÔÂÔÚOracle Open WorldÉÏ·¢²¼£¬Îª Oracle Êý¾Ý¿â¡¢Ó¦Ó÷þÎñÆ÷ºÍ¿ª·¢¹¤¾ßÒý½øÁËÐí¶àй¦ÄÜ¡£Oracle9iÊÇÒµ½çµÚÒ»¸öÍêÕû¡¢¼òµ¥µÄÓÃÓÚ»¥ÁªÍøµÄÐÂÒ»´úÖÇÄÜ»¯µÄ¡¢Ð×÷¸÷ÖÖÓ¦ÓõÄÈí ......
TO_DATE¸ñʽ(ÒÔʱ¼ä:2007-11-02 13:45:25ΪÀý)
Year:
yy two digits Á½Î»Äê ÏÔʾֵ:07
yyy three digits ÈýλÄê &nbs ......
½ñÌìÔÚÒ»±¾ÊéÉÏ¿´µ½µÄ£¬¸Ð¾õͦȫµÄ¡£Ó¡ÏóÖÐ×Ô¼ºÒѾ²»ÖªµÀ°Ù¶ÈÁ˶àÉÙ´ÎÕâ¸öÎÊÌ⣬½ñÌì¾Í¼ÇÏÂÀ´°É£¬·½±ãÒÔºó²éѯ¡£
Êý¾Ý¿âд½ø³ÌÔÚÒÔÏÂʼþÖ®Ò»·¢Éúʱ°ÑÊý¾Ý¿â¸ßËÙ»º³åÇøµÄÊý¾Ýдµ½Êý¾ÝÎļþÉÏ:
µ±Ô໺³åÇøµÄÊýÁ¿³¬¹ýÁËËùÉ趨µÄÏÞ¶î
µ±ËùÉ趨µÄʱ¼ä¼ä¸ôÒѵ½
µ±Óнø³ÌÐèÒªÊý¾Ý¿â¸ßËÙ»º³åÇøÈ´ÕÒ²»µ½¿ÕÏеĻº³åÇøÊ±
µ±¼ì²éµ ......
Òò¿ª·¢ÒªÇó£¬ÐèÒª¶ÔoracleÀïµÄÊý¾ÝÓëÊý¾ÝÎļþ×÷±È½Ï¡£Èç²ÉÓÿͻ§¶ËÁ¬½ÓoracleµÄ·½Ê½ÔòÏÔµÃСÌâ´ó×ö£¬ÇÒ¹¤×÷Á¿´ó£¬²»Ò×ά»¤¡£Ö±½Ó²ÉÓô洢¹ý³Ì£¬µ÷ÓÃUTL_FILE°üµÄ¹«¹²¹ý³Ì£¬ÏԵ÷½±ãµÃ¶à¡£
Ê×ÏÈ£¬ÐèÒª°ÑÊý¾ÝÎļþËùÔÚµÄĿ¼ע²áµ½oracleÖУ¬ÓÃcreate directory¡£¡£¡£Óï¾ä£¬È»ºó°Ñ´ËÄ¿ ......