You can insert comments directly into your SELECT
statement using
Oracle's standard SQL comment delimiters (for example, /* comment */
).
Refer to your Oracle Server SQL Language Reference Manual.
Note: You can also set the Comment property for the query to enter comments.
FROM
clause.
If you create a query that uses a lexical reference for the FROM
clause, the parameter corresponding to the lexical reference must have an
Initial Value (for example, EMP
) so that the SELECT
statement
is valid.
AVG_SAL
is a summary column that computes the
average salary for each page of your report, the following bind reference
would be invalid:
SELECT SAL FROM EMP
WHERE SAL > :AVG_SAL
G_1
contains a database
column named SAL
and belongs to query Q_1
. Group
G_1
owns another query named Q_2
. You could reference
SAL
in Q_2
but not in Q_1
.
SUM_SAL
in group G_1
. SUM_SAL
summarizes the column named SAL
, which is also in group G_1
.
G_1
belongs to query Q_1
and owns another query
named Q_2
. Therefore, query Q_1
can contain a reference
to SUM_SAL
, but query Q_2
cannot contain such a
reference.
TO_DATE
function should be used.
Copyright © 1984, 2005, Oracle. All rights reserved.