Oracle ±ÊÊÔÃæÊÔÌâ
¸÷λ´óϺºÃ£¬ËÓÐÍùÄêOracle ·½ÃæµÄ±ÊÊÔÃæÊÔÑùÌâ »òÕßÊDzμӹ¤×÷µÄ´ó¸ç´ó½ã£¬¸øÐ¡µÜЩ½¨Ò飬ÔÚOracle±ÊÊÔÃæÊÔ¹ý³ÌÖо³£±»Îʵ½µÄÎÊÌâ£¬ÖØµãÖ®ÀàµÄ֪ʶµã£¬Ð»Ð»ÁË£¬ÓÐÑùÌâµÄ·¢ÓÊÏäÖÁminjun0901@sina.com (google ÉÏËѵ½Ò»Ð©£¬Ò»ÊäÈëOracle±ÊÊÔÃæÊÔ¾ÍÄÜËѵ½µÄ¾ÍÃâÁ˹þ)лл´ó¼ÒÁË
ÂÛ̳ÓÐÊÕ¼¯µÄºÏ¼¯£¬ËÑË÷¡£
°åµÊÊÇÎÒµÄ
oracleÃæÊÔ×îÖ÷ÒªµÄÒªÀí½âoracleµÄÌåϵ½á¹¹£¬ÒÔ¼°¸÷¸ö²¿·ÖµÄ×÷Óú͹¹³É¡£
×îºÃÊÇÀí½âÒ»ÏÂ
µ±Ò»ÌõsqlÓï¾äÖ´ÐеÄʱºò£¬ËûµÄÕû¸öÖ´Ðйý³ÌÊÇÔõÑùµÄ¡£ÕâÑùÄã¾Í ºÜÇ¿ÁË£¡£¡
»¹ÓоÍÊÇoracleµÄģʽ¶ÔÏóµÄ´´½¨¡¢×÷Óá¢ÈçºÎʹÓÃÒÔ¼°ÔõÑùά»¤µÈ¡£
Ïà¹ØÎÊ´ð£º
ÎÒ°²×°Ò»Ì¨redhat linux5+oracle 10gµÄ·þÎñÆ÷£¬±Ê¼Ç±¾£¨XPϵͳ£©°²×°ÁËoracle 10g¿Í»§¶Ë,½á¹ûÀÏÊdzö12560µÄ´íÎó£¬Çë¸ßÊÖÖ¸µãÒ»¶þ£¬
-A RH-Firewall-1-INPUT -m state –state NEW -m tcp -p tcp –dpor ......
with adod_dict do
begin
close;
commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......
ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿
¸½Í¼Æ¬ ......
sqlplusÁ¬½ÓOracleÊý¾Ý¿âµÄÕû¸öÁ÷³Ì£¬
ÀýÈç sqlplus /nolog
conn system/oracle£¨ÃÜÂ룩
Õâ¸öÁ¬½Ó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 ......