Re: order by

List can you please explain to me why select empno from emp order by empno ; is the same as select empno from emp order by sqrt(3.14); but not the same as select empno from emp order by dbms_random.value; What does sort by a random value do ? and why isn't dbms_random.value in the

sequence

Hello list and a happy new year to everyone, why does : insert into test values (mysequence.nextval, mysequence.currval ) ; have the same effect as insert into test values (mysequence.currval, mysequence.nextval ) ; where 1. mysequence is create sequence mysequence increment by 1 start

Re: ORACLE-L Digest -- Volume 2004, Number 001 (Out of Office

-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tony Miller INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: IBM Workload Manager (WLM)

Thank you for answering, Babette. Your use of WLM is as I have it in mind. However, a year ago, or so, before I was hired, the Infrastructure department once switched it on, and overall performance dropped drastically. Of course they did something wrong. But, nothing was logged/documented or

Re: sequence

Sounds like you need to read the docs on sequences, happy new year and happy reading. joe [EMAIL PROTECTED] wrote: Hello list and a happy new year to everyone, why does : insert into test values (mysequence.nextval, mysequence.currval ) ; have the same effect as insert into test values

Re: order by

It is for the same reason that 'select empno from emp' without and order by, also returns the same results. Take a look at $ORACLE_HOME/sqlplus/demo/demobld.sql Didn't you ask this same question earlier this week? Jared On Thu, 2004-01-01 at 01:14, [EMAIL PROTECTED] wrote: List can you please

RE: sql trace - forward attribution

Thanks a lot for your reply, Cary. One follow-up question. What would motivate a chat of sometimes 5, sometimes 10-20 'SQL*Net message to/from client' consecutive wait lines emitted to the trace file in the following manner: WAIT #0: nam='SQL*Net message to client' ela= 2 p1=1413697536 p2=1 p3=0

Re: order by

I was curious to find out why all the other sorts work the same but order by dbms_random.value ( which also returns a number like sqrt (3.14) ) behaves totally different. Any ideas ? Also could you please tell me what does it mean when someone says order by non integer some_constant . An integer

Re: order by

At 10:44 AM 1/1/2004, you wrote: I was curious to find out why all the other sorts work the same but order by dbms_random.value ( which also returns a number like sqrt (3.14) ) behaves totally different. Any ideas ? When you order by dbms_random, Oracle will generate a random number for each row

Re: sequence

Joe you are absolutely right From the sql reference : Where to use currval and nextval If any of these locations contains references to both CURRVAL and NEXTVAL, then Oracle increments the sequence and returns the same value for both CURRVAL and NEXTVAL. Sorry for the rtfm question. I

Re: order by

Thanks Justin - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, January 02, 2004 00:39 At 10:44 AM 1/1/2004, you wrote: I was curious to find out why all the other sorts work the same but order by dbms_random.value ( which also returns a

RE: sql trace - forward attribution

Boris, Cursor #0 seems reserved for two special uses: (1) wait events associated with COMMIT processing (also, of course, ROLLBACK and SAVEPOINT), and (2) wait events associated with dbcalls not instrumented because of bug 2425312. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com