Top "Oracle" questions

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

Difference Between Drop And Drop Purge In Oracle

I am using Oracle Database and I am a bit confused about Drop and Purge Commands. In fact for me …

sql oracle oracle10g
How can I run Oracle SQL Developer on JDK 1.6 and everything else on 1.7?

How can I run Oracle SQL Developer on a version of Java it supports (1.6) while running Java 1.7 for everything else? …

java sql oracle oracle-sqldeveloper
SQL Performance: SELECT DISTINCT versus GROUP BY

I have been trying to improve query times for an existing Oracle database-driven application that has been running a little …

sql performance oracle group-by distinct
How to call Oracle Function or Procedure using Hibernate (EntityManager) or JPA

I have an Oracle function which return sys-refcursor and when I call this function using Hibernate, I am getting the …

java oracle hibernate jpa sys-refcursor
Username & Password in JDBC Connection URL

I was using a SQuirrel SQL Client to connect & browse my oracle database servers. I have given the credentials …

java oracle jdbc squirrel-sql
Split string by space and character as delimiter in Oracle with regexp_substr

I'm trying to split a string with regexp_subtr, but i can't make it work. So, first, i have this …

sql regex oracle string-split regexp-substr
ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments

I have problem with calling store procedure on Oracle 11g server. stored procedure PROCEDURE get_rit_by_user_id(KDC_…

c# oracle odp.net
Oracle SQL Developer: How to transpose rows to columns using PIVOT function

I'm attempting to create a query to transpose rows into columns using the PIVOT function. This is the contact table …

sql oracle pivot oracle9i
Setting the Date Format in the SQL*Loader Control File

I have csv file that has "17 September, 2009 11:06:06 AM" as COMPLETED_ON variable I am using sql loader to load data …

oracle sql-loader to-date