dbxplorer

 Profile Answers by dbxplorer 

• Oct 10th, 2010

 

Hi Sugat,

For answer of your question, I start with little basic definition:

Database:
Its a collection of information, preferably related and organized.

And that information get stored through means of database object "Tables", which consists of Rows(Records,Tuples) and columns(Fields,Attributes).

Now here comes your question, DATA TYPE.
Every columns stores some specific type of data, that can be number,character,date etc.
Ex: NAME column should have name in characters, so its data type must be character type. That means NAME column is of charater datatype, will hold only value that is character.

Hope it willl help you.

Thanks,
Gtalk-: ankurlibra

pradeepnagaraja

 Profile Answers by pradeepnagaraja 

• Nov 18th, 2010

 

Different data type used in Oracle are number, char, varchar, varchar2, clob, blob, long.

MahanamShakyamuni

 Profile Answers by MahanamShakyamuni 

• Nov 19th, 2010

 

In SQL, there are mainly varchar2, char, number, date...then each of them has subtypes like number has integer, real etc..

Following
website gives all details:

For SQL datatypes refer:
http://download.oracle.com/docs/cd/B28359_01/appdev.111/b31228/ch3.htm#i1007684

For
PL/SQL datatypes refer:
http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28370/datatypes.htm