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 Shutdown Your 10g XE Server? |
| ☺ | How To Use "OUT" Parameter Properly? |
| ☺ | How Run SQL*Plus Commands That Are Stored in a Local File? |
| ☺ | How To Write Numeric Literals in Oracle? |
| ☺ | 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. |
| ☺ | Oracle RMAN Interview Questions. |
