How to Analyze in Oracle
- 1). Click "Start," select "All Programs" and click "Oracle SQL Analyze" to enter Analyze's main interface. There are three divisions of the main window: a navigation panel on the left, SQL Statement and the Execution window.
- 2). Click the database that you wish to analyze and expand the database services on the navigation panel. Click the top SQL object to activate the top SQL filtering function.
- 3). Enter this SQL Statement in the Statement window:
SELECT name, gender and age From hr where department=:2
This statement requests staff's data from table hr, which belong to department 2. - 4). Click the "Apply" button, which contains a check mark. The execution window will show the result of SQL statement execution. You can also click the "Reject" button below the check mark to reject the edit.
Source...