CODEWITHSUNDEEP
sqloracle-database
Unni Kris
Unni Kris

Reputation: 3105

Error executing SQL query in Oracle

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"

Upvotes: 2

Views: 723

Answers (2)

Vishal Suthar
Vishal Suthar

Reputation: 17194

Simply try:

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

Upvotes: 1

Orangecrush
Orangecrush

Reputation: 1990

Try,

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

Upvotes: 5

Related Questions