Computation Types

The following explanations include syntax samples for each computation type.  The examples show text that could be entered into the Computation text area for the computation attributes.

• Static Assignment:   This computation type will enter the text value for the page item to be set.

Example:

Copyright 2006 

Example (with space between items):

 &P100_FIRST_NAME. &P100_LAST_NAME.

PL/SQL Function Body:   This computation type allows a PL/SQL function to be written that returns a value.  The page item will be set to the value returned from the PL/SQL function.

Example:

declare
   s_full_name  varchar2(100);
begin
   for r in (
      select first_name, last_name
      from   conference_rsvp
      where  id = 8 )
   loop
      s_full_name :=
         r.first_name || ' ' || r.last_name;
   end loop;
   return s_full_name;
end;

SQL Query:   The value returned from the SQL query will be used to set the page item value.

Example:

select first_name || ' ' || last_name
from   conference_rsvp
where  id = 8;

SQL Expression and PLSQL Expression:   These two expressions produce the same results.  They take the results of the expression and set the page item value.

Example:

:P100_FIRST_NAME || ' ' || :P100_LAST_NAME

Item Value:   This will set the value of one page item to the same value of another page item.

Example:

P100_FIRST_NAME