OraFAQ Forum: Client Tools » Newbie with Questions? (domain vs logical vs structured) datatypes

Home » SQL & PL/SQL » Client Tools » Newbie with Questions? (domain vs logical vs structured) datatypes ( SQL Developer Data Modeler)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Newbie with Questions? (domain vs logical vs structured) datatypes [message #643645]

Wed, 14 October 2015 15:51

jperson19468
Messages: 3
Registered: October 2015

Junior Member

Just a couple of questions.
1) What is a good definition of a domain? (I searched for one and could not find a clear definition)
2) I believe logical are just your normal datatypes? (normal as define data) Please correct if I am wrong
3) On the Entity Properties Screen:
Under General Attributes:
Under Attributes Properties:
There are there three datatypes:
1. Domain
2. Logical
3. Structured
4) What is the difference between them and when should I use them?

Thank You Smile

Report message to a moderator

Re: Newbie with Questions? (domain vs logical vs structured) datatypes [message #643647 is a reply to message #643645]

Wed, 14 October 2015 17:50

BlackSwan
Messages: 26757
Registered: January 2009
Location: SoCal

Senior Member

Welcome to this forum

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read

Report message to a moderator

Re: Newbie with Questions? (domain vs logical vs structured) datatypes [message #643648 is a reply to message #643647]

Wed, 14 October 2015 19:01

jperson19468
Messages: 3
Registered: October 2015

Junior Member

This is not code. This is plain text. I just have a couple of questions that I would like to have answered.

Thanks

Report message to a moderator

Re: Newbie with Questions? (domain vs logical vs structured) datatypes [message #643662 is a reply to message #643645]

Thu, 15 October 2015 03:31

gazzag
Messages: 1091
Registered: November 2010
Location: Bedwas, UK

Senior Member

This may help.

Report message to a moderator

Re: Newbie with Questions? (domain vs logical vs structured) datatypes [message #643687 is a reply to message #643648]

Thu, 15 October 2015 06:40

EdStevens
Messages: 1293
Registered: September 2013

Senior Member

jperson19468 wrote on Wed, 14 October 2015 19:01

This is not code. This is plain text. I just have a couple of questions that I would like to have answered.

Thanks

The reference to code tags was just standard boiler-plate response for newcomers. Just make note of it for future reference.

Report message to a moderator

Re: Newbie with Questions? (domain vs logical vs structured) datatypes [message #643740 is a reply to message #643687]

Fri, 16 October 2015 10:01

thatjeffsmith
Messages: 81
Registered: July 2009
Location: Raleigh, NC

Member

Domains are something you create for consistency. So if you have an attribute for 'name' and you want to standardize names as 128 character strings - you could create a domain entry for name.

Otherwise if you go with logical, you choose the type each and every time, which leads to the same types of information (addresses, zipcodes, phone numbers) all being stored/described differently.

Report message to a moderator