Oracle Discoverer is an Oracle product that helps to do web publishing, data analysis, and ad-hoc querying and reporting using a tool set. It is very beneficial for end users or business where you need easy access to data avoiding complexities of database. By use of wizards and menus, your most of the hard work is done by the Oracle Discoverer. You can make better and well-informed decisions with Oracle Discoverer. I am going to explain the basics of connecting with and using oracle discoverer for ad hoc reporting purposes. Connecting to Oracle Discoverer: If you are starting Oracle Discoverer for the first time then you need to set up one-time set up process. You only have to follow the instructions that appear on the screen to initialize Oracle Discoverer. Goto the web URL of Discoverer. To login Oracle Discoverer you need to have a user id and password. If you do not have a public connection created by your Database Manager, then you can create your own private or user defined connection. If you are using existing login information then there is no need to define the particulars of a connection as all the information is stored in the database. You can edit or delete your Oracle Discoverer connection as per your requirements by just clicking on the Update button in front of the connection name you want to edit or by choosing Delete button to delete the connection. Update button is also useful if you want to change your settings or password for a connection.