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"

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. — Art, Feb 01 '13 at 14:17

score 5 · Accepted Answer · answered Feb 01 '13 at 13:50

5

Try,

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

answered Feb 01 '13 at 13:50

Orangecrush

1,970
2
15
26

2

You can also use the table name as prefix, no need to alias. – Álvaro González Feb 01 '13 at 13:53
For better readability, it is desirable to make table aliases with an AS key word, for example: Table1 AS a. – veljasije Feb 01 '13 at 13:55
@ÁlvaroG.Vicario That will work too. Many different ways of tacking the same problem. – Orangecrush Feb 01 '13 at 13:56
1

I agree, just to mention :) I prefer "AS" because my editor recognize key words, and color them, nothing more. – veljasije Feb 01 '13 at 13:57
@FlorinGhita Follow this link http://stackoverflow.com/questions/8451195/is-the-as-keyword-required-in-oracle-to-define-an-alias – veljasije Feb 01 '13 at 14:34
2

@veljasije you're confusing column aliasing with table aliasing. Table aliasing does not permit "AS" keyword in Oracle. – Florin Ghita Feb 01 '13 at 14:42

score 1 · Answer 2 · answered Feb 01 '13 at 13:56

1

Simply try:

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

answered Feb 01 '13 at 13:56

Vishal Suthar

17,013
3
59
105

Error executing SQL query in Oracle

2 Answers2