Hi All,
I have the below table structure and below dataset, i want to determine if a record(entry) is a parent or not (see highlighted last column)
create table orders (
id number generated by default on null as identity,
Order_code varchar2(200) not null,
Seq_Number not null,
order_hierarchy varchar2(100) not null,
order_level_nbr number not null,
constraint id_pk primary key (id));
Iam trying to get the results column - any help is appreciated.
Oracle 12.2.0.1.0
thanks