Top "Oracle11g" questions

Oracle is an Object-relational Database Management System (ORDBMS) created by Oracle Corporation.

How can I describe a table in Oracle without using the DESCRIBE command?

I'm having a hard time with a class I am taking. We need to write an Oracle script that will …

oracle oracle11g sql-scripts data-dictionary
DBMS_SCHEDULER.DROP_JOB only if exists

I have a sql script that I must run after I import a dump. among other things the script does, …

oracle oracle11g dbms-scheduler
no ocijdbc12 in java.library.path

I am trying to make a connection to oracle through java program using OCI driver. Following is the configuration. Windows 7, 32 …

java oracle dll oracle11g
Calculate business days in Oracle SQL(no functions or procedure)

I am trying to calculate business days between two dates in Oracle select. I got to the point when my …

sql oracle11g date-arithmetic
Oracle client installation error - path too long

I'm trying to install Oracle 11g Release 2 (client). But it gives an error like that : Environment variable: "PATH" - This …

oracle oracle11g oracleclient
Oracle - ORA-01489: result of string concatenation is too long

Created one view within which one field(of 6) is a concatenation of two fields from the source table. Created a …

sql oracle oracle11g size listagg
How to change settings for SQL Developer to correctly recognize current version of SDK

I've installed Oracle 11g r2 to my machine and when I opened Oracle SQL Developer it says: java 1.6.0_02 is not …

oracle oracle11g oracle-sqldeveloper jdk1.6
Oracle: Replacing non-numeric chars in a string

I have a field in my database where users have saved free-form telephone numbers. As a result, the data has …

oracle11g replace
Functions vs procedures in Oracle

can anybody explain what is the main difference between functions and procedures in Oracle? Why must I use procedures if …

oracle stored-procedures plsql oracle11g stored-functions
Read text file to insert data into Oracle SQL table

I am studying Oracle SQL developer. What I am doing is reading text file line by line from the folder. …

sql oracle11g oracle-sqldeveloper utl-file