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

oracle´æÈ¡Ð¡ÓÚ1µÄСÊý£¬ÎªÊ²Ã´ÊÇûÓÐÁã

ÔÚ´æÈ¡Ð¡Êý£¬ÀýÈç0.5µÄʱºò£¬ÎªÊ²Ã´´æÈ¡µ½Êý¾Ý¿âÖбä³É  .5  µÄÐÎʽ£¿
½â¾ö·½°¸ÒѾ­ÓÐÁË£¬ÎÒÖ÷Òª¹ØÐĵÄÊÇoracleΪʲô»áÕâô´æ´¢£¿

ÄãËù¿´µ½µÄÊÇ´æ´¢µÄÊý¾ÝµÄÏÔʾ·½Ê½£¬Ö»ÊÇÒ»¸ö±íÏ󣬲¢²»Ó°ÏìÊý¾ÝÔÚÊý¾Ý¿âÖеĴ洢
ÄãÊÇÓô洢¹ý³ÌoutputÊý¾Ý°É£¿ÓÃto_char¼´¿ÉÏÔʾΪÄãÏëÒªµÄ·½Ê½

²»ºÃÒâ˼£¬¸Õ²ÅÃèÊö´íÎó£¬ÊÇͨ¹ý³ÌÐò´ÓÊý¾Ý¿â¶ÁÈ¡ÕâÀàÊýÖµ»á³öÏÖÄÇÖÖÇé¿ö£¬ÇëÎÊÔÚÊý¾Ý¿âÖÐÒ²Êǰ´ÕÕÕâÖÖ.*¸ñʽ´æ´¢µÄô£¿

..Òª»Ø´ðµÄ»°Ö»ÄÜ˵£¬ÊÇÒÔ2½øÖÆ´¢´æµÄ
ÒÔnumberÀàÐÍ´¢´æµÄ
²»ÊÇÄãÃèÊö´íÎó£¬ÊÇÄãûÃ÷°×£¬ÊÇ0.5»¹ÊÇ.5Ö»ÊÇÏÔʾµÄÎÊÌ⣬²»ÊÇ´æ´¢µÄÎÊÌâ
Ò»°ãÔÚsqlplusºÍÆäËûµÚÈý·½¹¤¾ßÔËÐÐsqlÓï¾äʱ£¬Ä¬ÈÏÏÔʾµÄÊÇ0.5£¬´æ´¢¹ý³ÌµÄÊä³öÀÏÔʾ.5

˵µÄÌ«ºÃÁË

ÍêÈ«ÕýÈ·£¡

¶¥
ÒýÓÃ
..Òª»Ø´ðµÄ»°Ö»ÄÜ˵£¬ÊÇÒÔ2½øÖÆ´¢´æµÄ
ÒÔnumberÀàÐÍ´¢´æµÄ
²»ÊÇÄãÃèÊö´íÎó£¬ÊÇÄãûÃ÷°×£¬ÊÇ0.5»¹ÊÇ.5Ö»ÊÇÏÔʾµÄÎÊÌ⣬²»ÊÇ´æ´¢µÄÎÊÌâ
Ò»°ãÔÚsqlplusºÍÆäËûµÚÈý·½¹¤¾ßÔËÐÐsqlÓï¾äʱ£¬Ä¬ÈÏÏÔʾµÄÊÇ0.5£¬´æ´¢¹ý³ÌµÄÊä³öÀÏÔʾ.5


ÒýÓÃ
..Òª»Ø´ðµÄ»°Ö»ÄÜ˵£¬ÊÇÒÔ2½øÖÆ´¢´æµÄ
ÒÔnumberÀàÐÍ´¢´æµÄ
²»ÊÇÄãÃèÊö´íÎó£¬ÊÇÄãûÃ÷°×£¬ÊÇ0.5»¹ÊÇ.5Ö»ÊÇÏÔʾµÄÎÊÌ⣬²»ÊÇ´æ´¢µÄÎÊÌâ
Ò»°ãÔÚsqlplusºÍÆäËûµÚÈý·½¹¤¾ßÔËÐÐsqlÓï¾äʱ£¬Ä¬ÈÏÏÔʾµÄÊÇ0.5£¬´æ´¢¹ý³ÌµÄÊä³öÀÏÔʾ.5



ΪʲôÎÒµÄsqlplusÖÐÒ²ÏÔʾ.5£¬²»ÏÔʾ0.5  £¿£¿£¿

ÎÒÊÇÔÚPL/SQL DeveloperÖв鿴Êý¾Ý£¬ÏÔʾÊÇ0.5£¬Ö»ÊÇÓóÌÐò¶ÁÈ¡ÒÔºó£¬ÏÔʾµÄÊÇ.5

³ÌÐò¶ÁÈ¡µÄʱºò,ÔÚSQLÖÐÔö¼Ó,Èç:


Ïà¹ØÎÊ´ð£º

vb Á¬½ÓORACLE ´òÓ¡

ÕâÊÇÎÒÔ­À´Á¬½ÓSQLµÄ´òÓ¡µÄ´úÂë
Connection1.Open "Provider=MSDataShape.1;Persist Security Info=True;Data Source=mm;User ID=sa;Password=sa;Initial Catalog=lc-liuh2;Data Provider=SQLOLEDB.1"Ê ......

VBÁ¬½ÓORACLEµÄÎÊÌâ

VBÓÐûÓÐÀàËÆÏñJDBCµÄ·½·¨»òÕßÊÇÖмä¼þÁ¬½ÓORACLEÊý¾Ý¿â£¬ÍøÉϵĸ÷ÖÖÀý×Ó¶¼ÐèÒª°²×°¿Í»§¶Ë£¬»òÕßÊÇÅäÊý¾ÝÔ´¡£
ûÓÐÆäËû·½·¨£¬Äã±ØÐëÒª°²×°Çý¶¯µÄ

ORACLEÊý¾Ý¿âÊÇ»ùÓÚ°²È«ÐԵĿ¼ÂÇ,¿Í»§¶Ë¶¼ÐèÒª°²×°,ºÃÏóûÓбðµÄ ......

ÈçºÎ½«oracle±íת»»³ÉAccessÎı¾Îļþ

ÈçºÎ½«oracle±íת»»³ÉAccess±í»òÎı¾Îļþ
´ó¸ç¼±°¡¡£¡£
¿´ÄãÓÃʲô¹¤¾ß¡£ÓÃtoadÖ®ÀàµÄµ¼³ö¿ÉÒÔÑ¡Ôñµ¼³ö¸ñʽ¡£
ÓÃsqlplus¿ÉÒÔspool

·½·¨ºÜ¶à.
¿ÉÒÔÓÃpl/sql developer°Ñ±í±£´æÎªexcel,ÔÙ°Ñexcelµ¼Èëµ½ac ......

--oracle ´¥·¢Æ÷£¬×ª sqlserver ÎÊÌâ

--oracle ´¥·¢Æ÷£¬×ª sqlserver ÎÊÌâ
CREATE OR REPLACE TRIGGER TG_BU_TSTK_IMPORTITEM
BEFORE UPDATE ON TSTK_IMPORTITEM
FOR EACH ROW
DECLARE
VAR_LIBGOODCOUNT NUMERIC(12,2);
BEGIN ......

ÇóÖúORACLEÅúÁ¿Çå³ý±íÊý¾ÝµÄÎÊÌâ - Oracle / ¿ª·¢

±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í
ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼
ÄÄλ¸ßÈ˰ïÖúϰ¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ²
SQL code:
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ