Home >> FAQs/Tutorials >> Oracle DBA FAQ

Oracle DBA FAQ - Introduction to Oracle SQL Developer

By: FYIcenter.com

Part:   1   2  3  4  5  6 

A collection of FAQ to introduce Oracle SQL Developer, the new free GUI client for DBA and developers. This FAQ can also be used as learning tutorials on SQL statement execution, data objects management, system views and reports, stored procedure debugging. Topics included in this FAQ are:

1. What Is Oracle SQL Developer?
2. What Operating Systems Are Supported by Oracle SQL Developer?
3. How To Download Oracle SQL Developer?
4. How To Install Oracle SQL Developer?
5. How To Start Oracle SQL Developer?
6. Is Oracel SQL Developer written in Java?
7. How To Connect to a Local Oracle 10g XE Server?
8. How To Connect to a Remote Server?
9. How To Run SQL Statements with Oracle SQL Developer?
10. How To Export Your Connection Information to a File?
11. How To Run SQL*Plus Commands in SQL Developer?
12. How To Work with Data Objects Interactively?
13. How To Get a CREATE Statement for an Existing Table?
14. How To Create a Table Interactively?
15. How To Enter a New Row into a Table Interactively?
16. What Is the Reports View in Oracle SQL Developer?
17. How To Get a List of All Tables in the Database?
18. How To Get a List of All User Accounts in the Database?
19. How To Get a List of All Background Sessions in the Database?
20. How To Create Your Own Reports in SQL Developer?
21. How Many File Formats Are Supported to Export Data?
22. How To Export Data to a CSV File?
23. How To Export Data to an XML File?
24. How To Create a Procedure Interactively?
25. How To Run a Stored Procedure Interactively?
26. How To Run Stored Procedures in Debug Mode?
27. How To Assign Debug Privileges to a User?
28. How To Set Up Breakpoints in Debug Mode?
29. What Do You Think about Oracle SQL Developer?

Sample tutorial scripts provided in this collection of FAQ assume that you have installed Oracle 10g Express Edition (XE), and the default database XE is running on the server with the default user account HR activated. See other tutorials on how to install Oracle 10g XE.

What Is Oracle SQL Developer?

Oracle SQL Developer is a new, free graphical tool that enhances productivity and simplifies database development tasks. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You can also run any number of provided reports, as well as create and save your own.

Oracle SQL Developer is formerly called Project Raptor.

What Operating Systems Are Supported by Oracle SQL Developer?

Oracle SQL Developer is available for three types of operating Systems:

• Windows
• Linux
• Mac OSX

How To Download Oracle SQL Developer?

If you want to download a copy of Oracle SQL Developer, visit http://www.oracle.com/technology/software/products/sql/.

If you are using Windows systems, click the "Oracle SQL Developer for Windows" link. This allows you to download the Windows version in ZIP format with file name of sqldeveloper-v1.0.0.zip in 55,295,721 bytes.

How To Install Oracle SQL Developer?

Once you have sqldeveloper-v1.0.0.zip downloaded, extract the zip file into the root directory: \.

When the extraction is done, the installation is completed. Your copy of Oracle SQL Developer is installed in directory: \sqldeveloper, and ready to run.

How To Start Oracle SQL Developer?

To start Oracle SQL Developer, go to \sqldeveloper and click sqldeveloper.exe. The Oracle SQL Developer window shows up. Your copy of Oracle SQL Developer is running now. There will nothing under the Connections icon, because you haven't defined any connections yet.

You should visit different menu items to explore the user interface. One nice place to visit is the About item under the Help menu. It provides some very useful information about your copy of Oracle SQL Developer.

Is Oracel SQL Developer written in Java?

Oracel SQL Developer is written in Java. It requires JDK 1.5, which is already included in your download file.

How To Connect to a Local Oracle 10g XE Server?

If you have your Oracle 10g XE server running on your local machine, you can connect your Oracle SQL Developer to the server with the following steps:

• Start Oracle SQL Developer
• Right-click on Connections
• Select New Database Connection
• Enter Connection Name as: Local_XE
• Enter Username as: HR
• Enter Password as: fyicenter
• Enter Hostname as: 127.0.0.1
• Enter SID as: XE
• Click Test
• Click Connect, if you see Status changed to Success

You will see the SQL Statement area opened ready to take any SQL statements.

(Continued on next part...)

Part:   1   2  3  4  5  6