Re: And the correct answer is?

Fisrt, my writing is NOT out of line. Who is this US? DA Morgan seems like a person, not a group. Do you own this newsgroup? Did not think so!

You mother should have taught you that 'If you do not have anything decent to say, say nothing'. You know.... just pass by.

Maybe 'your general impression', as usual you are completely incorrect with both your 'assumptions'.. You continue to talk like you are the head of some organization and everyone knows that is not the case. I'll be that the only time you make these type of comments is when you are in the safety of your little room on your little computer. Bet you never make them in public, do you?

DA Morgan wrote:

> sfk wrote:
>
>>
>>
>> Connor McDonald wrote:
>>
>> > sfk wrote:
>> > >
>> > > The following is from a text..... I would like some opinions ....
>> > what
>> > > is the correct answer.
>> > >
>> > > EMP Table is defined as follows:
>> > > EMPNO NUMBER 4
>> > > ENAME VARCHAR2 30
>> > > SALARY NUMBER 14,2
>> > > COMM NUMBER 10,2
>> > > DEPTNO NUMBER 2
>> > >
>> > > You perform the following tow queries:
>> > >
>> > > 1. SELECT empno enumber, ename FROM emp ORDER BY 1;
>> > > 2. SELECT empno, ename FROM emp ORDER BY ASC;
>> > >
>> > > Which of the following is true?
>> > > A. Statements 1 and 2 will produce the same result.
>> > > B. Statement 1 will execute; statement 2 will return an error.
>> > > C. Statement 2 will execute; statement 1 will return an error.
>> > > D. Statement 1 and 2 will execute but produce different results.
>> >
>> > Hmmmmmmmmmmmm...lets see
>> >
>> > what's an 'enumber' ? what's an 'asc' ?
>> > With the two above questions, does not seem you are capable of
>> > bright ideas.
>>
>> >
>> > Hey, here's a bright idea - you could
>> >
>> > a) run @?/rdbms/admin/utlsampl.sql to create the SCOTT schema
>> > b) run the two statements
>> > c) see what happens
>>
>> d) know what happens!
>> If you don't want to participate, why don't you just move along and
>> leave you witty and 'bright ideas' somewhere else!
>>
>>
>> >
>> >
>> > cheers
>> > connor
>> > --
>> > =========================
>> > Connor McDonald
>> > http://www.oracledba.co.uk
>> >
>> > "Some days you're the pigeon, some days you're the statue"
>>
>
> Your abusive behavior is way out of line. You came to us, unsolicited,
> and asked a question. We have a perfect right to answer as we see fit.
> If you don't like the answers you got reconsider your original post.
>
> The general impression you created is that you are taking an Oracle
> class and don't even have a copy of the product on which to work ...
> or are too lazy to do so.
>
> Daniel Morgan
>
Received on Fri Apr 04 2003 - 18:22:31 CST