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

oracleÊý¾Ý¿â´ò¿ªsql*plusʱÓöµ½ÎÊÌâ

ÎÒÏëѧoracle£¬¸Õ×°Íêoracle10g for Vista£»´ò¿ªSQL*Plusʱ£¬Èç¹ûµÚÒ»´ÎÊäÈëÕýÈ·µÄÓû§ÃûºÍ¿ÚÁî¾Í¿ÉÒÔ´ò¿ªËü£¬Èç¹ûµÚÒ»´ÎÊäÈë´íÎóµÄ£¬µÚ¶þ´ÎÔÙÊäÈëÕýÈ·µÄ£¬¾Í»áÌáʾÓû§Ãû/¿ÚÁîÓÐÎ󣬾ܾøµÇ¼£¬ÄÄλ¸ßÊÖÓÐʱ¼ä°ïÎÒ½âÊÍһϣ¬²¹³äһϣ¬ÓÃcmd´ò¿ªsqlplusʱ£¬Èç¹ûµÚÒ»ÊäÈë´íÎóÃÜÂ룬µÚ¶þ´ÎÊäÈëÕýÈ·ÃÜÂ룬ÊÇ¿ÉÒÔ´ò¿ªµÄ
SQL code:
--Óиö²ÎÊý£ºÓÃÒÔ¿ØÖƳ¢ÊÔÃÜÂë´ÎÊýµÄ


SQL code:
loginretries = 3


SQL code:
alter profile default limit failed_login_attempts 5;



3Â¥ÄǸöºÃÏñÊÇlinuxµÄ°É£¿

û¿´¶®Â¥Ö÷µÄÒâ˼£¬×öÁËЩ²Ù×÷. Â¥Ö÷²Î¿¼Ï£º

SQL code:

C:\Documents and Settings\user.HQ-TEXT>sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on ÐÇÆÚÁù 9ÔÂ 26 13:43:53 2009

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> conn sys/admin as sysdba; -- ÕýÈ·µÄÓû§ÃûºÍÃÜÂë
ÒÑÁ¬½Ó¡£
SQL> conn system/admin; -- ÕýÈ·µÄÓû§ÃûºÍÃÜÂë
ÒÑÁ¬½Ó¡£
SQL> conn system
ÊäÈë¿ÚÁî: --´íÎóµÄÃÜÂ룬ֱ½ÓÍ˳öÁ¬½Ó´°¿Ú£¬ÐèÒªÖØÐÂÁ¬½ÓÁË..
ERROR:
ORA-01017: invalid use


Ïà¹ØÎÊ´ð£º

csvÎļþת»»³Ésqlµ¼Èëµ½Êý¾Ý¿â£¬Ã»ÓÐÊý¾ÝΪºÎ£¿

Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......

¼±Ñ°Oracle ERPʵʩ¹ËÎÊ

3-5ÈË£¬¹¤×÷µØµãÉϺ£ÆÖ¶«Èí¼þÔ°£¬2-3Äê¾­Ñ飬ӢÎÄÁ÷Àû£¬ÓÐÒâÕßÇëÁªÏµ38954510-1355£¬15821699737£¬y.ming@live.cn
×Ô¼º¶¥¡£¡£¡£

ûÓÐORACLE ERPµÄ¾­Ñé,ÓÐÓÃÓѺÍTIPTOP¾­Ñé,Ó¢Óï˵²»ºÃ,¿´»¹ÊÇ¿ÉÒÔ!
²»ÖªµÀÓÐûÓÐ ......

oracleÈëÃÅÅäÖÃ

oracleÁ¬½ÓɶÕâô¸´ÔÓ°¡.
oracle 10g
ÓÃps/sql devÔõôҲÁ¬²»ÉÏ.
ÓÃsqlplus¿ÉÒԵǽ.net manager֮ǰ²âÊÔÁ¬½ÓÁ˳ɹ¦µÄ.ÏÖÔÚ¸ãµÃÒ²Á¬½Ó²»ÁË.
listener.ora:
SID_LIST_LISTENER =
  (SID_LIST =
  ......

¼±ÎÊÒ»¸öoracle×Ö¶ÎÉèÖõÄÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷´óÀÏʦºÃ£¬Çë½ÌÒ»¸öÎÊÌ⣮
ÎÒÉèÖÃÁËÒ»¸öoracle×ֶΣ¬varchar(3000),È»ºó²åÈëÒ»ÌõÊý¾Ý³¤¶È²Å1000,¾Í±¨´íÁË£®È磺net.sf.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
Caused ......

´ÓORACLEµ½DB2µÄSQLÓï¾äÎÊÌâ

ÏÖÔÚÓÐÒ»ORACLEÖеÄSQLÓï¾ä£¬ÐèÒªÒÆÖ²µ½DB2ÖУ¬ÇëÎʸÃSQL¸ÄÈçºÎд
ORACLEÖУº
select floor(months_between(date1,date2)) from A  
date1,date2·Ö±ðΪ±íÖеÄÁ½¸ö×Ö¶Î £¬¶¼ÎªÈÕÆÚÐÍ 
DB2ÖÐÈçºÎʹÓÃÐ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ