Search code examples
Table rows summarize by Month in Oracle...

sqloracle-databasepivotoracle12c

Read More
in Oracle DB, is there a way to create an index on each column with one command?...

sqloracle-databaseoracle12cddl

Read More
Oracle hierarchical queries data...

sqloracle-databaseoracle12c

Read More
Custom audit log message send from Oracle DB version 12c to SIEM via syslog...

securityoracle12caudit

Read More
oracle 12c - select string after last occurrence of a character...

sqlstringoracle-databaseoracle12c

Read More
Does bitmap index full scan perform sort in Oracle?...

oracle-databasequery-optimizationoracle12cdatabase-administration

Read More
ORA-39358: Export dump file version 12.2.0 not compatible with target version 12.1.0.2.0...

databaseoracle-databaseplsqloracle12c

Read More
Standardizing addresses using regexp_replace in oracle sql...

sqloracle-databaseplsqloracle12c

Read More
How to imporve performace of an insert when a table has so many indexes in Oracle?...

oracle-databasequery-optimizationoracle12cdatabase-performancedatabase-administration

Read More
Avoid full table scan with SELECT using PL/SQL table...

sqloracle-databaseoracle12coracle19c

Read More
Oracle XMLTYPE extract based on value and condition...

sqlxmloracle-databaseoracle12cxmltype

Read More
SQL - Get the values of another column for values in a given column...

sqloracle-databaseoracle12c

Read More
Most efficient way to compute difference between dates...

sqloracle-databaseoracle12cdatabase-performance

Read More
Why does Oracle implicitly add SYS_EXTRACT_UTC to index?...

sqloracle-databaseindexingoracle12cutc

Read More
How to create table using oracle database...

sqloracle-databaseoracle12c

Read More
Value for EXCLUDE is badly formed Importing Oracle Database 12c Enterprise Edition Release 12.1.0.1....

oracle-databaseoracle12cdatapumpimpdpimp

Read More
SUM and COUNT for kind of hierarchical data without ID relationship...

sqloracle12chierarchical

Read More
Splitting a row into 2 rows based on value present in a column...

sqloracle-databasesubstringoracle12c

Read More
sum values based on 7-day cycle in SQL Oracle...

sqloracle-databaseoracle12canalytic-functions

Read More
Grouping records from a table...

sqlgroupingoracle12c

Read More
Extracting words from a sentence in oracle...

oracle-databaseoracle12c

Read More
Oracle 12c - Find if temporary objects created before TEMP_UNDO_ENABLED is set...

oracle-databaseoracle12c

Read More
ORA-32359: cannot specify the FRESH_MV hint for this query - Query on RTMV...

oracle-databaseoracle12cmaterialized-views

Read More
SQL Syntax Error: "Missing Right Parenthesis"...

sqloracle-databasesyntax-errororacle12cora-00907

Read More
Why i'm getting "PLS-00302: component 'TABLE_NAME' must be declared"?...

oracle-databasestored-proceduresplsqloracle12c

Read More
PL/SQL Output column results in dbms_output.put_line LOOP...

sqlplsqloracle12c

Read More
How to make Oracle sqlplus spool query results to a file?...

windowsoracle-databaseoracle12csqlplus

Read More
ERROR monitoring oracle by odbc in zabbix : Can't open lib '/usr/lib/oracle/12.2/client64/li...

oracle-databaseodbcmonitoringoracle12czabbix

Read More
Capture SQL/Developer Script Output in PL/SQL...

oracle-databaseplsqloracle12cdbms-output

Read More
Oracle Materialized View with ENABLE ON QUERY COMPUTATION...

oracle-databaseoracle12cmaterialized-views

Read More
BackNext