ÇóÖú£¡ÈçºÎ´ò¿ªoracle 10g - Oracle / »ù´¡ºÍ¹ÜÀí
а²×°Á˸öoracle£¬µÚÒ»´ÎÓñȽÏÃÔ㣬¸ù±¾²»ÖªµÀÔõô´ò¿ª£¬´ò¿ªoracle SQL*PlusÊäÈ밲װʱµÄÓû§ÃûºÍÃÜÂë²»¶Ô£¬ÊäÈëÍøÉϲéµÄÓû§Ãû£ºSYSTEM ÃÜÂ룺MANAGER Ö÷»ú×Ö·û´®£ºTCP-LOOPBACK Ò²²»¶Ô£¬ÓÐûÓÐÄÇλÈÊÐÖÖªµÀ¡£Â鷳˵ϰ¡¡£¡£
ÏÈÔÚ·þÎñÆô¶¯ÏîÀïÃæÆô¶¯¡°OracleServiceORCL¡± ÔÚÊäÈëÓû§¸úÃÜÂë: ²»¼ÇµÃÃÜÂëÕâÑù "¿ªÊ¼---ÔËÐÐ--¡®ÊäÈ룺cmd¡¯--È»ºóÊäÈë sqlplus /nolog" C:\Documents and Settings\Administrator>sqlplus /nolog SQL*Plus: Release 10.2.0.1.0 - Production on ÐÇÆÚ¶þ 5Ô 11 13:19:23 2010 Copyright (c) 1982, 2005, Oracle. All rights reserved. SQL> connect / as sysdba ÒÑÁ¬½Ó¡£ SQL> alter user system identified by sys --°ÑÃÜÂë¸ÄΪsys 2 / Óû§ÒѸü¸Ä¡£ È»ºóÔڵǽoracle SQL*Plus ÊäÈëÓû§¸úÃÜÂë ÔÚ°²×°µÄʱºòÓÐÒ»¸öÑ¡ÔñÓû§ºÍÉèÖÃÃÜÂëµÄµØ·½¡£ÄÇÀï¿ÉÒÔ×Ô¼ºÉèÖÃÃÜÂëÈç¹ûûÓÐÉèÖõϰ¾ÍÊÇĬÈϵÄÃÜÂë system/manager,Èç¹ûÄãÁ¬½Ó²»½øÈ¥¿ÉÄÜÊÇÄã¼àÌýÆ÷û¿ª»òÕßÊÇÊý¾Ý¿â·þÎñû¿ª£¬ÓÒ¼üÎҵĵçÄÔ-¹ÜÀí-·þÎñºÍÓ¦ÓóÌÐò-·þÎñ OracleOraDb10g_home1TNSListener¼àÌýÆ÷±ØÐëÒª¿ªÒýÓà ÏÈÔÚ·þÎñÆô¶¯ÏîÀïÃæÆô¶¯¡°OracleServiceORCL¡± ÔÚÊäÈëÓû§¸úÃÜÂë: ²»¼ÇµÃÃÜÂëÕâÑù "¿ªÊ¼---ÔËÐÐ--¡®ÊäÈ룺cmd¡¯--È»ºóÊäÈë sqlplus /nolog" C:\Documents and Settings\Administrator>sqlplus /nolog SQL*Plus: Release 10.2.0.1.0 - Production o¡¡ ÁíÍÆ¼öÄãÈ¥ ²¥²¼¿Í¡£ {{-
Ïà¹ØÎÊ´ð£º
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl"; private static final String USERNAME = "sys"; private static final String PASSWORD = "s ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£ ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ 10GºÍ11GµÄ http://www.oracle.com/technology/software/products/database/index.html ------------------------------------------- ......
Ö÷ÒªÏëʵÏÖ£ºÔÚÿÌìµÄ0µã֮ǰ×Ô¶¯½«Êý¾Ý²åÈëÊý¾Ý¿â£¬Ï£Íû´ó¼ÒÖ¸µã£¡ ×Ô¶¯²åÈë?Êý¾ÝÔ´ÄÄÀïÀ´µÄ,²åÈ뵽ʲôµØ·½ ´¥·¢Æ÷? Ó¦¸ÃÓÃJOB Êý¾ÝÔ´ÔÝʱÏëµÄÊǹ̶¨Êý¾Ý£¬²åÈëµ½Ò»Õűí ÄǾÍÊÇÓÃJOB¶¨Ê±Ö´ÐÐ,´ÓÎļþµ¼ÈëÊ ......
ORACLEÅàѵ(OCA)ÈÏÖ¤½éÉÜ Oracle10g Certified Associate (OCA) Oracle ÈÏ֤רԱ¡£ ¿¼ÊԳɼ¨Í¨¹ýÄÜ»ñµÃOracle¹«Ë¾ÎªÄú°ä·¢µÄÈ«ÇòÈÏÖ¤µÄÓ¢ÎÄOCAÖ¤Êé¡£OCAÓÉOracle¹«Ë¾³öÌâ¡£ ¸ÃÖ¤Êé¿É×÷Ϊ¸÷ÆóÊÂÒµµ¥Î»Êý¾Ý¿ ......
ÓÐÕâÑùÒ»ÌõSQL Select Get_Costtaxrate(col1), Get_Tcostvalue(col1) from a ÆäÖÐGet_Costtaxrate¡¢Get_Tcostvalue¶¼ÊǺ¯Êý£¬ÕâÁ½¸öº¯ÊýÀïÃæ¶¼ÊDzéÕÒÒ»¸ö´ó±í£¬Get_Tcostvalue»¹ÐèÒªµ÷ÓÃGet_C ......