To
query a table or view, you must have:
Querying and updating tables and view
Depending on your access privileges, you can use the Database Navigator to:
|
Query the contents of a table or view. |
|
|
Insert a new row into a table or the base table for a view. |
|
|
Update a table or view base table row. |
|
|
Delete a table or view base table row. |
To
query a table or view, you must have:
View access privileges on the schema that owns the table or view, or
SELECT object-level privileges on the table or view.
To insert a table or view row, you must have:
Insert access privileges on the schema that owns the table or view.
To update or delete a table or view row, you must have:
Modify access privileges on the schema that owns the table or view.
In the Oracle Portal Navigator, navigate to the list of schemas.
The Name column on the Database Objects tab contains a list of all schemas in the database on which you have View access privileges. In the Name column, scroll down to the schema containing the database object you want to find.
Click the schema Name. The Name column updates with a list of objects stored in the schema you selected.
Scroll down to the database object you want to find.
Note To find an object, you
can also enter the name of the database object in the Find field at
the top of the page and click Go.
The actions you can perform on an object display in the Actions column next to each object.
In the Actions column, click Query Rows. A Query by Example report displays entry fields corresponding to the columns in the table or view.
Enter query criteria in one or more of the table or view column entry fields.
Note To view all rows in the table or view, leave all table column entry fields in the Query by Example report blank or deselected, leave Show selected for each row, then click Query.
(Optional)Choose Order by
and other query options on the Query by Example report. If you have a
question about an option, click the small 
button to view help.
Click Query. A page displays a report containing the columns you selected and all table rows matching your search criteria.
To insert a new table or view row:
Follow steps 1-7 above.
In the Actions column, click Modify Rows.
A Query by Example report displays entry fields corresponding to the columns in the table or view.
Enter the column values you want to add for the new table or view row. Columns that display in red text do not accept null values.
Click Insert New Rows.
A confirmation message at the top of the page indicates if you were successful.
To update a table or view row:
Follow steps 1-7 above.
In the Actions column, click Modify Rows. A Query by Example report displays entry fields corresponding to the columns in the table or view. Enter query criteria in one or more of the table or view column entry fields.
Note To view all rows in the table or view, leave all table column entry fields in the Query by Example report blank or deselected, leave Show selected for each row, then click Query.
(Optional) Specify Order by
and other query options on the Query by Example report. If you have a
question about an option, click the small
button to view help.
Click Query. A page displays a report containing the columns you selected and all table rows matching your search criteria. The follow example shows a section of the report that was generated by leaving column entry fields for the SCOTT.EMP table blank, leaving Show selected for each row, and clicking Query.
Click Update next to the row you want to update. Another Query by Example report displays. For example, the follow report displays if you click next to EMPNO 7844.
Update values in the column entry fields and click Update.
A confirmation message at the top of the page indicates if you were successful.
Follow steps 1-5 above.
Click Delete. A message asks you to confirm that you want to delete the row form the table or view.
Click Yes.