SQL Error: ORA-00933: SQL command not properly ended 00933. 00000 - "SQL command not properly ended"

Question

I have looked through this site and cannot find a similar scenario. I am trying to run the following code

SELECT st.storeid, s.noofitems
FROM salestrnsaction AS st, soldvia AS s
WHERE st.tid = s.tid
ORDER BY noofitems ASC;

and am still receiving the 'SQL command not properly ended' error.

More specifically, this is the message I am receiving.

SELECT st.storeid, s.noofitems
FROM salestrnsaction AS st, soldvia AS s
WHERE st.tid = s.tid
ORDER BY noofitems ASC
Error at Command Line : 287 Column : 22
Error report -
SQL Error: ORA-00933: SQL command not properly ended
00933. 00000 -  "SQL command not properly ended"
*Cause:    
*Action:

Thanks.

brenners1302 · Accepted Answer · 2016-04-19 01:19:31Z

10

You are using ORACLE right?Using AS in alias in FROM Clause is not valid in Oracle. Please refrain from using AS in giving aliases to tables.

Just write the alias after the table.

SELECT st.storeid, s.noofitems
FROM salestrnsaction st, soldvia s
WHERE st.tid = s.tid
ORDER BY s.noofitems ASC;

answered Apr 19, 2016 at 1:19

brenners1302

1,47811 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

D. Romanski Over a year ago

Perfect! Thank you. We haven't covered aliases yet, so I was going off of what I could find online. This worked. Appreciate the help all.

brenners1302 Over a year ago

Np.If it works, please mark it as the correct answer.Thanks

sql_dummy Over a year ago

Do we need to mandatorly use aliasin order by? @brenners1302

brenners1302 Over a year ago

yes.so it wouldnt be ambigous if the column exist in both tables.

Chicken Sandwich No Pickles Over a year ago

This was my problem, stupid oracle.

Alan Kavanagh · Accepted Answer · 2017-10-16 20:13:22Z

0

My issue was a little bit different. I was just performing a simple SELECT and got the same error.

SELECT *
-- Inventory
FROM EQUIPMENT as EQP

What I discovered from the research I did is the AS is not needed for Oracle SQL vs MySQL, so when I changed to the query to...

SELECT *
-- Inventory
FROM EQUIPMENT EQP

this eliminated the error.

edited Oct 16, 2017 at 20:13

Alan Kavanagh

9,9338 gold badges46 silver badges68 bronze badges

answered Oct 16, 2017 at 19:48

RonniBrown

113 bronze badges

Collectives™ on Stack Overflow

SQL Error: ORA-00933: SQL command not properly ended 00933. 00000 - "SQL command not properly ended"

2 Answers 2

5 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related