Basic Oracle Concepts and Programming Question:

How To Run SQL Statements through the Web Interface?

Tweet Share WhatsApp

Answer:

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/globalguideline
► 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.


Download Oracle Database PDF Read All 430 Oracle Database Questions
Previous QuestionNext Question
What Is a Table Index?How To Create a Table Index?