?? instr.txt
字號:
SELECT item_desc,
INSTR(item_desc,
',',
1
)
FROM plsql101_old_item;
SELECT item_desc,
SUBSTR(item_desc,
1,
INSTR(item_desc,
',',
1
) -1
)
FROM plsql101_old_item;
SELECT item_desc,
SUBSTR(item_desc,
INSTR(item_desc,
',',
1
) +2,
99
)
FROM plsql101_old_item;
SELECT item_desc,
SUBSTR(item_desc,
1,
INSTR(item_desc,
',',
1
) -1
) CATEGORY,
SUBSTR(item_desc,
INSTR(item_desc,
',',
1
) +2,
99
) ITEM_SIZE
FROM plsql101_old_item;
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -