Ê×Ò³ Ê«´Ê ×Öµä °å±¨ ¾ä×Ó ÃûÑÔ ÓÑ´ð ÀøÖ¾ ѧУ ÍøÕ¾µØÍ¼
µ±Ç°Î»ÖÃ: Ê×Ò³ > ½Ì³ÌƵµÀ > Êý¾Ý¿â > ÆäËûÊý¾Ý¿â >

oracle ¹ØÓÚÄ©ÉÒ´øbºÍ²»´øbµÄº¯Êý½á¹û±È½Ï

2012-09-16 
oracle ¹ØÓÚĩβ´øbºÍ²»´øbµÄº¯Êý½á¹û±È½ÏÑ¡Ôñº¯ÊýsubstrºÍsubstrb±È½Ï²î±ðÔÚÓÚsubstr°´ÕÕ×Ö·û£¨char£©À´±È

oracle ¹ØÓÚĩβ´øbºÍ²»´øbµÄº¯Êý½á¹û±È½Ï

Ñ¡Ôñº¯ÊýsubstrºÍsubstrb±È½Ï

²î±ðÔÚÓÚsubstr°´ÕÕ×Ö·û£¨char£©À´±È½Ï£¬substrb°´ÕÕ±ÈÌØÎ»£¨byte£©À´±È½Ï¡£

?

select substr£¨'¤¢¤ê¤Þ¤»¤ó', 1, 5£© from dual;

?

SUBSTR£¨'¤¢¤ê¤Þ¤»¤ó',1,5£©
------------------------------
¤¢¤ê¤Þ¤»¤ó

?

?

select substrb('¤¢¤ê¤Þ¤»¤ó', 1, 5) from dual;

?

SUBSTRB('
----------
¤¢

?

select substrb('¤¢¤ê¤Þ¤»¤ó', 1, 6) from dual;

SUBSTRB('¤¢
------------
¤¢¤ê

?

?

ÈÕÎÄ×Ö·ûÕ¼Èý¸öbyte£¬½ØÈ¡µÄʱºò£¬substrbÊÇ´ÓµÚһλ¿ªÊ¼½ØÈ¡6¸öbyteµÄ×Ö·û¡£

substrÊÇ´ÓµÚÒ»¸ö×Ö·û¿ªÊ¼½ØÈ¡6¸ö×Ö·û¡£

ÈȵãÅÅÐÐ