oracle Archives - Page 4 of 5

Oracle SQL: Update a table with data from another table

Table 1: id name desc ----------------------- 1 a abc 2 b def 3 c adf Table 2: id name desc ----------------------- 1 x ...

May 17, 2022
0 Comments

How do I find duplicate values in a table in Oracle?

What’s the simplest SQL statement that will return the duplicate values for a given column and the count of their occurrences in an ...

May 17, 2022
0 Comments

Is there any boolean type in Oracle databases?

Is there any Boolean type in Oracle databases, similar to the BIT datatype in Ms SQL Server? 11 Answers 11

May 16, 2022
0 Comments

Oracle: how to UPSERT (update or insert into a table?)

The UPSERT operation either updates or inserts a row in a table, depending if the table already has a row that matches the ...

May 15, 2022
0 Comments

Best way to do multi-row insert in Oracle?

I’m looking for a good way to perform multi-row inserts into an Oracle 9 database. The following works in MySQL but doesn’t seem ...

May 13, 2022
0 Comments

Difference between a user and a schema in Oracle?

What is the difference between a user and a schema in Oracle? 15 Answers 15

May 13, 2022
0 Comments

Liquibase lock – reasons?

I get this when running a lot of liquibase-scripts against a Oracle-server. SomeComputer is me. Waiting for changelog lock.... Waiting for changelog lock.... ...

May 12, 2022
0 Comments

Update statement with inner join on Oracle

I have a query which works fine in MySQL, but when I run it on Oracle I get the following error: SQL Error: ...

May 12, 2022
0 Comments

Oracle: If Table Exists

I’m writing some migration scripts for an Oracle database, and was hoping Oracle had something similar to MySQL’s IF EXISTS construct. Specifically, whenever ...

May 9, 2022
0 Comments

What is the difference between Views and Materialized Views in Oracle?

What is the difference between Views and Materialized Views in Oracle? 8 Answers 8

May 8, 2022
0 Comments