Migrating from 8.16 to 9.2. I have a VB COM object calling a procedure that returns a dynamic cursor. It works fine in 8.16 but throws ORA-01023 error when we try it in 9.2. Any help would be appreciated.
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…