Member Avatar for shwetha.marigowda

i want block of code,, that deletes data from different table concurrently,, so that i can save time

  • 2 Contributors
  • 1 Reply
  • 119 Views
  • 2 Hours Discussion Span
  • Latest Post Latest Post by urtrivedi
Member Avatar for urtrivedi

you can create procedure in backend

delete from a;
delete from b;
delete from c;
commit;

Put that code in proper oracle procedure syntax, also make sure sequence of table must also according to the foreign key relation among them. I mean delete detail table first then master afterwards.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.