Error executing SQL query in Oracle

Question

I have some knowledge about SQL but a complete novice in Oracle. The following sql statement will execute properly in SQL Server. But this doesn't execute in Oracle and throws an error.

select Field1, * from Table1 where SomeField = 0

Please let know how to execute a similar statement in Oracle. The error recieved is as follows:

ORA-00936: missing expression
00936. 00000 - "missing expression"

• Art: I deleted my answer almost immed. because I noticed I made an error-missed an alias. It happens sometimes when you rush... I do not know why you was able to see my answer.

Answer 1

Try,

select Field1, a.* from Table1 a where SomeField = 0;

• Álvaro González: You can also use the table name as prefix, no need to alias.
• veljasije: For better readability, it is desirable to make table aliases with an AS key word, for example: Table1 AS a.
• Orangecrush: @ÁlvaroG.Vicario That will work too. Many different ways of tacking the same problem.
• veljasije: I agree, just to mention :) I prefer "AS" because my editor recognize key words, and color them, nothing more.
• Florin Ghita: @veljasije you're confusing column aliasing with table aliasing. Table aliasing does not permit "AS" keyword in Oracle.

Answer 2

Simply try:

select Field1, Table1.* from Table1 where SomeField = 0