Basic Oracle Concepts and Programming Question:

Download Job Interview Questions and Answers PDF

How To Run SQL Statements through the Web Interface?

Oracle Database Interview Question
Oracle Database Interview Question

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 Interview Questions And Answers PDF

Previous QuestionNext Question
What Is a Table Index?How To Create a Table Index?