Basic Oracle Concepts and Programming Question:
Download Job Interview Questions and Answers PDF
How To Run SQL Statements through the Web Interface?
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.
► 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 Question | Next Question |
| What Is a Table Index? | How To Create a Table Index? |