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

oracleÊý¾Ý¿âµÄÃû×ÖÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÒÔÚ´´½¨Êý¾Ý¿âµÄʱºòÓõÄÃû×ÖΪoracle10£¬µ«ÊÇ´´½¨ºÃºó£¬ÔÚĬÈϵÄĿ¼ÏÂÏÔʾµÄÃû³ÆÈ´ÊÇoracle10g£¬ÕâÊÇΪʲô£¿
Äã¿´µÄ 10gÊǰ²×°Ä¿Â¼°É 


SQL> select name from v$database;

NAME
---------
ORCL


ÒòΪÄã°ÑÎļþ¼Ð¿´´íÁ˰ɡ£

´ó¸ç£¬Èç¹û²»ÊÇÄãÑÛ»¨µÄ»°£¬ÄÇ¿ÉÄܾÍÊÇÄã½ø´íµØ·½ÁË¡£

ÓÃÈýÂ¥µÄ·½·¨²éһϾÍÖªµÀÊÇʲôÁË

ÄãÃǶ¼ÊÇһȺÖí£¬ÊÇӦΪoracle10Êǹؼü×Ö£¬ËùÒÔĬÈϵİÑoracle10±äΪoracle10gÁË¡£²»ÖªµÀ²»ÒªÂÒ·¢ÎÞÓõÄÌù¡£

ÒýÓÃ
ÄãÃǶ¼ÊÇһȺÖí£¬ÊÇӦΪoracle10Êǹؼü×Ö£¬ËùÒÔĬÈϵİÑoracle10±äΪoracle10gÁË¡£²»ÖªµÀ²»ÒªÂÒ·¢ÎÞÓõÄÌù¡£


ÕûÈËÓÐÒâ˼Â𣿡¡ÖªµÀ´ð°¸Ö±½Ó·¢ÉÏÀ´¹²Í¬Ñ§Ï°¡£¡¡Ñ§Ï°ÒªÇ«Ð飬¡¡Ã¿È˶¼ÓÐ×Ô¼ºµÄÓŵ㡣¡¡±ðÈËÈÈÐĵİïÄ㣬»¹³ö¿ÚÂîÈË£¬ÓÖ¼ûÒ»¸ö¸öÐÔµÄ90ºó£¬ ÕæÎÞÓïѽ.. ÒÔºó»¹ÏëÔÚÕâÀï»ì£¬×îºÃÇ«Ðéµã..

liuxinyu19901016


ÏȰÑÕâÌù¶¥ÆðÀ´£¬Èôó¼Ò¶¼ÈÏʶÈÏʶÄã.. liuxinyu19901016

¹þ¹þ 
90ºó¡­¡­

ʲô½ÐÖªµÀ´ð°¸£¬ÕâÊǺóÀ´Ñ§Ï°²éÕÒ¸ãÃ÷°×µÄ¡£Ê²Ã´½ÐÎÒÑÛ¾¦ÓÐÎÊÌ⣬²»ÖªµÀ¾ÍÊDz»ÖªµÀ»¹ÓýƱçÂð£¿ÎÞÓï¡£¡£¡£¡£¡£

ºÇºÇ
ºÍг ÂÛ̳ÐèÒªºÍг

1
¼´±ãÊÇÄãºóÀ´×Ô¼ºÍ¨¹ýѧϰ¸ãÃ÷°×ÁË Ò²ÒªÀ´ºÍ´ó¼Ò·ÖÏíÒ»ÏÂѽ ÔõôÄÜÖ»Îʲ»·ÖÏíÄØ ¶Ô²»¶Ô ÂÛ̳¾ÍÊÇÒ»¸ö´ó¼Ò»¥°ï»¥Öú¹²Ïí֪ʶµÄµØ·½

2
¼´±ãij¸öÈË˵´íÁË»° ÄãÒ²²»ÄÜ˵´ó¼Ò¶¼ÊÇÖí°É ºÇºÇ

ÒýÓÃ
ÄãÃǶ¼ÊÇһȺÖí£¬ÊÇӦΪoracle10Êǹؼü×Ö£¬ËùÒÔĬÈϵİÑoracle10±äΪoracle10gÁË¡£²»ÖªµÀ²»ÒªÂÒ·¢ÎÞÓõÄÌù¡£




Ïà¹ØÎÊ´ð£º

PHP Á¬½ÓOracle ³ö´í

<?php
  getenv("ORACLE_HOME");
  $conn=ocilogon("test","test","test_db");
  if($conn)  
  echo success;  
&nb ......

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´æ´¢¹ý³ÌµÄÎÊÌ⣬Çë´óÏÀ°ïæ

ÎÒÐèÒªÓö¨Ê±Ö´Ðд洢¹ý³Ì£¬µ«ÊÇÎҵĴ洢¹ý³ÌÀïÓõ½µÄ±íÊÇÓÐÁ´½ÓµÄ£¬¾ÍÏñÕâÑù£º
.....from table_name@cxdb_link
Ò²¾ÍÊÇÎÒ½¨Á¢¶¨Ê±Æ÷µÄÊý¾Ý¿âÓë±íËùÔÚµÄÊý¾Ý¿â²»ÊÇÒ»¸ö¿â£¬£¨ÒòΪ±íËùÔÚµÄÊý¾Ý¿âÎÒûÓÐȨÏÞ½¨Á¢¶¨Ê ......

oracleÊý¾Ý¿â »º³å³Ø - Oracle / »ù´¡ºÍ¹ÜÀí

ÇëÎÊÕâ¸ö»º³å³ØÊÇÔõô»ØÊ°¡£¿¿ÉÒÔÁ¬½Ó»º³å³ØÀûÓÃÆäÖеÄÊý¾Ý°É£¿ÔõôÓã¿
Õâ¸öÊÇoracle×Ô¶¯×öµÄ£¬Ò»°ãÓ¦ÓóÌÐòÊDzÙ×÷²»Á˵ġ£

²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿

ÒýÓÃ
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
²»ÄÜ

ÄÇ»º³å³ØÀïµÄÊý¾ÝÒ²²»Äܲéѯ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ