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

ÓÐûÓÐoracleº¯ÊýµÄÖÐÎİïÖúÎĵµ£¿

rt£¬3q
Ö»ÓÐÓ¢ÎĵÄ

ÎÒÓÐÖÐÎĵ쬻ØÍ··¢Óʼþ¸øÎÒ  ÎÒ·¢¸øÄ㣬²»¹ý²»ÊÇÈ«²¿¶¼ÊÇÖÐÎĵ쬵«ÊÇ˵Ã÷»¹ÊÇÖÐÎĵģ¬ÀýÈ磺
Oracle/PLSQL: Ascii Function
·µ»ØÓëÖ¸¶¨µÄ×Ö·û¶ÔÓ¦µÄÊ®½øÖÆÊý

The syntax for the ascii function is:

ascii( single_character )

single_character is the specified character to retrieve the NUMBER code for. If more than one character is entered, the function will return the value for the first character and ignore all of the characters after the first.


Applies To:

Oracle 8i, Oracle 9i, Oracle 10g, Oracle 11g


For example:

ascii('t') would return 116.
ascii('T') would return 84.
ascii('T2') would also return 84.




°æ±¾Ô½¸ßÎĵµ¾ÍÔ½ÊÇÓ¢ÎÄ,а汾µÄÎĵµ¶¼ÊÇÓ¢ÎÄ,ÐèҪʹÓÃÒ»¶Îʱ¼äÓÐÈË·­ÒëÁ˲ųöÖÐÎÄ

oracleÖÐÎĵÄÖØÊӳ̶ÈÃ÷ÏÔ²»Èç΢Èí

ÒýÓÃ
ÎÒÓÐÖÐÎĵ쬻ØÍ··¢Óʼþ¸øÎÒ  ÎÒ·¢¸øÄ㣬²»¹ý²»ÊÇÈ«²¿¶¼ÊÇÖÐÎĵ쬵«ÊÇ˵Ã÷»¹ÊÇÖÐÎĵģ¬ÀýÈ磺
Oracle/PLSQL: Ascii Function
·µ»ØÓëÖ¸¶¨µÄ×Ö·û¶ÔÓ¦µÄÊ®½øÖÆÊý

The syntax for the ascii function is:

ascii( single_character )

single_character is the specified character to retrieve the NUMBER code for. If more than one character is entered, the function will return the value for the first character and ignore all of the character


Ïà¹ØÎÊ´ð£º

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

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

½éÉÜOracleºÍmysqlµÄÊé - Oracle / ·Ç¼¼ÊõÇø

ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......

OracleÊý¾Ý¿âÔ½À´Ô½Âý¸ÃÈçºÎ´¦Àí£¿

Êý¾Ý¿â£ºOracle10g(10.2)
Ó¦ÓãºÒ»¸öC#µÄ³ÌÐòдÊý¾Ý¿â£¬Ò»¸öJSP³ÌÐò¶ÁÊý¾Ý¿â
¸ºÔØ£ºÄ¿Ç°´¦ÓÚ¿ª·¢½×¶Î£¬»ù±¾ÉÏÖ»ÓÐ3-4¸öÓû§·ÃÎÊJSPÍøÕ¾¡£
ÏÖÏó£ºÖØÐÂÆô¶¯ºóµÄÊý¾Ý¿â²éѯ·Ç³£¿ì£¬µ«ÊÇÓÃ×ÅÓÃ×ÅÔ½À´Ô½Âý£¬ËùÓÐJSPÍøÒ ......

¹ØÓÚoracle 10gµÄEMÆô¶¯ÎÊÌâ

oracle 10g°²×°Íê±ÏºóĬÈÏ»áÒÔÍøÒ³ÐÎʽÆô¶¯EM£¬µ«Îҹرպó¾ÍûÔÚ¿ªÊ¼²Ëµ¥ÀïÕÒµ½ÏàÓ¦µÄÍøÒ³Ä£Ê½Æô¶¯EMºÍJAVA³ÌÐòÆô¶¯µÄEMÑ¡ÏÇëÎÊÕâÊÇÔõô»ØÊ£¿
emÊǸö·þÎñ£¬

°²×°ºÃÒÔºóÓ¦¸ÃÔÚÄãµÄ·þÎñÁбíÀïÕÒµ½ÀàËÆOrac ......

oracle ·¢Óʼþ´íÎó

ÏÂÃæ´æ´¢¹ý³ÌÖ´ÐкóÓдíÎó£¬
create or replace procedure test_mail(msg_subject in varchar2,
                            mes_co ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ