Re: way to implement sqlplus break on in sql

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 24 May 2007 09:19:17 -0700
Message-ID: <1180023557.871855@bubbleator.drizzle.com>

sybrandb wrote:

> On May 24, 1:54 am, DA Morgan <damor..._at_psoug.org> wrote:
>> grasp06110 wrote:

>>> 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

>> Show where?
>> --
>> Daniel A. Morgan
>> University of Washington
>> damor..._at_x.washington.edu
>> (replace x with u to respond)
>> Puget Sound Oracle Users Groupwww.psoug.org- Hide quoted text -
>>
>> - Show quoted text -
> 
> Here....
> select
>   (case
>     when depno = lag(depno) over (order by depno)
>         then null
>         else depno
>         end) depno,
>   name
> from
>   emp
> 
> 
> Time to get spectacles, Daniel? Or just more coffee ? ;)
> 
> --
> Sybrand Bakker
> Senior Oracle DBA

I'm wearing them. ;-)

Go to the top of this email and the OP wrote "break on." Search for the word "break" in the body of the text? If it is there I still can't find it and neither can the 'find' functionality.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Thu May 24 2007 - 11:19:17 CDT