On Monday, April 21, 2014 12:34:03 AM UTC-6, weird0 wrote: > > I was asked this question in an interview. > > For example, if you insert 10 records at the same time, and 9 records or > say half of them get inserted, but the remaining do not for some or the > other reason. It may be because the connection has broken down? So, how > would I handle the situation in the two cases? > > (i) i am using PL/SQL or any Db Querying tool > (ii) I dont have db querying tool. I want to re-insert them using > front-end interface. > > Any suggestions from the more experienced developers? > > > The answer depends as much on the interface as it does the release of Oracle in use; releases from 9i onwards support the MERGE statement, some in more robust forms than others. This is supposed to be an example of your creative thinking, not someone elses. How would YOU do it?
David Fitzjarrell -- -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en --- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To unsubscribe from this group and stop receiving emails from it, send an email to oracle-plsql+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.