Top "Oracle" questions

How to use Oracle global temporary table?

I am attempting to use an Oracle global temporary table without physically creating a table in the database. The following …

oracle plsql oracle11g oracle10g plsqldeveloper

Referencing a composite primary key

I have two tables, with each table having a composite primary key. One attribute is in both composite primary keys. …

sql oracle foreign-keys primary-key composite-primary-key

Oracle ojdbc8 12.2.0.1 Forbidden by Maven

Oracle ojdbc8 12.2.0.1 Forbidden by Maven since December 2017, before that worked well. What configuration has changed on the Oracle repository (setting.…

java oracle maven ojdbc

How to truncate all user tables?

How can I truncate all user table in oracle? I have problem with tables constraints.

oracle constraints truncate

Oracle sql merge to insert and delete but not update

Is there a way to use oracle merge to insert and delete but not update? I have a table representing …

sql oracle merge insert sql-delete

When using tnsping, can I specify a port number along with the SID?

I use Bitvise Tunnelier to connect to a series of Oracle databases using SQL Developer; the connection is made to …

oracle tnsping

Overcomplicated oracle jdbc BLOB handling

When I search the web for inserting BLOBs into Oracle database with jdbc thin driver, most of the webpages suggest …

java oracle jdbc blob clob

invalid name pattern when trying to pass custom oracle type object mapping

I am trying to use Java spring custom Oracle type as a parameter and getting the following error: org.springframework.…

java oracle plsql spring-jdbc oracle-type

Database - (rows or records, columns or fields)?

In database terminology: What is the difference between a row and a record? Likewise, aren't columns and fields the same …

sql database oracle naming-conventions record

Connect by in Oracle SQL

Suppose that we have following tables create table Employee( 2 EMPNO NUMBER(3), 3 ENAME VARCHAR2(15 BYTE), 4 HIREDATE DATE, 5 ORIG_SALARY NUMBER(6), 6 CURR_…

sql oracle hierarchical-query