what will be the data type used for email address innthe table creation
i think varchar should be fine for email address...
You can make varchar. But see the precision is high enough to accomodate long email addresses :).
Here is one sample record
INSERT INTO <table_name> VALUES ('ABC0HYD','ABC','2009-11-26','HYDERABAD','040',91,123456789,'IND','SAMPLE@XYZ.com',750000);
Thanks every one for your inputs.