Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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ÂÛ̳µÄÑûÇëÂë

ÈçÌ⣬ע²á³É¹¦Á¢Âí½áÌù£¬Ð»Ð»ÁË
QQ:274734792

²»ºÃÒâ˼£¬ÏÖÔÚÔÚ¹«Ë¾ÄÚÍø£¬²»ÄÜÉÏÓÊÏ䣬ËùÒÔ....
Äܲ»Äܰïæ»ñµÃ£¬Ð»Ð»£¡
Ö°Òµ£ºÏµÍ³¿ª·¢¹¤³Ìʦ
ÓÃ;£ºÑ§Ï°oracle data warehouse
¿´·¨£ºoralce ÂÛ̳¹»×¨Òµ¹»È¨Íþ


ÎÒÒ²ÊÇ´ÓÄǸöÓÊÏäÉêÇëµÄ£¬ÎÒ²»ÊǹÜÀíÔ±¡£ Â¥Ö÷ÓпÕÔÚ·¢Óʼþ°É..

3kx£¬Â¥ÉϵÄÐÖµÜ ......

oracle ÐÔÄܱȽÏ,Ë­¿ìË­Âý?

1.
select count(t1.id)
from table1 t1
where t1.id = (select t2.id from table2 t2 where t2......);

2.
select count(t1.id)
from table1 t1,table2 t2
where t1.id = t2.id
and t2......;

ÎÊÏÂ,Õâ2ÖÐд·¨¶¼¿ÉÒÔ´ïµ½»ã×ܱí1µÄÄ¿µÄ°É?
ÄÇÓÐÐÔÄÜÉϵÄÇø±ðÂð?
Èç¹û²»ÊÇcount(),¶ø ......

[Ô­´´]db2 pk oracle£¬»¶Ó­ÅÄש£¡

ÏÖÔÚÊг¡ÉÏÖ÷ÒªÊÇOracle¡¢db2¡¢mysql¡¢sql severµÄÌìÏ£¬oracleÒ»Ö±ÊÇÍõÕßµØÎ»£¬Õ¼¾Ý³¬¹ý50%ÒÔÉϵķݶdb2ºóÆðÖ®Ð㣬¶øÇÒÊÇibmµÄ²úÆ·£¬²»»á±Èoracle²îµ½ÄÄÈ¥£¬Ç±Á¦ºÜ´ó£¬mysqlÒòΪÊÇÃâ·ÑµÄ£¬´ó²¿·Ö¹úÄÚÍøÕ¾£¬Ð¡¹«Ë¾É¶µÄ¶¼ÓÃmysql£¬µ«¶ÔÓÚÒ»¸öÓÐÖ¾ÓÚÔÚÊý¾Ý¿â¿ª·¢Ó¦Ó÷½Ãæ·¢Õ¹µÄÈËÀ´Ëµ£¬mysqlÏÔȻ̫С¶ù¿Æ£¡ Sql sever£¬Î¢È ......

oracleÖÐupdate´¥·¢Æ÷

±í TB_DAGL_LOCATINDEX  ½á¹¹
´æ·ÅλÖã¨store_location£©      ʹÓó¤¶È £¨SHELVING_LEN£©CM      Ö÷¼üid£¨ÎÞÒâÒ壩
5B-029-001                                20      &nb ......

oracle em ÎÞ·¨Á¬ÉÏ

¸Õ¸ÕÔÚ linuxÉÏ ×°ÁË oracle 10gR2£¬¸Õ¸Õ´´½¨Íê Êý¾Ý¿âµÄʱºò £¬ÊÇ¿ÉÒÔͨ¹ý em·ÃÎÊ Êý¾Ý¿âµÄ
ÖØÆôÁË µçÄÔÖ®ºó £¬ÎÒÊÖ¹¤ Æô¶¯ÁËoracle,agent,listen£¬µ«»¹ÊÇ Á¬²»ÉÏ £¬ÎÒ¹À¼ÆÊÇ ÓÐʲô ·þÎñ ûÆô¶¯£¬ÄÄλ Ö¸µã һϰ¡
OracleDBConsole·þÎñûÆô£¿

ͬÉÏ

ÎÒ×Ô¼ºÕÒµ½Ô­ÒòÁË£¬¾ÍÏñÉÏÃæÁ½Î»ËµµÄ

¿´¿´windowµÄ·þÎñÁÐ ......

ÈçºÎʹÓÃOracle sqlplus help

ÈçºÎʹÓÃOracle sqlplus help
ÔõôûÈ˻ظ´ÄØ

²»»á°¡
ûÓùý°ïÖú

ÓÃÕâÑùµÄÃüÁî
?

? index

±ÈÈç

SQL> ? show;

SHOW
----

Shows the value of a SQL*Plus system variable, or the current
SQL*Plus environment. SHOW SGA requires a DBA privileged login. ......
×ܼǼÊý:1827; ×ÜÒ³Êý:305; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [252] [253] [254] [255] 256 [257] [258] [259] [260] [261]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ