后山遊子

substr(‘This is a test’, 6, 2) would return ‘is’
substr(‘This is a test’, 6) would return ‘is a test’
substr(‘TechOnTheNet’, 1, 4) would return ‘Tech’
substr(‘TechOnTheNet’, -3, 3) would return ‘Net’
substr(‘TechOnTheNet’, -6, 3) would return ‘The’
substr(‘TechOnTheNet’, -8, 2)

 

以上內容擷取自http://kuanglian2000.wordpress.com/2006/12/16/oracle-function%e5%ad%97%e4%b8%b2%e7%9a%84%e6%88%aa%e5%8f%96%e5%be%9e%e5%be%8c%e9%9d%a2%e6%88%96%e5%89%8d%e9%9d%a2%e5%8f%96/

 

文章簽名檔