Re: simple PL/SQL Question: deleting repeated rows

Pardon me, but your question is totally crazy...looks like you just started with database period.
First are we really talking about a one ROW table ? or a one COLUMN table ?

I assume you mean one column (to keep my sanity)...well in this case your question is *irrelevent* (ie don't make sense) Rows in relational database are not returned in any specific order. so theoratically tomorrow your result could be.... B
C
B
A
B

So you really want the "repetition" that you are seeing on your screen (right now) DELETED ?
This is not a real life task you're required to do, is it ?

Now if you really mean "NOT DISPLAY" then it only take a tiny procedure/function.

RC

Mario Christ wrote in message ...
>Hi,
>
>I am just starting with PL/SQL. Maybe someone can help solving a very
>simple problem.
>
>suppose you have the following table (one row only):
>
>ROW1
>A
>B
>B
>C
>B
>
>how do I delete the repetitions? The table I want to get would be:
>ROW1
>A
>B
>C
>B
>
>
>thank you in advance,
>Mario Christ, Berlin
Received on Fri Mar 29 2002 - 17:39:41 CST