hi to all,
I have one excel sheet.That have 90 columns like(Name 1,Name 2,Name 3,Name 4,Name 5,Name_6,Name.7...etc).But in oracle i created column name are like Name1,Name2,Name3,Name4,Name5,...etc. so how can i insert excel to oracle. because in excel sheet column names coming (space,_ and . also).but in oracle table columns without space. So in which way is best to insert values.
Help me....
Thanks in advance...
sundaramoorthy