Home » SQL & PL/SQL » Client Tools » Newbie with Questions? (domain vs logical vs structured) datatypes ( SQL Developer Data Modeler)
Newbie with Questions? (domain vs logical vs structured) datatypes [message #643645] Wed, 14 October 2015 15:51 Go to next message
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
Re: Newbie with Questions? (domain vs logical vs structured) datatypes [message #643647 is a reply to message #643645] Wed, 14 October 2015 17:50 Go to previous messageGo to next message
BlackSwan
Messages: 26207
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

icon5.gif  Re: Newbie with Questions? (domain vs logical vs structured) datatypes [message #643648 is a reply to message #643647] Wed, 14 October 2015 19:01 Go to previous messageGo to next message
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
Re: Newbie with Questions? (domain vs logical vs structured) datatypes [message #643662 is a reply to message #643645] Thu, 15 October 2015 03:31 Go to previous messageGo to next message
gazzag
Messages: 993
Registered: November 2010
Location: Bristol, UK
Senior Member
This may help.
Re: Newbie with Questions? (domain vs logical vs structured) datatypes [message #643687 is a reply to message #643648] Thu, 15 October 2015 06:40 Go to previous messageGo to next message
EdStevens
Messages: 985
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.
Re: Newbie with Questions? (domain vs logical vs structured) datatypes [message #643740 is a reply to message #643687] Fri, 16 October 2015 10:01 Go to previous messageGo to next message
thatjeffsmith
Messages: 78
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.
Re: Newbie with Questions? (domain vs logical vs structured) datatypes [message #643754 is a reply to message #643740] Fri, 16 October 2015 19:05 Go to previous messageGo to next message
jperson19468
Messages: 3
Registered: October 2015
Junior Member
What about structured?

Thank You Smile
Re: Newbie with Questions? (domain vs logical vs structured) datatypes [message #643820 is a reply to message #643754] Mon, 19 October 2015 07:34 Go to previous message
thatjeffsmith
Messages: 78
Registered: July 2009
Location: Raleigh, NC
Member

structured would be like the SYS.XML_TYPE or SDO_GEOMETRY
Previous Topic: Problem with high ASCII characters in Oracle 11G
Next Topic: find error line in plsql code of more than 1 lakh lines.
Goto Forum:
  


Current Time: Sun Oct 21 23:25:59 CDT 2018