Top "Oracle" questions

My error: java.sql.SQLException: Listener refused the connection with the following error: ORA-12516, TNS:listener could not find available …

How do I add a simple check before adding a column to a table for an oracle db? I've included …

I am trying to create a simple trigger in an oracle 10g database. This script to Create the trigger runs …

I create a table in Oracle 11g with the default value for one of the columns. Syntax is: create table …

I am wanting to output a Query to a CSV file and am using the below as a small test; …

I was using SQL Developer 1.1. I have recently upgraded to SQL Developer 3. After the upgrade, I noticed that some of …

I want to build an SQL string to do database manipulation (updates, deletes, inserts, selects, that sort of thing) - …

I am wanting to store a Rownum as a variable rather than use a costly Join. I need to get …

I am trying to print the TEXT when condition is TRUE. The select code is perfectly working fine. It's showing 403 …

When I'm querying a table in schema C from schema A, I'm getting ORA-01031: insufficient privileges and when I'm querying …