Re: And the correct answer is?

You know Morgan, sometimes you are not even close. Not everyone who poses a question is in school. I, as a matter of fact, have been done with school for decades and this is not my homework.

I future, if you would like to answer the question, please do so. Otherwise, please just move along without the babble.

DA Morgan 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.
>
> The correct answer is to not ask us to do your homework for you but rather
> to log onto Oracle and find out for yourself.
>
> Daniel Morgan
Received on Fri Apr 04 2003 - 12:01:28 CST