oracle sqlplus Óëdos ÖÐÎÄÂÒÂë
1.SQL> select * from v$nls_parameters;
PARAMETER VALUE
----------------------------------- ------------------------------------
--------------------
NLS_LANGUAGE SIMPLIFIED CHINESE
NLS_TERRITORY CHINA
NLS_CURRENCY RMB
NLS_ISO_CURRENCY CHINA
NLS_NUMERIC_CHARACTERS .,
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE SIMPLIFIED CHINESE
NLS_CHARACTERSET ZHS16GBK
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT
Ïà¹ØÎĵµ£º
ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬ÔÀ´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......
ÏÈ×°ÁËÊý¾Ý¿â£¬ÓÃnetµ÷ÊÔµÄʱºòûÓÐÎÊÌ⣬µ«ÊÇÉú³ÉÍøÕ¾ºó£¬ÔÚÁ¬½ÓÊý¾Ý¿âµÄʱºòÌáʾ˵¿Í»§¶ËµÄ°æ±¾Ì«µÍ£¨Òâ˼¾ÍÊÇÕâ¸ö£©£¬ºóÓÖ×°ÁËÒ»¸ö9iµÄ¿Í»§¶Ë£¬Ö®ºó¾Í°ÑÏà¹Ø·þÎñ¸Ä³ÉÊÖ¶¯£¬NÌìÖ®ºó·¢ÏÖÊý¾Ý¿â²»ÄÜÕý³£Æô¶¯¡£
Message file sp1<lang>.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracl ......
µÚ28Õ Oracle·þÎñÆ÷ÅäÖú͹ÜÀí
ÌáÆðÊý¾Ý¿â£¬µÚÒ»¸öÏëÆðµÄ¹«Ë¾Ò»°ã¶¼»áÊÇOracle¡£Oracle¹«Ë¾ÓÚ1977Äê³ÉÁ¢£¬×¨×¢ÓÚÊý¾Ý¿â²úÆ·µÄ¿ª·¢£¬ÔÚÊý¾Ý¿âÁìÓòÒ»Ö±¶¼´¦ÓÚÁìÏȵØ룬Æä²úÆ·¸²¸ÇÁË´ó¡¢ÖС¢Ð¡ÐÍ»úµÈÊýÊ®ÖÖ»úÐÍ£¬ÊÇÄ¿Ç°ÊÀ½çÉÏʹÓÃ×î¹ã·ºµÄ¹ØϵÊý¾Ý¿âϵͳ֮һ¡£±¾½ÚÒÔÆä×îеÄÊý¾Ý¿â²úÆ·Oracle 11gΪÀý£¬½éÉÜÈçºÎÔÚRed ......
Æô¶¯ºÍÍ£Ö¹Êý¾Ý¿â
Àý³Ì£>ÅäÖã>Ò»°ãÐÅÏ¢ÖÐ Æô¶¯ºÍÍ£Ö¹Êý¾Ý
Í£Ö¹Êý¾Ý¿âÓ¦¸ÃÑ¡Ôñ£ºµ±ËùÓÐÊÂÎñ½áÊøʱ¡£
Ò²¿ÉÒÔÓÃÃüÁîÆô¶¯ºÍÍ£Ö¹(ÓÃoracleÓû§µÇ½)
Æô¶¯ £º lsnrctl start //Æô¶¯ lister
sqlplus /nolog <<EO ......
ÔÎĵØÖ·£ºhttp://fandayrockworld.javaeye.com/blog/540509
»Ø¹Ë£º
Ò»¡¢ ROWIDµÄ¸ÅÄî
¡¡¡¡´æ´¢ÁËrowÔÚÊý¾ÝÎļþÖеľßÌåλÖãº64λ±àÂëµÄÊý¾Ý£¬A-Z, a-z, 0-9, +, ºÍ /£¬
¡¡¡¡rowÔÚÊý¾Ý¿éÖеĴ洢·½Ê½
¡¡¡¡SELECT ROWID, last_name from hr.employees WHERE department_id = 20;
¡¡¡¡±ÈÈ磺OOOOOOFFFBBBBBBRRR
......