PDBase - Oracle Specific Commands

Accounts

To set up an account contact your local Oracle database administrator. This account should have "Create Table" write privileges and have read access privileges to the "PDB_DATA" tables.

Once you are able to log into your account, you should run the SQL script SynCreateMms.sql to create synonyms from your account to the tables in PDB_DATA. This is will reduce typing by allowing you to simply enter the table name without prefixing it with "PDB_DATA."

Text Commands

The command line interpreter for Oracle is sqlplus.

The following command lists all of the tables in your account:

> select * from cat ;

To list all of the indices in your account use the command:

> select * from user_indexes;

Information about a particular table can be listed in sqlplus with the command:

> describe <table_name>

For example the command:

describe ENTITY_POLY_SEQ;

Produces the output:

 Name                            Null?    Type
 ------------------------------- -------- ----
 ENTITY_POLY_SEQ_KEY             NOT NULL NUMBER(38)
 ENTRY_KEY                       NOT NULL NUMBER(38)
 ENTITY_ID                       NOT NULL VARCHAR2(256)
 ENTITY_KEY                               NUMBER(38)
 HETERO                                   VARCHAR2(256)
 MON_ID                          NOT NULL VARCHAR2(256)
 MON_KEY                                  NUMBER(38)
 NUM                             NOT NULL NUMBER(38)