Top "Oracle10g" questions

In SQL Server, you can do things like this: INSERT INTO some_table (...) OUTPUT INSERTED.* VALUES (...) So that you can …

I have developed a trigger that checks the validity of a date. It works fine because it prevents me from …

I have Oracle 10.5 installed on my system. I created a stored procedure using Toad. It is running successfully. I observed …

I am new to hibernate and I am stumped. In my database I have tables that have a columns of …

I have a backup.dmp file, which is backup file of my database built in oracle. please suggest me how …

I have an Oracle DB package that is routinely causing what I believe is an ITL (Interested Transaction List) deadlock. …

FREMOVE is failing with an error "ORA-29280: invalid directory path" It works fine when I add the path to the …

I have Oracle 10g installed on Windows. Currently, my tnsnames file is stored at %ORACLEHOME%\network\admin. However, I want …

I have two databases, one is production and second is a test. I want to export from production database and …

Is it possible to use VARRAY in IN CLAUSE of pl/sql?