Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ : Oracle

ºÜ¼òµ¥µÄORACLE²éѯÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

SqlServerÖеIJéѯÓï¾äselect sid as 'ѧºÅ' from student
 µ«ÊÇÔÚORACLEÖв»ÄÜÕâôд£¬
ÇëÎÊÔÚoracleÖÐÔõô¸ø²éѯ×ֶθ³¸ö±ðÃû£¿
SQL code:
select sid "ѧºÅ" from student;

select sid "ѧºÅ" from student

select sid as 'ѧºÅ' from student
È¥µôÒýºÅ

o ÖªµÀÀ² 
Ô­À´ ......

Çó½ÌÒ»¸öoracle±à³ÌÌâ.... - Oracle / ¸ß¼¶¼¼Êõ

Óиö±íA±í,B±í,È»ºóÁ½¸ö±í¶¼Ö»ÓÐkey ºÍvalueÁ½¸ö×Ö¶Î.
È»ºóÅжÏA±íºÍB±íµÄµÄkeyÈç¹ûÏàͬµÄ»°,°ÑA±íµÄvalueÐ޸ijÉΪBµÄvalue
ÔÙÎÊÏÂcash when...then...else..endÖпÉÒÔǶÌ×¼¸¸öelse??
update a
  set value = (select value from b
  where b.key = a.key)
 where exists (select ......

Çó½ÌÒ»¸öoracle±à³ÌÌâ.... - Oracle / ¿ª·¢


±íA:
name fenshu
a 80
b 44
c 60
d 78
°´ÕÕ·ÖÊý´óÓÚ80ÓÅÐã,60-80ºÏ¸ñ,60ÒÔϲî
Ôõôת»»³ÉÏÂÁÐÑù×Ó.Ò»¾äsql
±íB  
name fenshu XX
a 80 ÓÅÐã
b 44 ²î
c 60 ºÏ¸ñ
d 78 ºÏ¸ñ

SQL code:
select name,fenshu,case w ......

ÏÂÔØoracleµÄÄĸö°æ±¾ºÏÊÊ - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÒÏëѧϰoralceµÄ»ù´¡ÖªÊ¶£¬ÏëÎʸ÷λ´óÏÀ£¬ÏÂÔØoracleµÄÄĸö°æ±¾ºÏÊÊ,ÎÒ¸öÈËÏëÏÂÔØoracle 10 express°æ£¬ÔõôÑù£¿
±ê×¼°æºÍÆóÒµ°æ¶¼ÐÐ

expressÕâ¸öÊÇʲô°æ±¾£¬ÎÒÔÚoracleÍøÕ¾ÉÏ¿´¸öexpressҪСЩ£¬ËùÒÔÎÒÏëÏÂÔØÕâ¸ö°æ±¾£¬ÔõôÑù£¿

10.2µÄÆóÒµ°æ£¬¶ÔOracleÀ´Ëµ£¬ÓÀÔ¶²»ÒªÏÂÔØexpress°æ¡£


ÏÂÔÚOracle 10g °æ±¾µÄ ......

oracleÊý¾Ý¿âÇý¶¯ÎÞ·¨¼ÓÔØ - Java / Eclipse


ÎÒÓõÄÊÇMyEclipse±àÒëÆ÷ ÓõÄÊÇwindows7ϵͳ ÒÔÇ°javaºÍOracleÊý¾Ý¿âÁ¬½ÓûÓгöÏÖ¹ý´íÎó ½ñÌì²»Öª±¨ÔõôÁ˳öÏÖÁËÏÂÃæµÄ´íÎó£º
 ÓÉÓÚϵͳ´íÎó 1114: ¶¯Ì¬Á´½Ó¿â(DLL)³õʼ»¯Àý³Ìʧ°Ü¡£ (Oracle in OraDb10g_home1, F:\programFile\oracle\product\10.2.0\db_1\BIN\SQORA32.DLL)£¬Ö¸¶¨Çý¶¯³ÌÐòÎÞ·¨¼ÓÔØ¡£
Ë­Ä ......

ÇóÒ»ÌõSQLÓï¾ä¡£¡£ - Oracle / »ù´¡ºÍ¹ÜÀí

±íÀïÓÐÒ»¸öʱ¼ä×ֶΣ¬ÀàÐÍÊÇvarchar
ÀýÈç:
  ÐòºÅ ʱ¼ä
  1 9Сʱ20·ÖÖÓ
  2 2Сʱ20·ÖÖÓ
  3 55·ÖÖÓ
ͨ¹ýÒ»ÌõSQLÓï¾ä£¬µÃµ½Ê±¼ä×ֶεÄ×Üʱ¼ä£¬¼´µÃµ½×Üʱ¼äµÄ½á¹û£º12Сʱ35·ÖÖÓ¡£
  
лл´ó¼ÒÁË¡£
 
select sum(hh),sum(substr(mi,1,ins ......
×ܼǼÊý:1827; ×ÜÒ³Êý:305; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [6] [7] [8] [9] 10 [11] [12] [13] [14] [15]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ