I have this in a view query

```
(SELECT CAST(COUNT( *) AS NUMBER(10))
    FROM other_table ibl
    WHERE ibl.fk_id = my_table.id
)                           AS my_column

```

However Oracle still reports the column as type number with no size.

Is there any way around this? 
I want it to be number(10)

db version is 11.2