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
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
243 views

Invalid views not showing in user_dependencies after first compilation

1 vote
0 answers
671 views

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

1 vote
0 answers
108 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
658 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
244 views

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