Top "Oracle" questions

Solution to "cannot perform a DML operation inside a query"?

I am using a Data Analysis tool and the requirement I have was to accept a value from the user, …

sql oracle function stored-procedures plsql

Old SQL History in Oracle SQL Developer

In SQL Developer, i was finding some SQL commands of previous month but not able to find that as it …

oracle oracle-sqldeveloper

How to clear a queue in Oracle AQ

I've been testing Oracle AQ for the first time. I have managed to create 2000 rows of test inserts into the …

oracle queue jms oracle-aq

How to grant execute on dbms_lock in Oracle?

I need to use dbms_lock.sleep procedure from user usr1. I can't login as sys, but I have a …

oracle privileges

Get top results for each group (in Oracle)

How would I be able to get N results for several groups in an oracle query. For example, given the …

sql oracle greatest-n-per-group

How do I test if a column equals empty_clob() in Oracle?

The naïve FOO = empty_clob() complains about incompatible types. I tried Googling, but (once again) had little success searching …

oracle clob

Oracle connection string without tnsnames.ora file

I am using the .NET framework with the System.Data.OracleClient namespace. I have the oracle 11 client installed on my …

.net asp.net oracle connection-string oracleclient

jboss 7 oracle datasource configuration

I'm currently migrating from jboss 4.3 to jboss 7.1.1 (Final) and i'm trying to configure an oracle datasource but it's not working. …

oracle datasource jboss7.x

Auto Increment for Oracle

I need to create a sequence and a trigger to auto-increment the primary key on a table but I have …

oracle oracle11g

Escape ampersand in PL/SQL Developer

I'm trying a simple INSERT statement against an Oracle database. One of the values is a VARCHAR2 field and the …

oracle escaping special-characters plsqldeveloper