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

Toad for oracleµÄʹÓÃÎÊÌâ

ÎÒÓÃÕâ¸ö¹¤¾ß,
´´½¨ÁËÒ»¸ö±í
Ìí¼ÓÁËÒ»Ìõ¼Ç¼
È»ºó²éѯȴ²éѯ²»µ½;
¶øÇÒÈ¥Êý¾Ý¿âÖвéÕÒÒ²ÕÒ²»µ½Õâ¸ö±í;
ÒÔΪδ´´½¨³É¹¦.
ÖØÐ´´½¨±íÈ´ÌáʾÃû³ÆÒÑ´æÔÚ.
Çë½Ì¸÷λ´óÏÀ.Õâ¸öÊÇÔõô»ØÊ°¡
СµÜ³õ´ÎʹÓô˹¤¾ß;
Ìí¼ÓÍêºócommitÁËÂð

commitÁË
¾ÍËã²»commit.µ±Ç°Óû§ÏÂÓ¦¸ÃÒ²ÄÜ¿´µ½°É
ÎÒÓÃsqlplus¾Í¿ÉÒÔ°¡

ÊÇ·ñ´´½¨ÔÚ±ðµÄÓû§ÏÂÁË

select * from user_tables where table_name='TABLENAME';
¿´¿´Äܲ»ÄÜÕÒµ½.


Ïà¹ØÎÊ´ð£º

oracle sql developer ²éѯÏÔʾÖÐÎÄÂÒÂë

»·¾³£º1.win2003server+oracle9i
2.oracle9i×Ö·û¼¯ÎªAMERICAN_AMERICA.WE8ISO8859P1
3.oracle sql developer°æ±¾ 1.5.5
ÏÖÏóÃèÊö: 1.ÔÚsql developer ÖвéѯoracleÖеÄij¸ö±í£¬ÖÐÎÄÈ«²¿ÏÔʾΪÂÒÂë¡£ ......

delphi Ôõô½«oracleµÄlong raw ×Ö¶ÎÖµ µ¼Èëblob×Ö¶Î

delphi Ôõô½«oracleµÄlong raw ×Ö¶ÎÖµ µ¼Èëblob×Ö¶Î

http://blog.csdn.net/zxf_feng/archive/2008/12/21/3571961.aspx
¿´¿´Õâ¸ö

ÒýÓÃ
            vStream := TMemorySt ......

ÖªµÀÔõô°Ñsasµ¼ÈëoracleµÄ½øÀ´¿´¿´

ÎÒÏÖÔÚÓÐһЩsasÉÏÃæµÄÊý¾ÝÎļþ ÏÖÔÚÎÒÐèÒª°Ñsasµ¼Èëµ½oracle
ÏÖÔÚ°ÑÒ»¸ösasÎļþµ¼Èëµ½Ò»¸öoracleÖеÄÒ»¸ö±íÖÐÎÒÒѾ­ÖªµÀÔõôŪÁË
µ«ÊÇ ÎÒÏÖÔÚÐèÒª°ÑsasÖеÄÁíÒ»¸öÎļþ×·¼Óµ½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ºÅ