Help me. [message #1243] |
Sun, 14 April 2002 21:56 |
happyhero
Messages: 10 Registered: April 2002
|
Junior Member |
|
|
I met the question.
select * from (select * from nb order by field1);
this query run right in oracle 8i
but error in oracle 8.
why?
|
|
|
Re: Help me. [message #1276 is a reply to message #1243] |
Tue, 16 April 2002 10:00 |
Cindy
Messages: 88 Registered: November 1999
|
Member |
|
|
What is the error message? I just ran a test and I did not run into any problem.
SQL> create table t (tname varchar2(30));
Table created.
SQL> insert into t values('John Doe');
1 row created.
SQL> insert into t values('Sandy Doe');
1 row created.
SQL> insert into t values ('Sam Adams');
1 row created.
SQL> commit;
Commit complete.
SQL> select * from t;
TNAME
------------------------------
John Doe
Sandy Doe
Sam Adams
SQL> select * from (select * from t order by tname);
TNAME
------------------------------
John Doe
Sam Adams
Sandy Doe
|
|
|