Data Types
Data Type:-Data types define the ways to identify the type of data and their associated operations.Types of Data Types :-There are 4 types of predefined data types explained as below
internal components.
Example:-
CHAR (fixed length character value between 1 and 32,767 characters)
VARCHAR2 (variable length character value between 1 and 32,767 characters)
NUMBER ( fixed-decimal, floating-decimal or integer values)
BOOLEAN ( logical data type for TRUE FALSE or NULL values)
DATE (stores date and time information)
LONG (character data of variable length)
2) Composite Data Types:- A composite data type is made up of other data types and
internal components that can be easily used and manipulated.
Example:- Record, Associate Array, Nested Table and Varray.
3) Reference Data Types: A reference data types holds values, called pointers that designate to other program items or data items.
Example:- %type, %rowtype
4) Large Object Data Types: A Large Object datatype holds values, called locators, that defines the location of large objects( such as video clips, graphic image) stored out of line.
Example:-
BFILE (Binary file)
BLOB (Binary large object)
CLOB ( Character large object)
NCLOB( NCHAR type large object)
-: Thanks for Visit Here :-
if you want some more advance Tools,software, Tricks Tips, Learn More about Technologies and learn Programming sites below listed. Learn Unix, Linux, Hacking Trick, tips and much more.
Visit Below listed sites,
===========
=======
Site : 1 : BluNetworks for advanced users
Site :3: Downlaod Music, Video etc.
.
0 Comments