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

Oracle ±ÊÊÔÃæÊÔÌâ

¸÷λ´óϺºÃ£¬Ë­ÓÐÍùÄêOracle ·½ÃæµÄ±ÊÊÔÃæÊÔÑùÌâ »òÕßÊDzμӹ¤×÷µÄ´ó¸ç´ó½ã£¬¸øÐ¡µÜЩ½¨Ò飬ÔÚOracle±ÊÊÔÃæÊÔ¹ý³ÌÖо­³£±»Îʵ½µÄÎÊÌâ£¬ÖØµãÖ®ÀàµÄ֪ʶµã£¬Ð»Ð»ÁË£¬ÓÐÑùÌâµÄ·¢ÓÊÏäÖÁminjun0901@sina.com  (google ÉÏËѵ½Ò»Ð©£¬Ò»ÊäÈëOracle±ÊÊÔÃæÊÔ¾ÍÄÜËѵ½µÄ¾ÍÃâÁ˹þ)лл´ó¼ÒÁË
ÂÛ̳ÓÐÊÕ¼¯µÄºÏ¼¯£¬ËÑË÷¡£

°åµÊÊÇÎÒµÄ

oracleÃæÊÔ×îÖ÷ÒªµÄÒªÀí½âoracleµÄÌåϵ½á¹¹£¬ÒÔ¼°¸÷¸ö²¿·ÖµÄ×÷Óú͹¹³É¡£
×îºÃÊÇÀí½âÒ»ÏÂ
µ±Ò»ÌõsqlÓï¾äÖ´ÐеÄʱºò£¬ËûµÄÕû¸öÖ´Ðйý³ÌÊÇÔõÑùµÄ¡£ÕâÑùÄã¾Í ºÜÇ¿ÁË£¡£¡
»¹ÓоÍÊÇoracleµÄģʽ¶ÔÏóµÄ´´½¨¡¢×÷Óá¢ÈçºÎʹÓÃÒÔ¼°ÔõÑùά»¤µÈ¡£



Ïà¹ØÎÊ´ð£º

linux + oracleÓÃXP·ÃÎʲ»ÁË

ÎÒ°²×°Ò»Ì¨redhat linux5+oracle 10gµÄ·þÎñÆ÷£¬±Ê¼Ç±¾£¨XPϵͳ£©°²×°ÁËoracle 10g¿Í»§¶Ë,½á¹ûÀÏÊdzö12560µÄ´íÎó£¬Çë¸ßÊÖÖ¸µãÒ»¶þ£¬

-A RH-Firewall-1-INPUT -m state –state NEW -m tcp -p tcp –dpor ......

ORACLEÊý¾Ý¿âÖÐµÄ group by Óï¾ä£¿

  with adod_dict do
    begin
    close;
    commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......

¹òÇó lomboz eclipse ÖмÓÈëoracleµÄÎÊÌâ

ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿
¸½Í¼Æ¬ ......

sqlplusÁ¬½ÓoracleÊý¾Ý¿âÔ­Àí£¿

sqlplusÁ¬½ÓOracleÊý¾Ý¿âµÄÕû¸öÁ÷³Ì£¬
ÀýÈç sqlplus /nolog
    conn system/oracle£¨ÃÜÂ룩

Õâ¸öÁ¬½ÓOracleµÄÕû¸ö»úÖÆÊÇʲô£¨×¢ÖØÓÚÁ¬½ÓµÄÔ­ÀíÉÏ£©

Èç¹ûÓÐË­¶®»òÓÐÏà¹ØÄÚÈݸøÓèÌáÊ ......

ÊÇoracleµÄbugô£¿É¢·ÖÁË£¡ - Oracle / »ù´¡ºÍ¹ÜÀí

±¾À´ÒªÐ´¸öupdateÓï¾ä
update table_a A
  set A.flag=1
  where A.id in (select B.id from table_b B)
½á¹ûÎóд³É
update table_a A
  set A.flag=1
  where ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ