[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: (ET)wheel horse electric on ebay....



What the heck is all this???

On 30 May 2002 at 8:12, Chapin, Tim wrote:

> select  /*+ rule */ 
> a.object_id, B.SID, C.USERNAME, C.OSUSER, C.TERMINAL,
>   DECODE(B.ID2, 0, A.OBJECT_NAME,
>    'Trans-' || to_char(B.ID1)) OBJECT_NAME,
>   B.TYPE,
>   DECODE(B.LMODE,0,'--Waiting--',
>     1, 'Null',
>     2, 'Row Share',
>     3, 'Row Excl',
>     4, 'Share',
>     5, 'Sha Row Exc',
>     6, 'Exclusive',
>     'Other') "Lock Mode",
>   DECODE(B.REQUEST, 0, ' ',
>     1, 'Null',
>     2, 'Row Share',
>     3, 'Row Excl',
>     4, 'Share',
>     5, 'Sha Row Exc',
>     6, 'Exclusive',
>     'Other') "Req Mode"
> from ALL_OBJECTS A, V$LOCK B, V$SESSION C
> where A.OBJECT_ID(+) = B.ID1
> AND A.OWNER = 'SYSADM'
> and B.SID = C.SID


David Roden - Akron, Ohio, USA
1991 Solectria Force 144vac
1991 Ford Escort Green/EV 128vdc
1970 GE Elec-trak E15 36vdc
1974 Avco New Idea 36vdc
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Thou shalt not send me any thing which says unto thee, "send this to all 
thou knowest."  Neither shalt thou send me any spam, lest I smite thee.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Est. yearly US cost to safeguard Persian Gulf oil supply: $50 billion
Est. 2001 value of US crude oil imports from Persian Gulf: $19 billion
                                                          -- Harper's 
Index, 
April 2002
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =