<p>In MS SQL 2005 or T-SQL, you can do something like:</p>

<pre><code>SELECT T.NAME, T.DATE 
  FROM (SELECT * FROM MyTable WHERE ....) AS T
</code></pre>

<p>I failed to try the similar SQL on Oracle 9i DB. In MS SQL, the nested SQL is treated as a temporary/dynamic view created on fly and destroyed afterward. How can I do the similar thing in Oracle? I really don't want to create a view to do it.</p>

I believe it chokes on the "as".
```
```
SELECT T.NAME, T.DATE 
  FROM (SELECT * FROM MyTable WHERE ....)  T
```
```
should work.