user avatar
user avatar
user avatar
Balazs Papp
  • Member for 8 years, 10 months
  • Last seen this week
19 votes
Accepted

Delete an oracle instance, the right way

16 votes
Accepted

Cluster design: if I expect to insert data into several tables every week, is it a bad idea to cluster them?

14 votes

How to check if the table has rows?

14 votes
Accepted

PL/SQL function to receive a number and return its binary format

13 votes
Accepted

ORA-01691 (unable to extend lob segment) even though my tablespace has AUTOEXTEND on

12 votes

Selecting from random amount of tables with identical structure

11 votes
Accepted

How can I use an array variable inside the IN operator for Oracle SQL?

11 votes
Accepted

Why is SQL*Plus' desc table not showing not null constraints after using dbms_redefinition

11 votes

How to make sqlplus output appear in one line?

11 votes
Accepted

What's the differences between the two version of oracle client download file, "client" and "client home"?

11 votes
Accepted

Is there a function which the opposite of NULLIF?

10 votes
Accepted

Query with ROWNUM returns differents rows on every execution

10 votes
Accepted

Generate `insert` statements for each entry in a table

9 votes
Accepted

count multiple occurences of attribute values for each row in sql

9 votes
Accepted

Trouble understanding INITRANS in oracle

8 votes

Run a SQL statement on all databases monitored by OEM

8 votes
Accepted

Oracle expdp puts INDEXES to LOGGING mode

8 votes

Result on execution of any SQL is number 2

7 votes

Set TERMOUT OFF is not working when I am using sqlplus in command prompt?

7 votes

What is an orphan incarnation?

7 votes
Accepted

Problem granting user privileges via roles in Oracle 12c

7 votes

dbms_output hard limit in SQL Developer

7 votes
Accepted

Can you help clear confusion of ORACLE Timestamp with Local Time Zone?

7 votes
Accepted

Not able to login to oracle using sqlplus utility because username and password contain space

7 votes

How to make dataguard switchover seamlessly

7 votes
Accepted

Updating BLOB Columns

7 votes
Accepted

"ORA-01017: invalid username/password" while connecting to an instance remotely as sysdba

7 votes

Exporting results of a query in SQL developer without having to execute the query twice

7 votes

How to completely "reset" an Oracle instance?

7 votes

Why does the CBO not chose a lower cost skip scan without stats?

1
2 3 4 5
46