Run SQL Statement through Web UI in Oracle

Q

How To Run SQL Statements through the Web Interface in Oracle?

✍: FYIcenter.com

A

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.

 

Managing Oracle Table Indexes

⇒⇒Oracle Database Tutorials

2016-10-17, 188👍, 0💬