wolφi

wolφi has asked 17 questions and find answers to 30 problems.

Stats

About

Relational since 1971 (blame the Sputnik crisis), Oracle since 7.3.4, bioinformatics since Edgar Wingender and Amos Bairoch.

Erdős number 4

wolφi questions

How to store NULL values in an interval partitioned table in Oracle?
How to purge an Advanced Queue in Oracle
How to create a primary key using a longer unique index?
How to install SQL Developer on macOS Catalina 10.15?
SQL Developer doesn't display XML
How to use temporal validity in Oracle 12c?
DBMS_RANDOM considered dangerous?
What is the difference between NOPARALLEL and PARALLEL 1 in Oracle?
How to drop columns in a compressed table?
How big is an Oracle XMLType when stored as BINARY XML

wolφi answers

Oracle SQL: Most efficient way to calculate Z-score of grouped data
How can I get the complete definition (sql) of system views like user_objects?
Partition exchange column type or size mismatch (ORA-14097)
Execute immediate dbms_output.put_line
Are indexes used if the WHERE clause contains unindexed columns
How to install SQL Developer on macOS Catalina 10.15?
How to obtain count of record differences in the same table, where there are distinct and nearly-distinct records
cx_Oracle.DatabaseError: ORA-00942: table or view does not exist
Move oracle Column ID
Oracle get id of inserted row with identity always [duplicate]