oracle Archives - Page 2 of 5

MySQL, Programming

IT Nursery

What resources exist for Database performance-tuning? [closed]

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers. Questions asking us to recommend or find a ...

May 28, 2022
0 Comments

Database, Programming

IT Nursery

What is the difference between Non-Repeatable Read and Phantom Read?

What is the difference between non-repeatable read and phantom read? I have read the Isolation (database systems) article from Wikipedia, but I have ...

May 28, 2022
0 Comments

Programming, sql

IT Nursery

How can I find which tables reference a given table in Oracle SQL Developer?

In Oracle SQL Developer, if I’m viewing the information on a table, I can view the constraints, which let me see the foreign ...

May 27, 2022
0 Comments

oracle, Programming

IT Nursery

How can I set a custom date time format in Oracle SQL Developer?

By default, Oracle SQL developer displays date values as 15-NOV-11. I would like to see the time part (hour/minute/second) by default. Is there ...

May 27, 2022
0 Comments

Oracle Differences between NVL and Coalesce

Are there non obvious differences between NVL and Coalesce in Oracle? The obvious differences are that coalesce will return the first non null ...

May 26, 2022
0 Comments

Why does Oracle 9i treat an empty string as NULL?

I know that it does consider ‘ ‘ as NULL, but that doesn’t do much to tell me why this is the case. As ...

May 26, 2022
0 Comments

ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

Why am I getting this database error when I update a table? ERROR at line 1: ORA-00054: resource busy and acquire with NOWAIT ...

May 25, 2022
0 Comments

What is the dual table in Oracle?

I’ve heard people referring to this table and was not sure what it was about. 14 Answers 14

May 22, 2022
0 Comments

Case insensitive searching in Oracle

The default behaviour of LIKE and the other comparison operators, = etc is case-sensitive. Is it possible make them case-insensitive? 7 Answers 7

May 22, 2022
0 Comments

How to export query result to csv in Oracle SQL Developer?

I’m using Oracle SQL Developer 3.0. Trying to figure out how to export a query result to a text file (preferably CSV). Right ...

May 21, 2022
0 Comments