![]() ![]() This datatype will define fixed length but the actual length of the string will be the length of the value i.e. 32767 bytes VARCHAR2 This is also similar to CHAR, where strings are stored. 32767 bytes CHARACTER This is same as CHAR, and both are used alternatively. There are different subtypes in this character datatype depending on the storage space and length of the data to be stored.ĬREATE TABLE STUDENT (STD_NAME CHAR (15), ADDRESS VARCHAR2 (50)) ĭatatype Sub-Datatype Description Storage Character Data Type CHAR Used to store fixed length of string or value. There are four types of Scalar datatypes – Character, Numeric, Date/Time and Boolean.Ĭharacter Data type: –This type of datatype is used to store alpha-numeric values like alphabets as well as numbers and special characters. This is one of the mechanisms to maintain the domain constraint of a column. This restricts the user while they try to insert any other values other than number. We cannot insert any date or alphabets into it. These datatypes are used to store the numeric column values or numeric variables. This is can be considered as composite datatype too. They define new datatypes to ease their coding. User Define data types : – these datatypes are defined by the developer while coding using the above base datatypes.Unknown Column types : – when column types are not known, this datatype is used.LOB data types : – Used to store large objects like images, videos etc.Reference data types : – Used to store the information about another datatype.Composite data types : – It is combination of other datatypes usually scalar datatypes. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |