Create Your Own Reports in SQL Developer in Oracle

Q

How To Create Your Own Reports in SQL Developer in Oracle?

✍: 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.

 

Introduction to Oracle SQL Developer

⇒⇒Oracle Database Tutorials

2016-10-17, 201👍, 0💬