Top "Oracle" questions

Oracle Database is a Multi-Model Database Management System created by Oracle Corporation.

TO_DATE problems

I have the following in my SQL where clause. This is running against an Oracle database. The sc_dt field …

sql oracle to-date
How to create an oracle.sql.ARRAY object?

This question is related to my original issue How to return an array from Java to PL/SQL ?, but is …

java oracle jdbc oracle11gr2
Java Oracle localhost connection error (ORA-12505)

I am trying to currently connect to a database on my current computer. import java.sql.Connection; import java.sql.…

java database oracle exception sqlexception
How do NULL values affect performance in a database search?

In our product we have a generic search engine, and trying to optimze the search performance. A lot of the …

sql database oracle database-performance query-performance
Need to count records and group count by date on oracle db using sql developer

I have a table like the following ID created sent type ----------------------------------------------------- 0001463583000051783 31-JUL-12 1 270 0081289563000051788 01-AUG-12 1 270 0081289563000051792 01-AUG-12 1 270 0081289563000051791 01-AUG-12 1 270 0081289563000051806 01-AUG-12 1 270 0001421999000051824 06-AUG-12 1 270 0001421999000051826 06-AUG-12 1 270 0001464485000051828 06-AUG-12 1 270 0082162128000051862 09…

oracle count oracle10g group-by oracle-sqldeveloper
Script to disable all jobs in Oracle (DBMS_JOB package)?

I'm looking for a script which disables all the jobs. Right now I highlight them all in Toad, click the …

oracle plsql oracle10g dbms-job
How to do Outer Join on >2 Tables (Oracle)

I'm not sure how to describe my table structure, so hope this makes sense... I have 3 tables in hierarchical relationship …

oracle outer-join multiple-tables
Difference between NVARCHAR in Oracle and SQL Server?

We are migrating some data from sql server to oracle. For columns defined as NVARCHAR in SQL server we started …

sql-server database oracle nvarchar varchar2
Select and Insert across dblink

I am having a bit of trouble with a select into insert across a dblink in oracle 10. I am using …

oracle insert dblink
Oracle - Create text file using stored procedure

Need help on creating text file using stored procedure in oracle 10. I'm very new to this so please guide me …

oracle utl-file