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, 5520👍, 0💬
Related Topics:
