ÈçÌ⣬ע²á³É¹¦Á¢Âí½áÌù£¬Ð»Ð»ÁË
QQ:274734792
²»ºÃÒâ˼£¬ÏÖÔÚÔÚ¹«Ë¾ÄÚÍø£¬²»ÄÜÉÏÓÊÏ䣬ËùÒÔ....
Äܲ»Äܰïæ»ñµÃ£¬Ð»Ð»£¡
Ö°Òµ£ºÏµÍ³¿ª·¢¹¤³Ìʦ
ÓÃ;£ºÑ§Ï°oracle data warehouse
¿´·¨£ºoralce ÂÛ̳¹»×¨Òµ¹»È¨Íþ
ÎÒÒ²ÊÇ´ÓÄǸöÓÊÏäÉêÇëµÄ£¬ÎÒ²»ÊǹÜÀíÔ±¡£ Â¥Ö÷ÓпÕÔÚ·¢Óʼþ°É..
3kx£¬Â¥ÉϵÄÐÖµÜ ......
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(),¶ø ......
ÏÖÔÚÊг¡ÉÏÖ÷ÒªÊÇOracle¡¢db2¡¢mysql¡¢sql severµÄÌìÏ£¬oracleÒ»Ö±ÊÇÍõÕßµØÎ»£¬Õ¼¾Ý³¬¹ý50%ÒÔÉϵķݶdb2ºóÆðÖ®Ð㣬¶øÇÒÊÇibmµÄ²úÆ·£¬²»»á±Èoracle²îµ½ÄÄÈ¥£¬Ç±Á¦ºÜ´ó£¬mysqlÒòΪÊÇÃâ·ÑµÄ£¬´ó²¿·Ö¹úÄÚÍøÕ¾£¬Ð¡¹«Ë¾É¶µÄ¶¼ÓÃmysql£¬µ«¶ÔÓÚÒ»¸öÓÐÖ¾ÓÚÔÚÊý¾Ý¿â¿ª·¢Ó¦Ó÷½Ãæ·¢Õ¹µÄÈËÀ´Ëµ£¬mysqlÏÔȻ̫С¶ù¿Æ£¡ Sql sever£¬Î¢È ......
±í TB_DAGL_LOCATINDEX ½á¹¹
´æ·ÅλÖã¨store_location£© ʹÓó¤¶È £¨SHELVING_LEN£©CM Ö÷¼üid£¨ÎÞÒâÒ壩
5B-029-001 20 &nb ......
¸Õ¸ÕÔÚ linuxÉÏ ×°ÁË oracle 10gR2£¬¸Õ¸Õ´´½¨Íê Êý¾Ý¿âµÄʱºò £¬ÊÇ¿ÉÒÔͨ¹ý em·ÃÎÊ Êý¾Ý¿âµÄ
ÖØÆôÁË µçÄÔÖ®ºó £¬ÎÒÊÖ¹¤ Æô¶¯ÁËoracle,agent,listen£¬µ«»¹ÊÇ Á¬²»ÉÏ £¬ÎÒ¹À¼ÆÊÇ ÓÐʲô ·þÎñ ûÆô¶¯£¬ÄÄλ Ö¸µã һϰ¡
OracleDBConsole·þÎñûÆô£¿
ͬÉÏ
ÎÒ×Ô¼ºÕÒµ½ÔÒòÁË£¬¾ÍÏñÉÏÃæÁ½Î»ËµµÄ
¿´¿´windowµÄ·þÎñÁÐ ......
ÈçºÎʹÓÃ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.
......