Home >> FAQs/Tutorials >> Oracle Tutorials

Oracle Tutorials - Run SQL Statement through Web UI

By: FYIcenter.com

(Continued from previous topic...)

How To Run SQL Statements through the Web Interface?

If you don't like the command line interface offered by SQL*Plus, you can use the Web interface to run SQL statements. Here is how:

• Open your Web browser to http://localhost:8080/apex/
• Log in to the server with the predefined sample user account: HR/fyicenter
• Click the SQL icon
• Click the SQL Commands icon
• Enter any SQL statement like: "SELECT COUNT(*) FROM USER_TABLES;", in the text area and click Run button
• Your Oracle will execute the statement, and display the result in the result area.

(Continued on next topic...)

1. What Is an Index?
2. How To Run SQL Statements through the Web Interface?
3. How To Create a Table Index?
4. How To List All Indexes in Your Schema?
5. What Is an Index Associated with a Constraint?
6. How To Rename an Index?
7. How To Drop an Index?
8. Can You Drop an Index Associated with a Unique or Primary Key Constraint?
9. What Happens to Indexes If You Drop a Table?
10. How To Recover a Dropped Index?
11. What Happens to the Indexes If a Table Is Recovered?
12. How To Rebuild an Index?
13. How To See the Table Columns Used in an Index?
14. How To Create a Single Index for Multiple Columns?