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

oracle for update

³ÌÐò½áÊøÊ±£¬Ã»ÓÐÌá½»»ò»Ø¹öÊÂÎñ£¬Ó¦ÓÃfor updateµÄÊý¾ÝÊÇ·ñ»á±»½âËø£¿
for updateºÎʱ½âËø£¿
ÊÂÎñ½áÊøºó½âËø

»òÕ߻Ự½áÊø£¬ÊÂÎñ×Ô¶¯½áÊø

³ÌÐò½áÊøÊ±£¬Ö»ÒªÁ¬½ÓÖжϣ¬Ôò»á»°×Ô¶¯½áÊø
Èç¹ûûÓÐÌá½»£¬×Ô¶¯»Ø¹ö

ÒýÓÃ
³ÌÐò½áÊøÊ±£¬Ã»ÓÐÌá½»»ò»Ø¹öÊÂÎñ£¬Ó¦ÓÃfor updateµÄÊý¾ÝÊÇ·ñ»á±»½âËø£¿
for updateºÎʱ½âËø£¿


»áµÄ£¬Ó¦ÓóÌÐò½áÊøµÄʱºò£¬session¹Ø±Õ£¬¿Í»§¶ËÓëoracle·þÎñÁ¬½ÓÖжϣ¬ÕâÑùµÄ»°£¬ÊÂÎñ»á×Ô¶¯»Ø¹ö£¡

ÒýÓÃ
³ÌÐò½áÊøÊ±£¬Ã»ÓÐÌá½»»ò»Ø¹öÊÂÎñ£¬Ó¦ÓÃfor updateµÄÊý¾ÝÊÇ·ñ»á±»½âËø£¿
for updateºÎʱ½âËø£¿


ÊÂÎñÖÕֹʱ½âËø£¬ÊÂÎñÖÕÖ¹£¬¿ÉÒÔÊÇÏÔʾµÄcommit£¬rollback¡£ »òÕßһЩ¶¯×÷»áÒþʽµÄÖÕÖ¹ÊÂÎñ£¬±ÈÈçsession¶Ïµô£¬»áÒþʽµÄrollback£¬ Ö´ÐÐÁËddlÓï¾ä »áÒþʽµÄcommit


Ïà¹ØÎÊ´ð£º

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ÖеÄÒ»¸öÓÐÊý¾ÝµÄÒ»¸ö±íÉÏà ......

lomboz eclipse ÖмÓÈëoracleµÄÎÊÌâ

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


......

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

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

oracle ¶ÔÏóµ÷ÓóÉÔ±º¯ÊýÎÊÌâ

create or replace type Spoint as object(
x float,
y float,
member function distance(p in Spoint)
return float
);


create or replace type body Spoint as
member function dis ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ