Topic: 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.