dear all ,, i m happy to join this forum ... i m doing OCP 9i certification ,, being a student please help me ...

Q. i was trying to creat queries to select all tables in TAB using HR schema
using ,, select 'Select * from ' || tname from tab
now please tell me the way to make the same to any table's columns????