I have installed TOAD to my pc and have all connection environment setup to the oracle db.
At point of login to the database, this is the error that I get:
OCI.DLL - The specified module could not be found.
A search thru my disk shows that I have OCI.DLL in \oracle\ora90\bin
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 …
Working with Network Access Control Lists in Oracle 11g (part 2)
Part 1: http://www.e-e.com/A_8429.html
Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access. For many…