ÔÚ´æÈ¡Ð¡Êý£¬ÀýÈç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ÖÐÔö¼Ó,Èç:
Ïà¹ØÎÊ´ð£º
ÕâÊÇÎÒÔÀ´Á¬½Ó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ÓÐûÓÐÀàËÆÏñJDBCµÄ·½·¨»òÕßÊÇÖмä¼þÁ¬½ÓORACLEÊý¾Ý¿â£¬ÍøÉϵĸ÷ÖÖÀý×Ó¶¼ÐèÒª°²×°¿Í»§¶Ë£¬»òÕßÊÇÅäÊý¾ÝÔ´¡£ ûÓÐÆäËû·½·¨£¬Äã±ØÐëÒª°²×°Çý¶¯µÄ ORACLEÊý¾Ý¿âÊÇ»ùÓÚ°²È«ÐԵĿ¼ÂÇ,¿Í»§¶Ë¶¼ÐèÒª°²×°,ºÃÏóûÓбðµÄ ......
ÈçºÎ½«oracle±íת»»³ÉAccess±í»òÎı¾Îļþ ´ó¸ç¼±°¡¡£¡£ ¿´ÄãÓÃʲô¹¤¾ß¡£ÓÃtoadÖ®ÀàµÄµ¼³ö¿ÉÒÔÑ¡Ôñµ¼³ö¸ñʽ¡£ ÓÃsqlplus¿ÉÒÔspool ·½·¨ºÜ¶à. ¿ÉÒÔÓÃpl/sql developer°Ñ±í±£´æÎªexcel,ÔÙ°Ñexcelµ¼Èëµ½ac ......
--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
......
±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼ ÄÄλ¸ßÈ˰ïÖúϰ¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ² SQL code:
......