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

Oracle¿Í»§¶ËµÄÐ¶ÔØ

1.Á÷³ÌÈçÏÂ
Óû§¿ÉÒÔʹÓÃOracle°²×°³ÌÐò´ÓWindows NT¿òÖÐɾ³ýËùÐèÒªµÄ²úÆ·£¬µ«ÊÇÕâ¿ÉÄÜÓеã·Ñ¾¢¡£
Èô²»Ïë±£ÁôÈκÎN TµÄOracle²úÆ·£¬¿ÉÒÔ°´ÒÔÏÂÖ¸Áîɾ³ýËùÓеÄOracle²úÆ·£º
1) Ê×ÏÈ£¬ÓÿØÖÆÃæ°åÉ쵀 Services Ó¦ÓóÌÐòÍ£Ö¹ËùÓеÄOracle·þÎñ¡£
ËùÓеÄOracle·þÎñ¶¼Ó¦ÓÐÒ»¸ö°üº¬“O R C L”¡¢“Oracle”»ò“T N S”µÄÃû×Ö¡£Ã¿´Î·´ÏÔÒ»¸ö£¬µ¥»÷S t o p°´Å¥¡£
2) ½ÓÏÂÀ´£¬ÔËÐÐregedit¡¢Windows 2000 Registry Editor²¢Ñ¡ÔñHKEY_LOCAL_MACHINE→SOFTWARE→Oracle¡£Ê¹ÓÃD E L¼üɾ³ý¸ÃÏî¡£
3) ÏÖÔÚ£¬Ñ¡ÔñKEY_LOCAL_MACHINE→SYSTEM →CurrentControlSet→Services ¡£ÏòϹö¶¯¸ÃÁÐ±í£¬²¢É¾³ýËùÓеÄOracleÏî¡£
4) ´Ó×ÀÃæÉÏɾ³ýOracle³ÌÐò×飬´ÓS t a r t u p×éÖÐɾ³ýOracle To o l b a rͼ±ê¡£
5) ɾ³ýÓëOracleÏà¹ØµÄËùÓÐÎļþ¡£Ê¹ÓÃNT Explorer£¬Ñ¡ÔñOracleËùÓеÄȱʡh o m eĿ¼£¬C£º\Oracle£¬É¾³ýÕû¸öĿ¼¼°ÆäËùÓеÄ×ÓĿ¼¡£ÁíÍ⣬ÔÙ´ÓWindows NTµÄhomeĿ¼(ͨ³£ÎªC£º\ winnt )ÖÐɾ³ýÏÂÁÐÎļþ£º
ORACLE.INI ,ORADIM.INI OTOOLBAR.INI*,OTEMP.INI VS20.INI*
6) ÈôÓû§ÓÐOracle µÄ1 6λWindows 3.1 Ó¦ÓóÌÐò(ͨ³£ÔÚC£º\OrawinÎļþ¼ÐÖÐ)£¬Ò²¿ÉÒÔɾ³ý´ËÎļþ¼Ð¡£
7) ×îºó£¬ÈôÓû§ÔÚw i n . i n iÎļþÖÐÓÐ( Oracle )±ê¼Ç¶Î£¬Ôòɾ³ý¸Ã¶Î¡£


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

jdbcÁ¬½ÓOracle

      ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
    ½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
    ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
    Ê×ÏÈ£¬Ô ......

Oracle×Ô´úµÄÏ̳߳Ø

µÚÒ»¸öÀࣺ
/**
 *
 * ´æ·ÅoracleÊý¾Ý¿âµÄÁ´½ÓÐÅÏ¢¡£
 *
 * @author ZhongHuiQiang
 *
 */
public interface IOracleDAOInfor {
 String DB_SERVER_HOSET = "localhost";
 String DB_SERVER_NAME = "ppoo";
 String DB_USER_NAME = "system";
 String DB ......

ORACLE²éѯ»òɾ³ýʱָ¶¨Ê¹ÓÃË÷ÒýµÄд·¨­

 ²éѯʱ¿ÉÒÔÖ¸¶¨Ê¹ÓÃË÷ÒýµÄд·¨¡£­
­
SELECT   /*+ index(TB_ALIAS IX_G_COST3) */­
  TB_ALIAS.*­
  from g_Cost TB_ALIAS­
WHERE Item_Two = 0­
   AND Flight_Date >= To_Date('20061201', 'YYYYMMDD')­
   AND Flight_D ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ