Nested query in SELECT statement

[Sweetie]

Hi

that's called scalar subquery and it's new in 8i, perhaps you can research with that name on the net