I'm usualy use PostgreSQL, but I'm currently doing it in Oracle. 

I need to chage the data type of a column in a query(select), in PostgreSQL I usualy do it in this way:

```
select 1::varchar from table

```

Hoe can I do this in Oracle?

Best Regards,