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

¡¾ÇóORACLE°æ±¾ÏÂÔØ¡¿

±¾ÈËϵͳWIN7
Ìý˵ ¿ÉÒÔ×°Oracle10.2.1 ºÍ11
²»ÄÜ×°Oracle9i

Çó¸öÏÂÔØËÙ¶È¿ìµãµÄOracle10.2.1ºÍ11 µÄÁ´½Ó

ллÁË £¨Ö±½ÓÒªÁ¬½Ó£©
sf ²»Áô ºÇºÇ



ÎÒÓÐ10.2µÄ°²×°³ÌÐò£¬ÒªµÄ»°¸øÄã·¢¹ýÈ¥

ÒýÓÃ
ÎÒÓÐ10.2µÄ°²×°³ÌÐò£¬ÒªµÄ»°¸øÄã·¢¹ýÈ¥

ºÜ´óµÄ°É

ÒýÓÃ
http://www.oracle.com/technology/global/cn/software/products/database/oracle10g/index.html

Õâ¸öÎÒÕÒµ½¹ý ËٶȺÃÏñºÜÂýŶ


ÒýÓÃ
oracle9iÎÒÓÐ,10gûÓÐ.

9i WIN7×°²»ÁË¡£¡£¡£´óÎÚ¹ê

ÒýÓÃ
ÒýÓà 4 Â¥ tianxiaocui2007 µÄ»Ø¸´:
ÎÒÓÐ10.2µÄ°²×°³ÌÐò£¬ÒªµÄ»°¸øÄã·¢¹ýÈ¥

ºÜ´óµÄ°É


1.11G£¬Ñ¹ËõǰµÄ

¹ÙÍøÏºÃÁË£¬ËÙ¶È»¹³É

ÒýÓÃ
ÒýÓà 5 Â¥ feixianxxx µÄ»Ø¸´:
ÒýÓà 4 Â¥ tianxiaocui2007 µÄ»Ø¸´:
ÎÒÓÐ10.2µÄ°²×°³ÌÐò£¬ÒªµÄ»°¸øÄã·¢¹ýÈ¥

ºÜ´óµÄ°É


1.11G£¬Ñ¹ËõǰµÄ

¡£¡£Ñ¹ËõºóÄØ¡£¡£¡£
ÄѵÀÓÃQ´«£¿

ÒýÓÃ
¹ÙÍøÏºÃÁË£¬ËÙ¶È»¹³É

ÎÒÔõôÊÇûËÙ¶È~

ѹËõºó1.04g

Âò¸öÅÌ×°°É
°²×°ÎļþÌ«´óÁË

ÎÒÓиö10gµÄ£¬Ñ¹Ëõºó620 MB

¶¥~~~~~~~ÎÒÓÐ10g

ÏÂÔØvista°æµÄ10.2g»òÕß11g

ÒýÓÃ


Ïà¹ØÎÊ´ð£º

php Öвéѯoracle date ÀàÐÍÊý¾ÝµÄÎÊÌâ?

ÈÕǰÓÃociº¯Êý²éѯoracleÊý¾Ýʱ³öÏÖ¸öÎÊÌ⣬¾ÍÊÇÔÚ²éѯµ½dateÀàÐ͵ÄÊý¾Ýʱ£¬Ê¹ÓÃpl/sql ²éѯoracle¿âÖеÄÊý¾ÝÏÔʾÊÇ
2009-9-29 12:12:12
µ«ÊÇͨ¹ýÓï¾äselect * from tablename ²éѯ£¬Ê¹ÓÃoci_fetch_array£¨£© ......

PHP Á¬½ÓOracle ³ö´í

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

OracleÖÐÃèÊöµÄ¿Í»§¶ËÓ¦Óõ½µ×Ö¸µÄʲô?

1.OracleÖÐÃèÊöµÄ¿Í»§¶ËÓ¦Óõ½µ×Ö¸µÄʲô?

2.OracleתÂëʱ,Èç¹û¿Í»§¶ËΪ×Ó¼¯(UASCII)·þÎñ¶ËΪ³¬¼¯(AL32UTF8).
ÄÇÑϸñµÄ½²ÊÇ×Ó¼¯×ª³¬¼¯, ¿ÉÒÔתµÄͨ.
²éѯµÄʱºò³¬¼¯×ª×Ó¼¯ÄDz»¾Í³öÎÊÌâÁËô?
Äĸö»Ø¸öÌ ......

Oracle 9i Ò»¶Ô¶àµÄ¹ØÏµ²éѯ

Ò»¶Ô¶à¹ØÏµ²éѯ

±í:
ea,eb,ga,gb
±í¹ØÏµÈçÏÂ
ea1=eb1
ga1=gb1
eb1=gb31 and eb3 = gb33


ÊÂÀýÊý¾Ý¼°¹ØÏµÈçÏÂ:
SQL code:

SELECT ea1, eb3, gb1, gb3, gb31, gb33
from (S ......

OracleµÄÔ¼ÊøÊÇ·ñ¿ÉÒÔ¸´ÓÃ

Oracle µÄ Ô¼ÊøÊÇÊÇ·ñ¿ÉÒÔ¸´Óã¿£¨µ÷ÓÃÔ¼ÊøÃû³Æ¾Í¿ÉÒÔÖ±½ÓʹÓøÃÔ¼Êø£©ÔÚÄÄÀï¿ÉÒÔ¹ÜÀíÔ¼Êø¡£
plsqlÓÐÕâ¸ö¹¦ÄÜô£¿


SQL code:
Ö±½ÓÓÃPL/SQL DEVELOPER µã»÷TABLES ÖÐcheck constraints

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