Re: QUERY QUESTION

From: Sybrand Bakker <sybrandb_at_hccnet.nl>
Date: Fri, 22 Oct 2004 12:23:53 +0200
Message-ID: <7rnhn0hbifabesurmvktmlotu5bf7iorp8@4ax.com>

On Fri, 22 Oct 2004 11:55:12 +0300, "agis" <stag_at_hq.acn.gr> wrote:

>Hi to all,
>
>I have a table like the below :
>
>val1 val2 val3
>--------------
>81 1 121564
>81 2 5616516
>81 3 15/07/03
>81 4
>81 5 checked
>81 6
>81 9 checked
>81 10
>81 11 checked
>81 12
>81 13 checked
>81 14
>81 15 checked
>81 17
>81 18 checked
>81 19
>81 20
>81 23 12
>81 24
>82 1 1654
>82 2 4564
>82 3 16/07/03
>82 4 checked
>82 5 checked
>82 6 checked
>82 9
>82 10
>
>and i want a query to have the following result set :
>
>81 121564 5616516 15/07/03....
>82 1654 4564 .....
>.....
>
>I dont need to saw val2
>
>Can anyone help with this ?
>
>Thanks
>
>
>
>

You need a PL/SQL procedure for this purpose, you can't resolve it with ordinary SQL. Examples of this kind of procedure have already been posted several times!
What, if anything, did you accomplish prior to posting this question?

--
Sybrand Bakker, Senior Oracle DBA

Received on Fri Oct 22 2004 - 05:23:53 CDT