Home » SQL & PL/SQL » SQL & PL/SQL » Commit Process (10g,WIndows 10)
Commit Process [message #670201] Sun, 17 June 2018 08:06 Go to next message
Satheeshkumar.P
Messages: 4
Registered: June 2018
Location: Namakkal
Junior Member
IS IT ANY POSSIBLE ???
i am created the table and inserted the values after commit.Need to delete the values when i execute the commit
Re: Commit Process [message #670202 is a reply to message #670201] Sun, 17 June 2018 08:09 Go to previous messageGo to next message
Michel Cadot
Messages: 67303
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Just rollback instead of commit.

Re: Commit Process [message #670204 is a reply to message #670201] Mon, 18 June 2018 04:29 Go to previous message
gazzag
Messages: 1082
Registered: November 2010
Location: Bristol, UK
Senior Member
DELETE
FROM table_name
WHERE condition_of_inserted_rows;
Previous Topic: oracle large query text
Next Topic: Use multi-threading in PL/SQL
Goto Forum:
  


Current Time: Fri Aug 14 06:16:53 CDT 2020