ADABAS D Reference/ORACLE

Top Level

Ordering the Manual

 

• Introduction

 

• Introduction

 

• Concepts

 

• Data Type

 

• Data Type

 

• Character String

 

• LONG Column

 

• Number

 

• Date Value

 

• Parameter

 

• Parameter

 

• Table

 

• Table

 

• Column

 

• Column

 

• Index

 

• Index

 

• Synonym

 

• Synonym

 

• User and Usergroup

 

• User and Usergroup

 

• Privilege

 

• Privilege

 

• Database

 

• Database

 

• Distributed Database

 

• Distributed Database

 

• Transaction

 

• Transaction

 

• Subtransaction

 

• Subtransaction

 

• Session

 

• Session

 

• Data Integrity

 

• Data Integrity

 

• Snapshot Table

 

• Snapshot Table

 

• Backup and Recovery Concept

 

• Backup and Recovery Concept

 

• SQLMODE

 

• SQLMODE

 

• Code Tables

 

• Code Tables

 

• Common Elements

 

• <character

 

• <literal

 

• <token

 

• Names

 

• <column spec

 

• <parameter spec

 

• Specifying Values

 

• <function spec

 

• <function spec

 

• <arithmetic function

 

• <trigonometric function

 

• <string function

 

• <date and time function

 

• <special function

 

• <conversion function

 

• <set function spec

 

• <set function spec

 

• <expression

 

• <expression

 

• <arithmetic expression

 

• <datetime expression

 

• <predicate

 

• <predicate

 

• <between predicate

 

• <comparison predicate

 

• <exists predicate

 

• <in predicate

 

• <join predicate

 

• <like predicate

 

• <null predicate

 

• <quantified predicate

 

• <rownum predicate

 

• <search condition

 

• <search condition

 

• SQL Statement

 

• SQL Statement

 

• Data Definition

 

• Data Definition

 

• <create table statement

 

• <create table statement

 

• <column definition

 

• <constraint definition

 

• <referential constraint definition

 

• <key definition

 

• <unique definition

 

• <drop table statement

 

• <drop table statement

 

• <alter table statement

 

• <alter table statement

 

• <add definition

 

• <modify definition

 

• <create synonym statement

 

• <create synonym statement

 

• <drop synonym statement

 

• <drop synonym statement

 

• <create snapshot statement

 

• <create snapshot statement

 

• <drop snapshot statement

 

• <drop snapshot statement

 

• <create snapshot log statement

 

• <create snapshot log statement

 

• <drop snapshot log statement

 

• <drop snapshot log statement

 

• <create view statement

 

• <create view statement

 

• <drop view statement

 

• <drop view statement

 

• <create index statement

 

• <create index statement

 

• <drop index statement

 

• <drop index statement

 

• <create sequence statement

 

• <create sequence statement

 

• <drop sequence statement

 

• <drop sequence statement

 

• <oracle ddl statement

 

• <oracle ddl statement

 

• <comment statement

 

• <comment statement

 

• Authorization

 

• Authorization

 

• <create user statement

 

• <drop user statement

 

• <grant statement

 

• <revoke statement

 

• Data Manipulation

 

• Data Manipulation

 

• <insert statement

 

• <update statement

 

• <delete statement

 

• <truncate statement

 

• Data Retrieval

 

• Data Retrieval

 

• <query statement

 

• <query statement

 

• <query expression

 

• <query spec

 

• <table expression

 

• <table expression

 

• <from clause

 

• <where clause

 

• <group clause

 

• <having clause

 

• <subquery

 

• <subquery

 

• Correlated Subquery

 

• <order clause

 

• <order clause

 

• <update clause

 

• <update clause

 

• <open cursor statement

 

• <open cursor statement

 

• <fetch statement

 

• <fetch statement

 

• <close statement

 

• <close statement

 

• <single select statement

 

• <single select statement

 

• Transactions

 

• Transactions

 

• <connect statement

 

• <commit statement

 

• <rollback statement

 

• <rollback to statement

 

• <savepoint statement

 

• <lock statement

 

• <release statement

 

• System Tables

 

• System Tables

 

• Restrictions

 

• Restrictions

 

• Differences

 

• Introduction

 

• Program-relevant Differences

 

• Differences in the Database Management

 

• Error Messages

 

• Error Messages

 

• Syntax

 

• Syntax