Beispieltemplate

Firmen-Übersicht
<?start:body?>
Inhaltsverzeichnis
Kunden ....................................................................................................................................... 2
Account-Bereich <?ACCOUNT_MGR_ID?> ....................................................................... 2
Produkte ..................................................................................................................................... 3
Kategorie <?CATEGORY_ID?> ........................................................................................... 3
Mitarbeiter .................................................................................................................................. 4
Abteilung <?DEPARTMENT_NAME?> .............................................................................. 4
Kunden
group CUSTOMERS_ROW by ACCOUNT_MGR_ID
Account-Bereich <?ACCOUNT_MGR_ID?>
for-each current-group
CUSTOMER_ID
Kunden-Nr.
CUST_LAST_NAME, CUST_FIRST_NAME
Name
CUST_ADDRESS
Adresse
PHONE_NUMBERS
Telefon
CUST_EMAIL
Email
NLS_LANGUAGE
Sprache
Gebiet
CREDIT_LIMIT
Credit Limit
Lokation
Geburtstag
Familienstand
GENDER
Geschlecht
Einkommensbereich
end current-group
end CUSTOMERS_ROW by ACCOUNT_MGR_ID
NLS_TERRITORY
CUST_GEO_LOCATION
MARITAL_STATUS
INCOME_LEVEL
Produkte
group PRODUCTS_ROW by CATEGORY_ID
Kategorie <?CATEGORY_ID?>
for-each current-group
PRODUCT_ID
Produkt-Nr.
PRODUCT_NAME
Name
PRODUCT_DESCRIPTION
Beschreibung
CATALOG_URL
Katalog-URL
SUPPLIER_ID
Lieferant.
Status
LIST_PRICE
Listenpreis
Minimaler Preis
Gewichtsklasse WEIGHT_CLASS
Garantie
end current-group
end PRODUCTS_ROW by CATEGORY_ID
PRODUCT_STATUS
MIN_PRICE
WARRANTY_PERIOD
Mitarbeiter
for-each EMPLOYEES_ROW
Abteilung <?DEPARTMENT_NAME?>
Abteilungs-Nr.
Manager-Nr.
Lokations-Nr.
DEPARTMENT_ID
MANAGER_ID
LOCATION_ID
for-each EMPLfor-each EMPL_ROW
Miarbeiter-Nr. EMPLOYEE_ID
LAST_NAME, FIRST_NAME
Name
PHONE_NUMBER
Telefon
EMAIL
EMail
JOB_ID
Job-Nr.
Eingestellt am
SALARY
Gehalt
Provisionssatz
COMMISSION_PCT
end EMPL_ROWend EMPL
end EMPLOYEES_ROW
<?end body?>
erstellt am 30.12.2008
Seite 4 von 4