Thursday June 6 2002 11:23 AM

Object Listing for User SCOTT

Table Name:

ACCOUNT

Tablespace:

USERS

Comment:

These are the account numbers and balances

Default Value

Column Name

Data Type

Null?

Comments

1

BALANCE

NUMBER

2

ACCOUNTNO

NUMBER

3

DATE_CREATED

DATE

The date and time this record was created in the database.

Indexes

Index Name

Unique?

Column Name

Pos

ACCOUNTNO_PK

UNIQUE

ACCOUNTNO

1

Triggers

Trigger Name:

ACCOUNT_TRG

CREATE OR REPLACE TRIGGER account_trg before insert on account for each row

begin if :new.date_created is null then :new.date_created := SYSDATE; end if; end;

Table Name:

BONUS

Tablespace:

USERS

Comment:

Default Value

Column Name

Data Type

Null?

Comments

1

ENAME

VARCHAR2(10)

2

JOB

VARCHAR2(9)

3

SAL

NUMBER

4

COMM

NUMBER

Indexes

Index Name

Column Name

Pos

Unique?

Triggers

Table Name:

DEPT

Tablespace:

USERS

Comment:

Default Value

Column Name

Data Type

Null?

Comments

1

DEPTNO

NUMBER(2,0)

NOT NULL

2

DNAME

VARCHAR2(14)

3

LOC

VARCHAR2(13)

Indexes

Index Name

Unique?

Column Name

Pos

PK_DEPT

UNIQUE

DEPTNO

1

Triggers

Table Name:

EMP

Tablespace:

USERS

Comment:

This stored information about each employee

Default Value

Column Name

Data Type

Null?

Comments

1

EMPNO

NUMBER(4,0)

NOT NULL

2

ENAME

VARCHAR2(10)

Page 1

---

Thursday June 6 2002 11:23 AM

Object Listing for User SCOTT

Table Name:

EMP

Tablespace:

USERS

Default Value

Column Name

Data Type

Null?

Comments

3

JOB

VARCHAR2(9)

4

MGR

NUMBER(4,0)

5

HIREDATE

DATE

6

SAL

NUMBER(7,2)

7

COMM

NUMBER(7,2)

8

DEPTNO

NUMBER(2,0)

Indexes

Index Name

Column Name

Pos

Unique?

PK_EMP

UNIQUE

EMPNO

1

Triggers

Table Name:

RECEIPT

Tablespace:

USERS

Comment:

Default Value

Column Name

Data Type

Null?

Comments

1

NEXTRECEIPT

NUMBER

Indexes

Index Name

Unique?

Column Name

Pos

Triggers

Table Name:

SALGRADE

Tablespace:

USERS

Comment:

Default Value

Column Name

Data Type

Null?

Comments

1

GRADE

NUMBER

2

LOSAL

NUMBER

3

HISAL

NUMBER

Indexes

Index Name

Column Name

Pos

Unique?

Triggers

Views

View Name:

V_ACCOUNT_BALANCE_OWED

select "BALANCE","ACCOUNTNO" from account where balance>0

Synonyms

Synonym Name

Table Owner

Table Name

DB Link

MY_ACCOUNT

SCOTT

ACCOUNT

Sequences

Cycle Flag

Order Flag

Cache Size

Sequence Name

Min Value

Max Value

Increment By

Last Number

ACCOUNTSEQ

1

1

N

N

20

1

Packages

Page 2

---

Thursday June 6 2002 11:23 AM

Object Listing for User SCOTT

Functions

Function Name:

F_ACCOUNT_BAL

function f_account_bal(acctno in number) return number

is

x number;

begin

select balance into x from account where accountno=acctno;

exception

when NO_DATA_FOUND then

return(to_number(NULL));

end;

Procedures

Page 3

---