ÔÚ´æÈ¡Ð¡Êý£¬ÀýÈç0.5µÄʱºò£¬ÎªÊ²Ã´´æÈ¡µ½Êý¾Ý¿âÖбä³É .5 µÄÐÎʽ£¿
½â¾ö·½°¸ÒѾÓÐÁË£¬ÎÒÖ÷Òª¹ØÐĵÄÊÇoracleΪʲô»áÕâô´æ´¢£¿
ÄãËù¿´µ½µÄÊÇ´æ´¢µÄÊý¾ÝµÄÏÔʾ·½Ê½£¬Ö»ÊÇÒ»¸ö±íÏ󣬲¢²»Ó°ÏìÊý¾ÝÔÚÊý¾Ý¿âÖеĴ洢
ÄãÊÇÓô洢¹ý³ÌoutputÊý¾Ý°É£¿ÓÃto_char¼´¿ÉÏÔʾΪÄãÏëÒªµÄ·½Ê½
²»ºÃÒâ˼£¬¸Õ²ÅÃèÊö´íÎó£¬ÊÇͨ¹ý³ÌÐò´ÓÊý¾Ý¿â¶ÁÈ¡ÕâÀàÊýÖµ»á³öÏÖÄÇÖÖÇé¿ö£¬ÇëÎÊÔÚÊý¾Ý¿âÖÐÒ²Êǰ´ÕÕÕâÖÖ.*¸ñʽ´æ´¢µÄô£¿
..Òª»Ø´ðµÄ»°Ö»ÄÜ˵£¬ÊÇÒÔ2½øÖÆ´¢´æµÄ
ÒÔnumberÀàÐÍ´¢´æµÄ
²»ÊÇÄãÃèÊö´íÎó£¬ÊÇÄãûÃ÷°×£¬ÊÇ0.5»¹ÊÇ.5Ö»ÊÇÏÔʾµÄÎÊÌ⣬²»ÊÇ´æ´¢µÄÎÊÌâ
Ò»°ãÔÚsqlplusºÍÆäËûµÚÈý·½¹¤¾ßÔËÐÐsqlÓï¾äʱ£¬Ä¬ÈÏÏÔʾµÄÊÇ0.5£¬´æ´¢¹ý³ÌµÄÊä³öÀÏÔʾ.5
˵µÄÌ«ºÃÁË
ÍêÈ«ÕýÈ·£¡
¶¥
ΪʲôÎÒµÄsqlplusÖÐÒ²ÏÔʾ.5£¬²»ÏÔʾ0.5 £¿£¿£¿
ÎÒÊÇÔÚPL/SQL DeveloperÖв鿴Êý¾Ý£¬ÏÔʾÊÇ0.5£¬Ö»ÊÇÓóÌÐò¶ÁÈ¡ÒÔºó£¬ÏÔʾµÄÊÇ.5
³ÌÐò¶ÁÈ¡µÄʱºò,ÔÚSQLÖÐÔö¼Ó,Èç:
Ïà¹ØÎÊ´ð£º
»·¾³£º1.win2003server+oracle9i
2.oracle9i×Ö·û¼¯ÎªAMERICAN_AMERICA.WE8ISO8859P1
3.oracle sql developer°æ±¾ 1.5.5
ÏÖÏóÃèÊö: 1.ÔÚsql developer ÖвéѯoracleÖеÄij¸ö±í£¬ÖÐÎÄÈ«²¿ÏÔʾΪÂÒÂë¡£
......
Oracle £ºselect grbh from com.eway.vo.Zjxx zj where to_char(zj.jbsj,'yyyymm')='"+ sj + "'
ÆäÖÐ sjÊÇ×Ö·û´®²ÎÊý ÏÖÔÚÏë°ÑÉÏÃæµÄSQLÓï¾äת»»ÎªMysqlµÄ Ö÷ÒªÊÇʱ¼ä´«Èë ......
ÕâÊÇÎÒÔÀ´Á¬½Ó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"Ê ......
ÊÖÍ·ÓÐÒ»¸öÀϵIJúÆ·£¬delphi 6Á¬½Óoracle,È¡sys.aud$ϵͳ±íÀïÃæµÄÊý¾Ý
ÓÃAdoconnection+adodataset,
ÓÃsystemÓû§£¬Adoconnection Á¬½Ó³É¹¦£¬µ«Èç¹ûÔÚadodatasetÀïÃæÐ´:
SELECT * from SYS.AUD ......
Oracle´æ´¢¹ý³ÌÈçÏÂ,ÓÃÓαêÊä³ö½á¹û:
procedure proc_xcxf_detail(v_sbh varchar2,
v_szpq varchar2,
&nbs ......