-

SQL Data Types
The SQL data type defines a kind of value that a column can contain.
In a database table, every column is required to have a name and a data type.

Data Type varies from database to database. For example, MySQL supports INT but Oracle supports NUMBER for integer values.


These are the general data types in SQL.

Data-type
Syntax
Explanation
Integer
INTEGER
The integer data type is used to specify an integer value.
Smallint
SMALLINT
The smallint data type is used to specify small integer value.
Numeric
NUMERIC(P,S)
It specifies a numeric value. Here 'p' is precision value and 's' is scale value.
Real
REAL
The real integer is used to specify a single precision floating point number.
Decimal
DECIMAL(P,S)
It specifies a decimal value. Here 'p' is precision value and 's' is scale value.
Double precision
DOUBLE PRECISION
It specifies double precision floating point number.
Float
FLOAT(P)
It specifies floating-point value e.g. 12.3, 4.5 etc. Here, 'p' is precision value.
Character
CHAR(X)
Here, 'x' is the character's number to store.
Character varying
VARCHAR2(X)
Here, 'x' is the character's number to store
Bit
BIT(X)
Here, 'x' is the number of bits to store
Bit varying
BIT VARYING(X)
Here, '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
The timestamp data type is used to store year, month, day, hour, minute and second values.
Time with time zone
TIME WITH TIME ZONE
It is exactly same as time but also store an offset from UTC of the time specified.
Timestamp with time zone
TIMESTAMP with TIME ZONE
It is same as timestamp but also stores an offset from UTC of the time specified.


Comments

Post a Comment

Most Viewed

Write C program to enter any year and check whether year is leap year or not using conditional/ternary operator.

-
C program to check leap year using Conditional/Ternary operator   C   ,   OPERATOR   ,   PROGRAM Write a C program to enter any year and check whether year is leap year or not using conditional/ternary operator (?:).     Required knowledge: Basic C programming,   Conditional operator,   Leap year condition   Leap year condition: If the year is   EXACTLY DIVISIBLE by 4   and   NOT DIVISIBLE by 100   then its LEAP YEAR   Else if the yea r is  EXACTLY DIVISIBLE 400  then its LEAP YEAR  Else its a COMMON YEAR  Program: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 /**  * C program to check leap year using conditional operator  */ #include <stdio.h> int   main() {     int   year;         /*   ...
Read more

WAP to input week number and print week day name.

-
C program to input number of week's day(1-7) and translate to its equivalent name of the day of the week You   will learn to calculate the week day name by using switch case in this example. #include<stdio.h> #include<conio.h> void main() { int ch; clrscr(); //to clear the screen printf(“Enter number of week’s day(1-7):”); scanf(“%d”,&ch); switch(ch) { case 1: printf(“nSunday”); break; case 2: printf(“nMonday”); break; case 3: printf(“nTuesday”); break; case 4: printf(“nWednesday”); break; case 5: printf(“nThursday”); break; case 6: printf(“nFriday”); break; case 7: printf(“nSaturday”); break; } getch(); //to stop the screen } Output: Enter Number of Week Days(1-7): 6 Friday
Read more

C Program to Find Third Angle of a Triangle

-
C Program to Find Third Angle of a Triangle ·                      Write a C program find third angle of triangle. Required Knowledge ·                      C printf and scanf functions ·                      C Arithmetic Operators We will first take two angles of a triangle as input from user using scanf function. To find the  third angle of triangle  we will use below mentioned angle sum property of a triangle. Sum of all internal angles of a triangle is 180 degrees. ·                      A + B + C = 180 Where A, B and C are the three internal angles of a tria...
Read more