#DBMS

SQL – Datatypes and their syntax

by

DATATYPES: 1.CHAR DATATYPE: SYNTAX: char(size); EXAMPLE: char(10); A L E X A Here in the above example, Alexa used the 5 memory blocks and the remaining is unused memory blocks. Note: VARCHAR DATATYPE: SYNTAX: varchar(size); A L E X A NOTE: VARCHAR2 DATATYPE: SYNTAX: varchar2(size); A L E X A NOTE: NUMBER DATATYPE: SYNTAX: Number(precision,[scale]); … Read more