請問在在oracle中類似sqlsever的 left(t_cont,CHARINDEX(':',t_cont)-1)陳述句要怎么寫
uj5u.com熱心網友回復：
-- 給你提供兩種寫法
SQL>
SQL> create table test(name varchar(20));
Table created
SQL> begin
2 insert into test values('name:zhangsan');
3 insert into test values('address:beijing');
4 end;
5 /
PL/SQL procedure successfully completed
SQL> col name format a20;
SQL> col name_1 format a20;
SQL> col name_2 format a20;
SQL> select name,
2 substr(name, 1, instr(name, ':') - 1) name_1,
3 regexp_substr(name, '[^:]+', 1, 1) name_2
4 from test;
NAME NAME_1 NAME_2
-------------------- -------------------- --------------------
name:zhangsan name name
address:beijing address address
SQL> drop table test purge;
Table dropped
SQL>
uj5u.com熱心網友回復：
感謝大佬還有一個問題想問您
sqlsever 中 left(TERM,len(TERM)-1） >=12在oracle中要怎么寫呢
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/41654.html
標籤：開發