Oracle Help for the Web

Query and Modify

Use this page to query or modify a table or view.

To update or delete a table or view row, choose search criteria that displays the row, then click Query. The results page displays links that enable you to update and delete rows that match your search criteria.

You can also choose options that format the results of your query.

To Insert a row into table or view, you must have Insert or higher schema-level access privileges.

To update or delete a row in a table or view, you must have Modify or higher schema-level access privileges.

The Query and Modify page does not display options for Inserting and Updating rows if you do not have these privileges.

Field Descriptions

Field	Description
Insert Row	Click to insert a new row into the table using the Values you specified on this page.
Query	Click to display data based on the criteria you entered on this page.
Reset	Click to clear or reset all fields on this page to their default values.
Show	Select to display the corresponding Column in the query results.
Column	Enter values that will be used to query rows in the table or view. You can use boolean expressions, for example, `>1000` to query a column containing numeric data.
Datatype	Displays the datatype for values in the Column. - DATE - NUMBER - RAW - VARCHAR
Value	Enter a values that will be used to query a Column in the table identified in the upper left corner of the page.
Align	Choose whether to display data to the left, right, or center of the column in the query results.
Format Mask	Choose an Oracle display format for columns containing date and number data types. For example, if you choose DD/MM/RR, the date January 2nd, 2000 displays as `02/01/00`. If you choose 999G999G999G999D99999999, the display format for numbers is 12 digits to the left of the decimal point and 8 to the right. Note: Refer to the Oracle documentation for additional information about formatting options.
Case Sensitive	Select to make the Value you selected case-sensitive in your query of the table column. This check box displays only for columns with (character) datatypes.
Where Clause	Enter a SQL WHERE clause to further restrict the data returned by a query. For example, if you choose to show ENAME, EMPNO, SAL columns from the SCOTT.EMP table, you could enter this WHERE clause : `WHERE DEPTNO = 10` to return data only for department 10, as shown below.

Row Order Options

Field	Description
Order By	Choose the table or view column whose values will be used to sort rows on the results page. Choosing this option is equivalent to specifying a SQL ORDER BY clause. Choose Ascending to sort query results according to the alphabetic (A-Z) or numeric (starting with the lowest number) order of column values, depending on the datatype for the column. Choose Descending to sort in the reverse order.
Maximum Rows/Page	Enter the maximum number of rows you want to display on a query results page. Note: A Next and Previous button will display at the bottom of results pages. Users can click this button to display the next page of results.
Show Null As	Enter text that you want to display in the place of null values in your query results. For example, you can type a dash "-" or "null". Leave the text box blank if don't want to display any text in place of a null value.
Query Options	Choose one or more options for formatting your query results: Show SQL--Displays at the top of the results the SQL query that was used to create it. Display Results in Tables with Borders--Adds a border around the table containing your query results. Show Total Row Count--Displays at the bottom of your query results the total number of rows returned by the query. Count Rows Only--Displays only the total number of rows returned by your query. The query results do not display. Show HR between Rows--Displays a line between rows in the query results. Replace ASCII New Lines with HTML Breaks--If you display the query results as HTML-formatted text, OracleAS Portal substitutes the HTML tag, <br> , for every ASCII new line. This produces HTML-formatted results with the same line breaks as those formatted as ASCII text.

Additional Information

On Portal Center:

For more information go to the documentation section of Portal Center.

Locating this Page

To locate this page in OracleAS Portal:

On the Portal Builder page, click the Navigator link.
Click the Database Objects tab.
In the Name column, scroll down to the schema whose contents you want to view.
Click the schema's name.
In the Name column, scroll down to the table you want to update.
Next to the object, click Modify Rows to update the table.