Re: Help me design a table

Anoop wrote:
> I need to design a table with the following columns. It is a table
> that will be read by a 3rd party product which allows little
> customization. The columns would be something like these:
>
> id - primary key
> bank - non null (varchar(100))
> access - non null (varchar(100))

This looks like homework.
Smells like homework.
And tastes like homework.

I'd recommend you first of all do the following:

SELECT keyword
FROM gv$reserved_words
WHERE keyword LIKE 'I%';

followed by learning the correct names of Oracle data types.

Given that it is finals time at many colleges and universities ... See you instructor for help on this problem

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org