Q: an Inline SELECT forming a column

Please give me an example of this type of query:

SELECT....(SELECT col_x FROM some_table where....) FROM...... i.e. the inline SELECT forms a column - I'm not sure whether the inline SQL returns a scalar value or many rows

and what is the name of this type of query ?

thanks

-- 
10gR2