Delete All prompt when deleting from SQL window

[damion]

I was wondering if there is a way to disable the prompt to acknowledge a Delete of all records from a table when in a SQL window. I'm in a SQL window and just type in "Delete from table_name" and execute that and the first thing that happens is a popup that asked "Are you sure you want to delete all records?". I don't want that prompt and was wondering if I could turn it off.

Thanks

 

[tcogill]

It's extra typing, but if you put "WHERE 1=1" on your statement, that pop-up will not appear.

 

[Marco Kalter]

In the upcoming 5.1.3 patch release you will only get this message once (if you confirm it) for the duration of the PL/SQL Developer session.

------------------
Marco Kalter
Allround Automations

 

[aotte]

If requiring an exclusive lock on the table is not a problem, which I assume it isn't, as we are deleting every single row, why not use:

TRUNCATE TABLE table_name REUSE STORAGE;

instead of

DELETE FROM table_name;

- Much faster on large tables
- No questions later, about validity of "missing" WHERE in delete code.
- Oh, and no pop-up

Just a thought.

------------------
Hakuna Matata,

Arnoud.

[This message has been edited by aotte (edited 09 July 2003).]