Query

Displays the datatype for values in the Column.

• - DATE
• - NUMBER
• - RAW, LONG, ROWID, ORDIMAGE
• - VARCHAR, VARCHAR2, CHAR, NCHAR, NCHAR2

Choose an Oracle display format for columns containing date and number data types. For example, if you choose DD/MM/YY, the date January 2nd, 2000 displays as 02/01/00.

If you choose 999G999G999G999D99999999, the display format for numbers is 12 digits to ther left of the decimal point and 8 to the right.

Note: Refer to the Oracle documentation for additional information about formatting options.

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.

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.

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.

Choose a display format for query results:

• HTML--Formats the results using HTML tables and displays output on a new page in the web browser. database portlets that contain large amounts of data may take longer to display in this format.

• Excel--Downloads the results for display in Microsoft Excel.

• ASCII--Formats the results using the HTML PRE tag to display headings and values in the report as ASCII text. This option is useful for displaying large amounts of data.

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.

Choose columns whose values you want to sum and display in the query results.

Note: This list displays only columns containing numeric data.

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.