Скачать или смотреть Split String into 2 Columns Oracle SQL

Split String into 2 Columns Oracle SQL

SQL used in Video:
create table parse_table
(sales_order varchar2(100),
creation_date date);

insert into parse_table
select '90000000*400', sysdate from dual;

select instr(sales_order, '*', 1, 1) star_position, sales_order from parse_table;

select substr(sales_order, 1, instr(sales_order, '*', 1, 1)-1) first_string,
instr(sales_order, '*') star_position,
sales_order
from parse_table;

select substr(sales_order, instr(sales_order, '*', 1, 1)+1) second_string,
instr(sales_order, '*') star_position,
sales_order
from parse_table;

select substr(sales_order, 1, instr(sales_order, '*', 1, 1)-1) first_string,
substr(sales_order, instr(sales_order, '*', 1, 1)+1) second_string,
instr(sales_order, '*') star_position,
sales_order
from parse_table;