Re: How to write this sql urgent...

From: ddf <oratune_at_msn.com>
Date: Mon, 25 Jan 2010 14:23:31 -0800 (PST)
Message-ID: <a6f80792-cb53-4ea7-a7c3-ac6b2a7ac368_at_b2g2000yqi.googlegroups.com>

On Jan 25, 12:34 pm, JIACHENG SUN <sun..._at_googlemail.com> wrote:
> right..
>
> 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);

If this is so 'urgent' why will you not provide sufficient information to allow people to offer useable advice? You don't submit a working set of insert statements nor do you make the slightest effort to create suitable test data, yet you expect those here to mystically read your mind from the text in your original post and know, without a doubt, what concepts and requirements you're attempting to convey. You've even said the actual problem is far more complex than the 'example' you've given us. If your example doesn't even resemble reality how can you expect a usable solution to be found?

David Fitzjarrell Received on Mon Jan 25 2010 - 16:23:31 CST