Answers

Question and Answer:

  Home  Oracle Database

⟩ How To Create Your Own Reports in SQL Developer?

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.

 169 views

More Questions for you: