Oracle database not executing query

Asked By 0 points N/A Posted on -

I am a student of university.for one of my university course project, i need to install oracle database system.

I already installed oracle 10G in my desktop.but its not running(executing query).

Now i want to irun it and execute query in order to practice database query.

Please help with this…

Answered By 0 points N/A #94803

Oracle database not executing query


I hope at this stage you have created tables which you want to use queries on. If you have not then you will start by creating the queries first. Then select the query against the table you want, you can get the query executed by either saving or clicking the run button. When you click on the explain tab in the bottom pane then it brings the next screen which shows the query plan, the index on the columns and the details of the table's columns.

The go to the describe tab and here you will get a message which asks you to type the PL/SQL statement. when you type here it will produce results in the next screen. Then review the query and get it saved. The next time you run the SQL saved queries it will not show then click on the save button to save the query it will still need you to provide a name description to the query.

So this time when you check on saved SQL it will show you the query.

Login/Register to Answer

Related Questions