I am trying to install Oracle 11g R2 on windows XP 64 Bit.
At the end of the installation i got a message to set environment variable ORACLE_UNQNAME to something unique and to run the command:
C:\app\Administrator\product\11.2.0\dbhome_1\BIN\emctl.bat start dbconsole
I have created system variable and ran the command. I got error message that there is OC4J Cnfiguration error (see attached)
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 …
How to Unravel a Tricky Query
If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them. …