![]() As a SQL developer, you need to know which data types are supported by database you use or refer below to know!! ORACLE DATATYPESĪ simple representation of the data types present in ORACLE Database is shown below. N ote: “Not all the data types are compatible with every relational database in existence”. In this tutorial, you get to learn various SQL Data types that can be used for popular databases such as Oracle, MYSQL, SQL Server and Microsoft Access. Integer Datatype! DATA TYPES IN SQL: SQL Server, Oracle, MySQL, MICROSOFT ACCESS Suppose you want to store all the phone numbers, what would you choose? Yes, right. ![]() For instance, you want to create a table and have a column that will store all the names of students in your class then based on this requirement you choose CHARACTER or STRING datatype. A Datatype can be defined as “ Type of the value that is stored in a column of a table”.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |