Re: Oracle Hackers

I have not tried this but it may work:

update table table_name set <3> = '14/12/94/ where <3> is NULL;

insert into table_table_name values (select max(<1>)+1 from table_name), 'a', NULL);

<1>, <3> are your column names.

Best regards,

Toni

In article <3co21i$8rd_at_master.di.fc.ul.pt>, barreto_at_master.di.fc.ul.pt (Joao Barreto Fernandes) wrote:

> Oracle Hackers all over the world .
>
> Imagine that one of my tables looks like this:
>
> 1 a 12/12/94
> 2 a 13/12/94
> 3 a NULL
>
> and I wanted to insert (4,a) and the SYSDATE is 14/12/94.
> The result I want is
>
> 1 a 12/12/94
> 2 a 13/12/94
> 3 a 14/12/94
> 4 a NULL
>
> Can anyone give me a solution on how to do this.
> If you can , please help me.
> Thanks in advance, Joao Fernandes.
>
> PS. One can use whatever techniques he wants, but please explain it.
>
>
> --
> # Joao Carlos de Oliveira Barreto Fernandes #
> # e-mail : barreto_at_master.di.fc.ul.pt #
> # <a href=http://www.di.fc.ul.pt/~barreto> </a> #

+--------------------------------------------------------------------+
| Anton Dischner, DBA and system-programmer    Phone: +49 89 70953202|
| Institut fuer Klinische Chemie               Fax  : +49 89 70958888|
| Klinikum Grosshadern                         Home : +49 89 6254060 |
| Ludwig Maximilians Universitaet Muenchen     Handy: +49 172 8388880|
| 81366 Muenchen                                                     |
| Marchioninistr. 15                                                 |
| Germany                          Mail: dischner_at_med.uni-muenchen.de|
+--------------------------------------------------------------------+