Database Reference
In-Depth Information
LINK_TARGET
specifies the object that is displayed when you click the link. For a
page link,
LINK_TARGET
is the page alias. For a file,
LINK_TARGET
is the file name
or alias. The only exception to this pattern is the
sql: LINK_TYPE
. The
sql:
LINK_TYPE
's
LINK_TARGET
isn't a link; it's a SQL statement that returns data in
rows and columns. The SQL data is automatically displayed when the page is dis-
played. The
sql:
syntax is also referred to as SQL tags, and this feature must be
turned on by an administrator in the application properties area. This is covered later in
the “Reports: Setup” section.
A vertical bar character separates
LINK_TARGET
and
LINK_NAME
. The only
fussy part of the syntax is the single spaces that must precede and follow the vertical
bar.
LINK_NAME
contains the text that is embedded in the page's content. The user
clicks this text to follow the link. There are two exceptions to this pattern. First, the
image LINK_NAME
is optional and can be replaced by HTML markup. For example,
you can use HTML markup to resize the image. Second, the
sql: LINK_TYPE
has
no
LINK_NAME
.
LINK_NAME
isn't required because the SQL data itself is automatic-
ally embedded in the page content.
The markup syntax is forgiving. It's case insensitive, and the websheet code makes
several friendly assumptions. For example, if you omit
LINK_TYPE
, the websheet
scans its metadata for
LINK_TARGET
. If an exact match is found, the websheet as-
sumes that this is the target for which you were looking. In other words, you can be a
bit sloppy with the syntax and still get the correct result.
User Authentication
User authentication governs how users log on to a websheet. There are four options:
•
Application Express Account
: Websheet users log on to the websheet by us-
ing the IDs and passwords that have been set up in the APEX workspace
that hosts the websheet.
•
Single Sign-On
: Oracle's single sign-on (SSO) technology enables users to
sign in to their computing environment one time and then access all their
applications, such as websheets, without having to re-enter their username
and password. This is an advanced feature that is out of scope for a begin-
ning book.