I am trying to run a query where I am using subqueries in the select statement.  

This works: 

```
select   
(select sysdate from dual),   
(select 'municipality' from dual),  
(select count(*) from municipality)  
from dual;  

```

But the resulting columnnames are ugly and therefore I want to add the column aliases.

I am trying to run the following query:

```
select   
(select sysdate from dual) as sysdate,   
(select 'municipality' from dual) as tablename,  
(select count(*) from municipality) as count  
from dual;

```

This fails with the ORA 00923: From keyword not found where expected error. 
Somehow, I am missing something. 

Any suggestions? 

Thanks.