René Nyffenegger's user avatar
René Nyffenegger's user avatar
René Nyffenegger's user avatar
René Nyffenegger
  • Member for 13 years, 3 months
  • Last seen this week
109 votes
Accepted

How to use sqlplus to connect to an Oracle Database located on another host without modifying my own tnsnames.ora

24 votes
Accepted

Calculating percentage of a row over total sum

18 votes
Accepted

Best way to delete very large recordset in Oracle

13 votes

How does the Oracle DUAL table work?

13 votes

Eliminate duplicates in ListAgg (Oracle)

8 votes
Accepted

Detect Index Coalesce

8 votes
Accepted

how to Grant Permission on a table to a user on the other database in oracle

7 votes

How to find the actual space being consumed by indexes on a table in Oracle?

7 votes

What is the significance of a semicolon at the end of SQL*Plus commands?

6 votes
Accepted

Building Dynamic Oracle Where Clause

5 votes

How to free space after deleting the millions of rows from a table

4 votes
Accepted

Execution plan using B+ tree index, but also sorts

4 votes
Accepted

Data transformation implementation

4 votes

Getting the value of 'foo' for the closest previous row with higher 'bar'

3 votes

ORA-01427:single-row subquery returns more than one row

2 votes
Accepted

Create a new table oracle

2 votes

How to generate an SQL file with DBMS_DATAPUMP

2 votes

What is a good way to store a large number of columns?

2 votes
Accepted

Identify which parameters were passed to a procedure (Oracle)

2 votes
Accepted

How to design this simple DB?

2 votes

Question on Oracle rowid column in every table

2 votes

How do you monitor specific SQL statement of a specific user ?

1 vote
Accepted

Archiving fga_log$: sys.dbms_audit_mgmt.clean_audit_trail doesn't delete anything

1 vote

Invalid File Name on login to SQLPLUS

1 vote

exporting oracle tables on command line as sql files

0 votes

Get timing on individual queries in Anonymous code block

0 votes

Why Sqlcode 100 does not come with exception