Any database experts - schema domain definitions?

[garynortheast]

As above, any advice gratefully received.
When defining a primary key can I use varchar2 or does it need to be character with a defined range?
Thanks in advance.....

[Fluffer]

Can indeed use a varchar2 as a pk - just so long as you have a way of ensuring stuff is unique when inserting you'll be pukka... Otherwise just messy dealing with constraint violations etc when compared to using an oracle sequence or sql server identity... Hth

Sent from my GT-I9100 using Tapatalk

[garynortheast]

Lovely job, thanks for the answer.

When I finish this database module I hope never to have to deal with another database! :-(