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.

 

Create a Table Index in Oracle

Index - Data Structure for Query Performance in Oracle

Managing Oracle Table Indexes

⇑⇑ Oracle Database Tutorials

2019-05-01, 1809🔥, 0💬