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
Messages: 4
Registered: June 2018
Location: Namakkal
Junior Member
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: 67370
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
Messages: 1082
Registered: November 2010
Location: Bristol, UK
Senior Member
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: Mon Sep 28 17:59:36 CDT 2020