Top "Oracle" questions

Oracle subtracting days and minutes

I want to subtract "X" days and "X" minutes from sysdate, where the days and minutes are an integer as …

oracle sysdate

How to convert these julian dates to oracle date format?

Below is a sample set of data that is supposed to be dates. I am not sure what kind of …

oracle julian-date

load multiple csv into one table by SQLLDR

I am using SQL LOADER to load multiple csv file in one table. The process I found is very easy …

sql oracle sql-loader

How to use an Oracle Associative Array in a SQL query

ODP.Net exposes the ability to pass Associative Arrays as params into an Oracle stored procedure from C#. Its a …

sql oracle plsql associative-array odp.net

Hibernate > CLOB > Oracle :(

I am trying to write to an Oracle clob field a value over 4000 characters. This seams to be a common …

java oracle hibernate oracle9i clob

Using Oracle hint "FIRST_ROWS" to improve Oracle database performances

I have a statement that runs on Oracle database server. The statement has about 5 joins and there is nothing unusual …

database performance oracle hint

Single SQL SELECT Returning multiple rows from one table row

We have a table which is of the form: ID,Value1,Value2,Value3 1,2,3,4 We need to transform this into. ID,…

sql oracle select plsql oracle9i

Fetch Oracle table type from stored procedure using JDBC

I'm trying to understand different ways of getting table data from Oracle stored procedures / functions using JDBC. The six ways …

oracle stored-procedures jdbc resultset out-parameters

How to do countIf() in Oracle

How do I select a variable which gives an output the same as the excel function: COUNTIFS(A1:D1,"<25", …

sql oracle countif

Oracle SQL -- Analytic functions OVER a group?

My table: ID NUM VAL 1 1 Hello 1 2 Goodbye 2 2 Hey 2 4 What's up? 3 5 See you If I want to return the max number …

sql oracle greatest-n-per-group