I want to determine if a resultset exists very quickly. At the moment, I'm doing a count - this is taking roughly 55ms, which is unfeasable.The table has ~100k records - I don't care if it has 2, 5, ...

I've been using sysdate to time procedures, but a lot of my procedures are very small procedures that get called thousands of times.
Is there a way to get milliseconds elapsed instead of seconds? I ...

Due to needing some complex data manipulation and not being able to use PHP, I crafted a procedure (not stored, it's just run when we run the query) in Oracle to manipulate the data and store it in an ...

What is an Oracle ASSEMBLY, in the context of Oracle SQL?
It's listed in GV$SQLCOMMAND. Although GV$SQLCOMMAND is not a perfect guide to "real" SQL statements - for example it has UPSERT instead of ...

I need to optimize the following pl/sql procedure. So, fundamentally my question is: There is a way you can do a bulk insert in a pl/sql that could be more efficient than loop through an associative ...

I need to make packages for Oracle 10g that can be changed while users are still logged in an using an application that makes database calls through PL/SQL. Unfortunately, anytime a package is updated ...

For a performance testing application we need to have lot more data in our tables than what we have now. How do I duplicate the data in a table.
In the process of duplicating I also need to set new ...

I have multiple views with union like this:
select column1, column2 from mytable
union
select cast(extcol as nvarchar2(15)), cast(extcol2 as nvarchar2(10)) from exttable
But later I change the size ...

I've encountered a very interesting problem that I can't figure out how to fix. I have a package that I wanted to create on my database with a wrapped body. I mistakenly omitted the word "BODY" from ...

Does alter trigger hang if a table is locked by some DML operation
?
What kind of exception does it throw? Resource busy 0054 or some other exception...? I have tried to reproduce this scenario but ...

I have been tasked with allowing developers to kill their own sessions in the Development database. I've written a procedure, but for some reason I'm getting PL/SQL: ORA-00942: table or view does not ...

I am having a problem in Oracle rollback.
In my stored procedure I have multiple insert and update statements.
If every thing is fine I am sending success message and also I am tracing success status ...

As a DBA - assuming my users are knowledgeable with PLSQL and SQL - why would I not grant my users privileges to compile and run their own PLSQL code. We have an MI database environment where the data ...

As a DBA - assuming my users are knowledgeable with PLSQL and SQL - why would I not grant my users privileges to compile and run their own PLSQL code.
We have an MI database environment where the data ...

Background:
I've used a few Oracle articles to develop an error package, with some procedures. One of these is Log_And_Return which is called throughout the database. I've simplified it for brevity, ...

I am getting ORA-01410 and ORA-06512
for the following block of code in a trigger im firing for deletion of a record in my table.
Are the calls correct ?
getlong ('xxx', 'YYY', :OLD.ROWID),
getlong ...

I cannot connect to my database as admin, even using connect descriptor neither via RMAN. I am getting TNS-12514 error.
I consider to install new instance.
Questions:
1) Can I restore/recover PLSQL ...

Can SQL loader be used to do bulk updates?
I have a table that holds customer information. The table has a primary key and it has 5 columns pertaining to the customer. Now we created three more new ...