±¾ÈËϵͳWIN7
Ìý˵ ¿ÉÒÔ×°Oracle10.2.1 ºÍ11
²»ÄÜ×°Oracle9i
Çó¸öÏÂÔØËÙ¶È¿ìµãµÄOracle10.2.1ºÍ11 µÄÁ´½Ó
ллÁË £¨Ö±½ÓÒªÁ¬½Ó£©
sf ²»Áô ºÇºÇ
ÎÒÓÐ10.2µÄ°²×°³ÌÐò£¬ÒªµÄ»°¸øÄã·¢¹ýÈ¥
ºÜ´óµÄ°É
Õâ¸öÎÒÕÒµ½¹ý ËٶȺÃÏñºÜÂýŶ
9i WIN7×°²»ÁË¡£¡£¡£´óÎÚ¹ê
1.11G£¬Ñ¹ËõǰµÄ
¹ÙÍøÏºÃÁË£¬ËÙ¶È»¹³É
¡£¡£Ñ¹ËõºóÄØ¡£¡£¡£
ÄѵÀÓÃQ´«£¿
ÎÒÔõôÊÇûËÙ¶È~
ѹËõºó1.04g
Âò¸öÅÌ×°°É
°²×°ÎļþÌ«´óÁË
ÎÒÓиö10gµÄ£¬Ñ¹Ëõºó620 MB
¶¥~~~~~~~ÎÒÓÐ10g
ÏÂÔØvista°æµÄ10.2g»òÕß11g
Ïà¹ØÎÊ´ð£º
ÈÕǰÓÃociº¯Êý²éѯoracleÊý¾Ýʱ³öÏÖ¸öÎÊÌ⣬¾ÍÊÇÔÚ²éѯµ½dateÀàÐ͵ÄÊý¾Ýʱ£¬Ê¹ÓÃpl/sql ²éѯoracle¿âÖеÄÊý¾ÝÏÔʾÊÇ
2009-9-29 12:12:12
µ«ÊÇͨ¹ýÓï¾äselect * from tablename ²éѯ£¬Ê¹ÓÃoci_fetch_array£¨£© ......
<?php
getenv("ORACLE_HOME");
$conn=ocilogon("test","test","test_db");
if($conn)
echo success;
&nb ......
1.OracleÖÐÃèÊöµÄ¿Í»§¶ËÓ¦Óõ½µ×Ö¸µÄʲô?
2.OracleתÂëʱ,Èç¹û¿Í»§¶ËΪ×Ó¼¯(UASCII)·þÎñ¶ËΪ³¬¼¯(AL32UTF8).
ÄÇÑϸñµÄ½²ÊÇ×Ó¼¯×ª³¬¼¯, ¿ÉÒÔתµÄͨ.
²éѯµÄʱºò³¬¼¯×ª×Ó¼¯ÄDz»¾Í³öÎÊÌâÁËô?
Äĸö»Ø¸öÌ ......
Ò»¶Ô¶à¹ØÏµ²éѯ
±í:
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 µÄ Ô¼ÊøÊÇÊÇ·ñ¿ÉÒÔ¸´Óã¿£¨µ÷ÓÃÔ¼ÊøÃû³Æ¾Í¿ÉÒÔÖ±½ÓʹÓøÃÔ¼Êø£©ÔÚÄÄÀï¿ÉÒÔ¹ÜÀíÔ¼Êø¡£
plsqlÓÐÕâ¸ö¹¦ÄÜô£¿
SQL code:
Ö±½ÓÓÃPL/SQL DEVELOPER µã»÷TABLES ÖÐcheck constraints
ÒýÓÃ
SQL ......