Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table person(id number, name varchar2(10), data varchar2(100));
insert into person(id, name, data) values(1, 'sasha', 'qweqweqwe');
1 rows affected

insert into person(id, name, data) values(2, 'sasha', 'werwerw');
1 rows affected

insert into person(id, name, data) values(3, 'dima', 'asdasdasd');
1 rows affected

insert into person(id, name, data) values(4, 'dima', 'zxczxczxc');
1 rows affected

insert into person(id, name, data) values(5, 'dima', 'dfgdfgdfg');
1 rows affected

SELECT * FROM person;


ID
NAME
DATA


1
sasha
qweqweqwe

2
sasha
werwerw

3
dima
asdasdasd

4
dima
zxczxczxc

5
dima
dfgdfgdfg


break on name
select * from person order by name desc, id;
ORA-00900: invalid SQL statement

ID	NAME	DATA
1	sasha	qweqweqwe
2	sasha	werwerw
3	dima	asdasdasd
4	dima	zxczxczxc
5	dima	dfgdfgdfg