Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> way to implement sqlplus break on in sql

way to implement sqlplus break on in sql

From: grasp06110 <grasp06110_at_yahoo.com>
Date: 23 May 2007 16:27:29 -0700
Message-ID: <1179962848.967604.91890@h2g2000hsg.googlegroups.com>


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,

  name
from
  emp

/*

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,

  name
from
  emp Received on Wed May 23 2007 - 18:27:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US