sql db data types code example

Example 1: database types

Relational Database =
-Tables are structured related to each other
-Each specific type of domain data is strored
 it's own table

Non-Relational Database =
-There is no relation at all between tables
-Mostly key+value pair : like jSon

Example 2: sql data types

• number(num) - whole numbers up to num digits
• number(num,num2) - num whole numbers up to num2 decimals
• char(num) - fixed length character/string
• varchar2(num) - used for varying length data
• date - full date
• currency - used for prices