Aliasing in Oracle

[mlnsharma]

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?

 

 

[mlnsharma]

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.. :'(

[artacus]

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.