Skip to main content
OverflowAI is here! AI power for your Stack Overflow for Teams knowledge community. Learn more
René Nyffenegger's user avatar
René Nyffenegger's user avatar
René Nyffenegger's user avatar
René Nyffenegger
  • Member for 13 years, 4 months
  • Last seen more than a week ago
16 votes
2 answers
37k views

What does the term "projection" refer to in an SQL query (or view definition)

10 votes
1 answer
23k views

SQL*Plus, @, and relative paths

7 votes
5 answers
5k views

How different are the top DB vendor's SQL (DML-) dialects from each other?

7 votes
4 answers
19k views

How do I identify tables that have a foreign key to a specific table in Sybase?

7 votes
2 answers
2k views

If I SET ARRAYSIZE 1 in SQL*Plus, the records are still fetched in pairs. Why?

6 votes
1 answer
2k views

Using sys.diana and sys.pidl to parse PL/SQL

5 votes
1 answer
2k views

Is there a -w equivalent for isql when already connected?

5 votes
2 answers
4k views

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

4 votes
1 answer
4k views

How to generate an SQL file with DBMS_DATAPUMP

4 votes
2 answers
608 views

Is there a bug with PL/Scope in combination with associative arrays?

4 votes
1 answer
10k views

How do I update a table with the aggregated values (min, max) of a related table, fast?

4 votes
4 answers
12k views

Is (and if how) it possible in Oracle to "insert into <table> values <rowtype-variable>" if <table> has virtual columns

3 votes
1 answer
2k views

Oracle Datapump: modify fully qualified objects when cloning a schema

2 votes
1 answer
5k views

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

2 votes
1 answer
5k views

Is there a way to explicitely have a not-null column in a view

2 votes
1 answer
3k views

When is a row added to DBA_HIST_SQLSTAT?

2 votes
3 answers
20k views

How can I pass parameters to an "SQL Script" from isql

1 vote
0 answers
245 views

Invalid views not showing in user_dependencies after first compilation

1 vote
0 answers
675 views

Can I force a LOAD DATA LOCAL statement to abort if an error is not loaded?

1 vote
0 answers
110 views

Is it possible to execute "begin transaction" when connected to MS SQL server with Oracle's SQL Developer?

0 votes
1 answer
97 views

Why does an SQL Server Agent job try to create a procedure

0 votes
1 answer
669 views

How can I increase the length of the string returned by object_definition in sqlcmd?

0 votes
1 answer
293 views

Strange colored sqlcl results on Windows

0 votes
1 answer
247 views

In SQL*Plus, how do I run @https://here.is.url/script.sql behind a proxy?