Top "Oracle" questions

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

Oracle composite primary key / foreign key question

I have a composite primary key in 1 table in oracle. I want to create a foreign key for one table …

sql oracle composite-key
Using pivot on multiple columns of an Oracle row

I have the following sample data in an Oracle table (tab1) and I am trying to convert rows to columns. …

sql oracle oracle11g pivot
EXCEPT keyword in Oracle

I'm trying to use the EXCEPT keyword in Oracle 10.1.0.2.0, but kept getting error 'Unknown Command'. I've tried googling around and …

sql oracle oracle10g sql-except
update using for loop in plsql

i'm having problem updating and insert into below column. Please advise on this. This is the input depnto extra comm …

oracle plsqldeveloper
How to drop Oracle LOB

The following query can be used to list the database objects of the user: select object_name, object_type from …

oracle lob
Purpose of using different types of PL/SQL collections in Oracle

What is the main purpose of using collections in oracle ? Index by tables Nested tables Variable size ARRAY Can you …

oracle collections user-defined-types
What is the difference between a temporary table vs global temporary table in Oracle?

I have heard these two terms "temporary table" and "global temporary table" used pretty much in similar context. What is …

database oracle temp-tables
Understanding Lob segments (SYS_LOB) in oracle?

Most of the tables (if not all) have a "blob" field in it. One of the table that stores the …

oracle blob
Oracle Pl/SQL: Loop through XMLTYPE nodes

I have a XMLTYPE with the following content: <?xml version="1.0"?> <users> <user> <name&…

xml oracle plsql xmltype
Oracle SQL DATE conversion problem using iBATIS via Java JDBC

I'm currently wrestling with an Oracle SQL DATE conversion problem using iBATIS from Java. Am using the Oracle JDBC thin …

java oracle date jdbc ibatis