Oracle DBA FAQ - Introduction to Oracle SQL Developer

Home >> FAQs/Tutorials >> Oracle DBA FAQ

By: FYIcenter.com

Part: 1 2 3 4 5 6

(Continued from previous part...)

How To Get a List of All User Accounts in the Database?

If you don't like to use a SELECT statement to get a list of all user accounts in the current database, you can use the Reports view to do this as shown in the following tutorial example. You need to connect to the server as SYSTEM to do this:

Click menu View.
Selects Reports from the menu.
Open Reports.
Open Data Dictionary Reports.
Open Database Administration.
Open Users.
Double-click All Users.

You should get a list all current user accounts in the database.

How To Get a List of All Background Sessions in the Database?

If you don't like to use a SELECT statement to get a list of all background sessions in the current database, you can use the Reports view to do this as shown in the following tutorial example. You need to connect to the server as SYSTEM to do this:

Click menu View.
Selects Reports from the menu.
Open Reports.
Open Data Dictionary Reports.
Open Database Administration.
Open Sessions.
Double-click Background Sessions.

You should get a list all current background sessions in the database.

How To Create Your Own Reports in SQL Developer?

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.

How Many File Formats Are Supported to Export Data?

Oracle SQL Developer can allow to export table data into files in the following formats:

TXT - Tab delimited fields file format.
CSV - Comma Separated Values (CSV) file format.
LOADER - File format used by SQL*Loader.
XML - XML file format.
INSERT - INSERT statements format.

How To Export Data to a CSV File?

If you want to export data from a table to a file in CSV format, you can use the following steps:

Right-click the table name, EMPLOYEES, in the object tree view.
Select Export.
Select CSV. The Export Data window shows up.
Click Format tab.
Select Format as: CSV.
Enter File as: \temp\MyTeam.csv.
Click Columns tab.
Check columns: FIRST_NAME, LAST_NAME, MANAGER_ID
Click Where tab.
Enter Where clause as: MANAGER_ID=100.
Click Apply.

Your CSV file, \temp\MyTeam.csv, is ready. Open it, you will see:

"FIRST_NAME","LAST_NAME","MANAGER_ID"
"Gerald","Cambrault","100"
"Lex","De Haan","100"
"Alberto","Errazuriz","100"
"Adam","Fripp","100"
"Michael","Hartstein","100"
"Payam","Kaufling","100"
"Neena","Kochhar","100"
...

CSV files can be open by Microsoft Excel.

(Continued on next part...)

Part: 1 2 3 4 5 6

More...