wolφi

wolφi has asked 16 questions and find answers to 28 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 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

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]
Add a new column and fill it with a portion of another column in Oracle SQL
Oracle SQL: Selecting data and partition name from table and truncating partitions