View, Clustur & Pooled Table

Hi,

I have few questions on the above topics.

How can we retreive data from View , Clustur & Pooled Table using Select statements.

If possible can you explain me with an example.

what kind of data can we retreive from them . for example BSEC - how can we use it .

Thank you in advance.

Ry