have a look at the reports module or use SQLSelectedGridView from www.tressleworks.ca.

I tried it with report modle and it is really easy and helpfull. this is if am working in dotnetnuke database Annoucment table forexample just I have to add my qurey string

what about if I have one more table in Oracle database how can i  get data from that table?

1) how can I add the connection to that data base in web.config file?

2) is it the same simple as using the report module with sql database?

thanks.