How You Can Debug Database Queries
The Query tab lets you run SQL queries. You can insert a query into the current database session of your application, or you can open a new session. If you issue a statement that returns data, the results are displayed in the Query Results portlet.