![]() ![]() The All Parameters report-Reports->Data Dictionary Reports->Database Administration->Database Parameters->All Parameters-lists all of the database initialization parameters. Browse through all of them to see which might be useful to you. The reports I list below are ones I find useful in my job. We’ll start by reviewing some of these standard reports. ![]() ![]() The Data Dictionary Reports folder lists the Oracle-supplied set of predefined reports. ( Note: When you select a report to run, you may see the Select Connection dialog box. #ORACLE SQL DEVELOPER VIEW TABLES PLUS#For example, the Data Dictionary Reports directory is a subfolder of the Reports folder, or in navigation syntax, Reports->Data Dictionary Reports.Ĭlick on the plus sign next to any of the subfolders in the Data Dictionary folder. Tree-view navigation works here on the concept of folders and files. Click the plus sign ( + ) next to the Reports symbol and then the plus sign next to Data Dictionary Reports. Ignore the User Defined Reports item for now. Connect to a database, and click the Reports tab. To get to the reports, first launch Oracle SQL Developer for your platform. For details on these topics, see the Oracle SQL Developer home page on OTN. Installing, configuring, and creating a connection to your database is beyond the scope of this article. Oracle SQL Developer reports also support bind variables and drill-down reporting. The report facility allows reports to be created in two ways: You can choose from a large set of predefined standard data dictionary reports or create a user-defined report. It’s based on the Oracle JDeveloper Java IDE and has an intuitive tree-based navigation structure. Oracle SQL Developer offers many powerful features for developers, including graphical dialog boxes for database object manipulation, SQL worksheets, a PL/SQL editor, and a reporting facility. Oracle SQL Developer runs on the Windows, Macintosh, and Linux platforms. Like Oracle Database 10 g Express Edition (XE) and Oracle JDeveloper, Oracle SQL Developer can be downloaded completely free. Oracle SQL Developer (formerly Project Raptor) is Oracle’s new multiplatform graphical user interface (GUI) for developers and DBAs. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |