Re: How to write this sql urgent...

create table AA
(

  C_1 VARCHAR2(50) not null,
  C_2 VARCHAR2(4000) not null,
  C_3 VARCHAR2(4000),
  C_4 VARCHAR2(4000)

insert into table aa values (1, code1, null, null);
insert into table aa values (1, code2, null, null);
insert into table aa values (2, code3, null, null);
insert into table aa values (2, code5, null, null);

create table AAA
(

  C_1 VARCHAR2(50) not null,
  C_2 VARCHAR2(4000) not null,
  C_3 VARCHAR2(4000),
  C_4 VARCHAR2(4000)

insert into table aa values (code1, 5.5, null, null);
insert into table aa values (code2, 3.5, null, null);
insert into table aa values (code3, 0.00, null, null);
insert into table aa values (code4, 0.00, null, null);
insert into table aa values (code5, 0.00, null, null);