mlnsharma Posted August 29, 2009 Share Posted August 29, 2009 select * from table as t where t.sal>100 ; * ORA-00933: SQL command not properly ended What is the error here? In Oracle, this statement is showing an error, while it is fine in Mysql? Can anyone answer this please? Quote Link to comment https://forums.phpfreaks.com/topic/172356-aliasing-in-oracle/ Share on other sites More sharing options...
mlnsharma Posted August 29, 2009 Author Share Posted August 29, 2009 I got it..Removed the 'as' keyword and is working fine.. But alter table emp drop column sal; //query is not working.i tried it this way also alter table emp drop sal; It is working with Mysql, but with oracle, it is not dropping the column "sal".It says "Missing Keyword" for both queries(above). Please suggest a solution.. :'( Quote Link to comment https://forums.phpfreaks.com/topic/172356-aliasing-in-oracle/#findComment-908817 Share on other sites More sharing options...
artacus Posted September 8, 2009 Share Posted September 8, 2009 alter table emp drop column sal; That is the correct syntax. You may need to identify the schema, and you'll need to have permission to edit the table. But I can see no reason why this wouldn't work. Quote Link to comment https://forums.phpfreaks.com/topic/172356-aliasing-in-oracle/#findComment-914923 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.