General MySQL Oracle SQL Server

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.

 

⇒ File Formats Supported on Export Data in Oracle

⇐ Show All Background Sessions in the Database in Oracle

⇑ Introduction to Oracle SQL Developer

⇑⇑ Oracle Database Tutorials

2019-01-26, 2440🔥, 0💬

General MySQL Oracle SQL Server