HOME UP

CERA Software (SQL and Other)

This point branches to different directories mainly containing SQL scripts for CERA-2.5.
They are grouped into the basic CERA, some useful views, and scripts (SQL and Unix) for handling the hierarchical Tables TOPIC and LOCATION. Furthermore, basic CERA splits into data definition language (DDL) and SQL tools.
Mind the ORACLE dialect in statements as create table...TABLESPACE..., create/drop synonym, create/drop sequence and in expressions like SYSDATE.
The structure of the CERA-2 table names and view names is described in "Name_Structure".

Change of versions:
Effective from 2001-03-29 some contents of the directories BASE_TOOLS and VIEWS have been moved to the Graveyard.

BASE_DDL

Pages are optimized for NETSCAPE. For comments and suggestions contact CERA Admin.

Last change: Sat Mar 31 00:13:58 NFT 2001