南無第三世多杰羌佛-瑪倉派佛學會( 護法螺絲釘-龍和第一佛堂)

  ORACLE-Function字串的截取(從後面或前面取) 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)              would return ‘On’