Hi, I was trying to retrieve all the columns names from over 100 different views in an oracle database earlier today. I wasn't quite sure how to do it, so to save time I used query to get all the view names, then simply wrote a query that selected the view_name and column names from all views where view_name in (list of views). I was thinking about writing looping through all the view_names in the database and for each iteration storing the column_names in a variable and the outputting this to the screen. As each view can have differing number of columns though would I have to store the column names in a record variable? Then how would I retrieve the column names for each view name stored in this record variable? Am I taking the right approach? Thanks, Rob.