How To Create Your Own Reports in SQL Developer

Q

How To Create Your Own Reports in SQL Developer? - Oracle DBA FAQ - Introduction to Oracle SQL Developer

✍: FYIcenter.com

A

Oracle SQL Developer also lets you create your own reports. See the following steps on how to do this:

  • Click menu View.
  • Selects Reports from the menu.
  • Open Reports.
  • Right-click on User Defined Reports.
  • Select Add Report.
  • Enter Name as: My Team.
  • Enter Description as: List of employees in my team.
  • Enter SQL as: SELECT * FROM HR.EMPLOYEES WHERE MANAGER_ID=100
  • Click Apply.

Your report "My Team" is ready.

2007-04-27, 4831👍, 0💬