![]() ![]() This exception can also be raised by an element which is uninitialized in an index-by table. ![]() NO_DATA_FOUND: This exception is thrown by PL/SQL if either a SELECT statement fetches no rows or a program points to an element that is deleted in a nested table.This exception is normally raised if a key is of type PLS_INTEGER range and the subscript resides beyond this range. VALUE_ERROR: This exception is thrown if a subscript cannot be converted to the key type or is NULL.Some of the common collection exceptions are as follows: Gives end index number in collection with integer subscript.ĭeletes an element from the end of collection.ĭeletes m elements from the end of collection.ĭeletes all elements from collection, setting count to 0.ĭeletes mth element from collection, if mth element is NULL, then no action is performed.ĭeletes element from mth to kth position.Īdds m copies of the kth element to the end of collection. Gives start index number in collection with integer subscript. Returns true if mth element present in the collection else returns false. We will examine each data type in detail in the next tutorials.Gives the number of elements present in the collection. In this tutorial, you have learned about the brief overview of SQL Server data types. Store a result set temporarily for processing at a later time Store ellipsoidal (round-earth) data, such as GPS latitude and longitude coordinates. Represent data in a flat coordinate system. Store XML data in a column, or a variable of XML type Represent a tree position in a tree hierarchy The actual length of data entered + 2 bytesįor variables or stored procedure OUTPUT parameter that contains a reference to a cursorĮxpose automatically generated, unique binary numbers within a database. The binary data types stores fixed and variable length binary data. Unicode character string data types store either fixed-length (nchar) or variable-length (nvarchar) Unicode character data. The text data type can store non-Unicode data in the code page of the server. Character strings data typesĬharacter strings data types allow you to store either fixed-length (char) or variable-length data (varchar). In addition, the time, datetime2 and datetimeoffset have more seconds precision and datetimeoffset supports time zone. Because these types align with the SQL Standard and more portable. If you develop a new application, you should use the time, date, datetime2 and datetimeoffset data types. The date and time data types store data and time data, and the date time offset. They are often used in scientific calculations. The approximate numeric data type stores floating point numeric data. ![]() The following table illustrates the characteristics of the exact numeric data types: Data Type
0 Comments
Leave a Reply. |