Search code examples
Transpose Hierarchical Table based on leaf nodes with roots as first column...

sqloracle-databasehierarchical-data

Read More
Is there a lookup table for the column ALL_CONSTRAINTS.CONSTRAINT_TYPE in Oracle DB?...

oracle-database

Read More
Comparisons using EXTRACT YEAR not working...

sqloracle-databaseoracle-sqldeveloper

Read More
Oracle Analytics - partitions and ordering of sql queries...

oracle-databaseanalytic-functions

Read More
Selecting a sequence NEXTVAL for multiple rows...

sqlsql-serveroracle-databaseoracle10glinked-server

Read More
Oracle procedure error: Expected UDT got CHAR...

oracle-databaseplsqloracle19c

Read More
pull access denied for container-registry.oracle.com/database/enterprise...

oracle-databasedockercontainer-registry

Read More
USE database_name command alternative for Oracle...

sqloracle-database

Read More
How to return columns from dynamic SQL in Python console...

pythonoracle-databaseplsqldynamic-sqlcx-oracle

Read More
How to determine if and which index is being used in oracle...

sqloracle-databaseindexingoracle-sqldeveloper

Read More
How to raise Oracle PL/SQL exceptions from Python...

pythonoracle-databaseplsqlcx-oracle

Read More
sql extraction of identification numbers...

sqloracle-database

Read More
Oracle Database: Find Missing Indexes for Performance tuning...

sqloracle-databaseindexingplsqloracle11g

Read More
difference between 'natural full outer join' and 'full outer join'...

sqloracle-database

Read More
SQL query giving error msg not enough values...

sqloracle-database

Read More
Unique Constraint violation...

sqloracle-database

Read More
Oracle APEX Dynamic Action call to package throwing error "ORA-06550: line 11, column 19: PLS-0...

oracle-databaseoracle-apex

Read More
ORA-00001: uniqueness constraint violated...

oracle-databaseplsqlsql-insertdbeaverora-00001

Read More
Unable to set CLASSPATH with confluent CLI : java.sql.SQLException: No suitable driver found for jdb...

oracle-databasejdbcapache-kafkaapache-kafka-connectconfluent-platform

Read More
In an oracle RAC setup, can a single transaction be assured to be executed on a single node?...

oracle-databaseoracle-raclogminerredo-logs

Read More
Multiple Passwords for Multiple Schemas in single connection...

oracle-databasedbeaver

Read More
Get the resultset of any SQL cursor as XML with column names as attribute without using XSLT in Orac...

oracle-databaseoracle-xml-db

Read More
Get UDT type name inside of its body in Oracle 19c...

oracle-databaseoracle19c

Read More
Oracle regexp_replace...

oracle-databaseregexp-replace

Read More
Extracting data from an Oracle DB on python. Facing issues with the multibyte characters...

pythonoracle-databasecharacter-encodingexport-to-csvmultibyte-characters

Read More
Setting report column to YES or NO based on date - Oracle SQL...

sqloracle-databasedatecaseisnull

Read More
SQL script called from Jenkins Pipeline does not output error or correct exit code...

sqloracle-databaseshelljenkinsgroovy

Read More
Oracle SQL Insert Trigger to Handle Duplicate Contacts and Update Owner Field...

sqloracle-databaseoracle-apex

Read More
How to Split a String by Delimiters and Handle Empty Values as NULL in Oracle PL/SQL?...

sqloracle-databaseplsql

Read More
Can the storage segment of an XMLTYPE column be named at will during creation?...

oracle-databaseoracle-xml-db

Read More
BackNext