i am running an update query -query1 from sqlplus command prompt
that query is taking long it s running since 3 hours
so i want to cancel/stop that query and rerun another update query that updates the same column as query1 is updating and which is faster than query1...
so is it ok if i just cancel execution of query1 using Ctrl-C (more than 1 time if required)
and rerun the new query which is faster?
do i have to contact dba to cancel previous transactions or how do i quit running query1
Truncate is a DDL Command where as Delete is a DML Command.
Both will delete data from table, but what is the difference between these below statements
truncate table <table_name> ??
delete from <table_name> ??
The first command cannot be …
In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…