Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> way to implement sqlplus break on in sql
Hi Everybody,
Is there a better way to implement the "break on" functionality of sqlplus in sql than what is shown below?
Thanks,
John
select
(case
when depno = lag(depno) over (order by depno)
then null else depno end) depno,
/*
create and populate emp table
drop table emp;
create table emp (
name varchar2(20),
depno number
);
insert into emp values (
'FLECK',
1
);
insert into emp values (
'WOOTEN',
1
);
insert into emp values (
'FUTURE MAN',
1
);
insert into emp values (
'JACK',
2
);
insert into emp values (
'JORMA',
2
);
*/
select
(case
when depno = lag(depno) over (order by depno)
then null else depno end) depno,