Top "Oracle" questions

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

Viewing oracle app and getting: java.lang.ClassNotFoundException: oracle.forms.engine.Main

I'm trying to debug an oracle forms application. In production, when I load the application I get an error: java.…

java oracle internet-explorer oracle10g oracleforms
SQL not recognizing column alias in where clause

I am only a beginner in SQL, but I've come across this annoying error. SQL is having an issue with …

sql oracle column-alias
How can I create a unique index in Oracle but ignore nulls?

I am trying to create a unique constraint on two fields in a table. However, there is a high likelihood …

sql oracle ddl
Oracle Weblogic adding jars to the classpath?

How do you add jars to the class path for Oracle 10.3.5...As I understood it, there is a bug (or …

java oracle weblogic weblogic11g
Oracle: find index creation date from systables/information_schema?

Using Oracle, how can I find index names and creation dates from systables/information_schema? How can I reproduce, from …

sql oracle metadata information-schema
Are foreign keys really necessary in a database design?

As far as I know, foreign keys (FK) are used to aid the programmer to manipulate data in the correct …

database oracle foreign-keys
Finding Data Pump Dump Location in 12c

First and foremost, apologies for a very novice question here. I was just starting to get the hang of how …

database oracle import oracle12c
JDBC connection default autoCommit behavior

I'm working with JDBC to connect to Oracle. I tested connection.setAutoCommit(false) vs connection.setAutoCommit(true) and the results …

oracle jdbc autocommit
How to display the leading zero's in a number of oracle

I have an oracle column(artnr) contains a length of 1 which is of type number(9). I want to update the …

oracle numbers zero leading-zero
How to manually initialize a collection of RECORDs in PL/SQL?

guys. Here's a simple sample two-dimensional array in PL/SQL, which is working perfectly. declare type a is table of …

arrays oracle plsql multidimensional-array oracle9i