These are the general data types in SQL:

DATA TYPE | SYNTAX | EXPLANATION |
---|---|---|

Integer | INTEGER | integer number. |

Smallint | SMALLINT | small integer number. |

Numeric | NUMERIC(P,S) | where 'p' is precision value and 's' is scale value. |

Real | REAL | single precision floating point number |

Decimal | DECIMAL(P,S) | where 'p' is precision value and 's' is scale value. |

Double precision | DOUBLE PRECISION | double precision floating point number |

Float | FLOAT(P) | where 'p' is precision value |

Character | CHAR(X) | where 'x' is the character's number to store |

Character varying | VARCHAR2(X) | where 'x' is the character's number to store |

Bit | BIT(X) | where 'x' is the number of bits to store |

Bit varying | BIT VARYING(X) | 'x' is the number of bits to store (length can vary up to x) |

Date | DATE | it stores year, month and days values. |

Time | TIME | it stores hour, minute and second values |

Timestamp | TIMESTAMP | it stores year, month, day, hour, minute and second values |

Time with | TIME WITH | exactly same as time but also store an offset from UTC |

time zone | TIME ZONE | of the time specified |

timestamp with | TIMESTAMP WITH | same as timestamp but also stores an offset from UTC of |

time zone | TIME ZONE | the time specified. |

© 2018 BreakInerview