Hi Aigles,

The script workinf fine if last filed is null and data also null(After col4) ,if any column data also null,its giving Error data type .For Instance for 2 column having null values ,when executing the script its giving Error data type.Is there any way to check only last field column name ,if column name exist and then no data set string 5o or if no column name and no data,consider upto col4.Your help is greatly appreciated.

Code:

col1|col2|col3|col4|
xxx| |10/08/2003|234506|
yyy| |12/03/2003|345678|

output

Code:

 
create table (col1 varchar2(50),
                  col2 Error!,
                  col3 date,
                  col4 number)

Regards,
MR