Re: select/insert/delete

You did not give us the reason you needed the select part in your single statement. Do you have actual reasons for being stuck with your current tables? I am not saying you should change your interface of a and b tables to the application. Just change the tables to views. Did you notice I was inserting through a view? Edition based redefinition is also using kind of such approach. Se editioning views http://download.oracle.com/docs/cd/E11882_01/appdev.112/e17125/adfns_editions.htm#ADFNS020 Well, possiby you can find a good enough reason not to use this update approach. This was a nice question, made me think of modeling and combine several ideas.

Timo Raitalaakso
http://rafudb.blogspot.com

8.6.2011 19:24, Michael Moore wrote:
> I'm pretty much locked into the two table design. There are existing
> tables with a lot of code that depends on them being just the way they
> are. I can't add columns, views, partitions etc. These are not options
> for me.
>
> insert into a (n) values (1);
>

--
http://www.freelists.org/webpage/oracle-l