I'm coming to oracle from postgresql. In postgresql, I can use the command-line tool, psql, to execute a delete or update in a transaction:
dbpool.production=> begin; BEGIN dbpool.production=*> delete from foo where account_id like '%1000%'; DELETE 9 dbpool.production=*> commit; COMMIT dbpool.production=>
I like to see that I got the count I expected before committing the transaction.
Things don't work like that in sqlplus, the Oracle command-line tool. When I type "begin;", it just starts reading more input, never apparently doing anything:
SQL> begin; 2 update opacs_work_orders set customer_id = null; 3 commit; 4
How can I, using sqlplus, execute one or more statements with a transaction?