How To Create Your Own Reports in SQL Developer?
Submitted by: AdministratorOracle 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.
Submitted by: Administrator
► 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.
Submitted by: Administrator
Read Online Oracle Database Job Interview Questions And Answers
Top Oracle Database Questions
☺ | How To Write Date and Time Interval Literals in Oracle? |
☺ | How To Use Values from Other Tables in UPDATE Statements using Oracle? |
☺ | How To Call a Stored Function in Oracle? |
☺ | What Happens to Indexes If You Drop a Table? |
☺ | What Is the Relation of a User Account and a Schema? |
Top DB Oracle Categories
☺ | Oracle PL-SQL Interview Questions. |
☺ | Oracle DBA Interview Questions. |
☺ | Oracle D2K Interview Questions. |
☺ | OCI Interview Questions. |
☺ | Forms Reports Interview Questions. |