回覆列表
  • 1 # 使用者6369109692826

    Oracle中 其語法為:

    substr函式的用法,取得字串中指定起始位置和長度的字串 ,預設是從起始位置到結束的子串。

    substr( string, start_position, [ length ] ) substr("目標字串",開始位置,長度)

    如:

    substr("This is a test", 6, 2) would return "is"

    substr("This is a test", 6) would return "is a test"

    substr("TechOnTheNet", -3, 3) would return "Net"

    substr("TechOnTheNet", -6, 3) would return "The"select substr("Thisisatest", -4, 2) value from dual

  • 中秋節和大豐收的關聯?
  • 做仰臥起坐的利與弊?