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

Ë­ÄÜÍÆ¼ö¼¸±¾oracleµÄÊé»òÊÓÆµ - Oracle / ·Ç¼¼ÊõÇø

лл
ÎÒÒ²ÊÇÏëÖªµÀ

me too

ÎÒ Ò² Ïë Öª µÀ Æä Ëû µÄ£¬ÎÒ ÏÖ ÔÚ ¾Í ÔÚ Ñ§ orcale Êý ¾Ý ¿â£¬ÎÒ 
Óà µÄ ÊÇ ÕÔ Ôª ½Ü ±à µÄ.......

¸öÈ˾õµÃÔ­ÀíÐԵĶ«Î÷¿´Ò»Ð©¹Ù·½Îĵµ¿ÉÄÜ»áºÃһЩ Èç¹ûûÓÐÀÏʦ½ÌµÄ»°

ÖÐÎĵÄÊéÎÒ¿´¹ýµÄ´ó²¿·Ö¶¼ÊÇÄǸöORACLEPRESS³ö°æµÄ MCGRAWHILL

ûÓÐÌý˵¹ý°¡£¡



ÓÐûÓпª¹ýÕâ±¾ÊéµÄ£¬¸ø¸ö½¨Ò飿.. 3Q£¡~

ÒýÓÃ
ûÓÐÌý˵¹ý°¡£¡
ºÇºÇ ÎÒ˵µÄÄǾ仰¿ÉÄÜÓеãÆçÒå
ÖÐÎĵÄÊéÎÒ¿´¹ýµÄ´ó²¿·Ö¶¼ÊÇÄǸöORACLEPRESS³ö°æµÄ MCGRAWHILL 

¾ÍÊÇ˵ORACLEPRESS³ö°æµÄÊéÉÏÓ¡Á˸öMCGRAWHILLµÄLOGO
MCGRAWHILL²»ÊÇÊéÃû

oracle 10g Êý¾Ý¿â¹ÜÀíÓëÓ¦ÓÃϵͳ¿ª·¢ ÀîÏþÀè µÈ±àÖøµÄ£¬»ù±¾µÄ²Ù×÷»¹ÊDZȽÏÇåÎúµÄ£¬²»¹ýÊý¾Ý¿âµÄÊ鲻ͬµÄÊéÔÚ²»Í¬µÄ·½Ãæ²àÖØ²»Ò»Ñù £¬¶à¿´Ïà¹ØµÄ¼¸±¾¡£

ÊÓÆµµÄ»°
С²¼ÀÏʦµÄORACLE½²µÄºÃÏñ»¹¿ÉÒÔ
Â¥Ö÷¿ÉÒÔÈ¥ËÑËÑ¿´¿´ 
ͦ¶àµÄ

UpµÈÍÆ¼ö~

Oracle_9i_DBA_Fundamentals

лл¡£Ð¡²¼ÀÏʦµÄÊÓÆµ£¬¸ÕËÑÁËһϣ¬Óв»ÉÙ£¬»Ø¼ÒÏÂÔØ¡£


Ïà¹ØÎÊ´ð£º

adoÁ¬½ÓoracleµÄ¹ÖÎÊÌâ

ÒÔǰ³ÌÐòºÃºÃµÄ,ÄܽøÐÐÈκβÙ×÷
µ«´Ó×òÌ쿪ʼͻȻÁ¬½ÓÊý¾Ý¿âʧ°Ü,´úÂëÈçÏÂ:
try
{
        ::CoInitialize(NULL);
        hr=m_pConnection.Creat ......

ÀÏÎÊÌ⣺OracleÐÐתÁУ¨×Ö·û´®²ð·Ö£©

ÏÖÓÐÒÔÏÂÊý¾Ý£º
ID Name
1 Jack,Tom,Ben
2 Mary,Simth,Tony,Jay
ת»»Îª£º
ID Name
1 Jack
1 Tom
1 Ben
2 Mary
2 Simth
2 Tony
2 Jay
ÒªÇóʹÓÃSQL²éѯÍê³É£¬ÓÉÓÚÌõ¼þÏÞÖÆ£¬²»ÄÜʹÓà ......

OracleÀëÏß·ÃÎÊ---ÇóÖú - Oracle / »ù´¡ºÍ¹ÜÀí

´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄԭʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
    ´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......

Âé·³¸ø¿´¿´Õâ¸öoracleÓï¾ä¸ÃÔõÑùд

±íÃû£ºgk_record_new£¨ÕâÊÇÒ»¸ö¿¼ÇÚ±í£¬ËùÓÐÔ±¹¤µÄ¿¼ÇÚÊý¾Ý¶¼´æ·ÅÔÚÕâ¸ö±íÀÖ÷¼üΪ¿¨ºÅºÍʱ¼ä£©
±í½á¹¹£º
¿¨ºÅ£ºNUMBER(10)
»ùÕ¾£ºVARCHAR2(20)
ʱ¼ä£ºDATE
³öÈë±êÖ¾£ºVARCHAR2(1)
±íÊý¾Ý
¿¨ºÅ »ùÕ¾ ʱ¼ä ³ ......

ÓüÇʱ¾²é¿´Oracle¿ØÖÆÎļþ

ÎÒÓõÄÊÇNTϵͳ£¬µ±ÎÒÓüÇʱ¾²é¿´¿ØÖÆÎʼþʱ£¬×ÜÊÇÒ»´ó¶ÑÂÒÂ룬ÎÒ¸ÃÔõÑù²éѯ²¢¸Ä±ä¿ØÖÆÎļþÀïµÄÄÚÈÝÄØ£¿
2½øÖÆ ÓüÇʱ¾´ò¿ªµ±È»ÊÇÂÒÂë¿©

ÄÇÓÃʲô´ò¿ªÄØ£¿ÓÖÔõÑù´ò¿ªÄØ
£¿

¿ØÖÆÎļþÊǶþ½øÖÆÎļþ£¡

Ò»°ã ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ