Oracle Database – CodeRavo

How to Alter the Maximum Length of a VARCHAR Column in SQL Databases

Introduction When working with relational databases, you may encounter situations where the initial design does not … How to Alter the Maximum Length of a VARCHAR Column in SQL DatabasesRead more

alter table, data integrity, mariadb, modify-column, MySQL, Oracle Database, SQL Server, varchar

Customizing Date and Time Formats in Oracle SQL Developer

Introduction When working with databases, especially those containing temporal data, it is often necessary to customize … Customizing Date and Time Formats in Oracle SQL DeveloperRead more

date-format-customization, nls-parameters, Oracle Database, oracle-sql-developer, session-level-settings

Troubleshooting ORA-01034 and ORA-27101 Errors in Oracle Database Connections

Introduction When working with Oracle databases, encountering errors such as ORA-01034: ORACLE not available and ORA-27101: … Troubleshooting ORA-01034 and ORA-27101 Errors in Oracle Database ConnectionsRead more

database-instance, Environment Variables, listener-configuration, ora-01034, ora-27101, Oracle Database, sql-plus

Identifying Long Running Queries in Oracle Databases

When working with Oracle databases, it’s not uncommon to encounter performance issues due to long-running queries. … Identifying Long Running Queries in Oracle DatabasesRead more

long-running-queries, Oracle Database, performance optimization, v-session, v-session-longops, v-sqltext-with-newlines

Creating Users in Oracle 12c: Understanding Common and Local Users

Introduction Oracle Database 12c introduced a revolutionary architecture called multitenant, which includes Container Databases (CDBs) and … Creating Users in Oracle 12c: Understanding Common and Local UsersRead more

common-users, container-databases-cdb, local-users, multitenant-architecture, Oracle Database, oracle-12c, pluggable-databases-pdb, user-management

Understanding and Using Temporary Tables in Oracle Databases

Introduction Temporary tables are a powerful feature used to store transient data during the execution of … Understanding and Using Temporary Tables in Oracle DatabasesRead more

cte, global-temporary-table, in-memory-objects, materialize-hint, on-commit, Oracle Database, private-temporary-table, sql-dml, Temporary Tables

Understanding Oracle Database Grants: A Complete Overview

In managing Oracle databases, understanding user permissions and privileges is crucial for maintaining security and ensuring … Understanding Oracle Database Grants: A Complete OverviewRead more

dbms-metadata, grant-queries, object-privileges, Oracle Database, role-based-privileges, system-privileges, user-permissions

Creating an Empty Copy of an Oracle Table

In Oracle databases, it’s often necessary to create a copy of an existing table without copying … Creating an Empty Copy of an Oracle TableRead more

Data Copying, dbms-metadata, ddl, Oracle Database, SQL, table-structure

Troubleshooting Oracle Connection Issues: Resolving ORA-12541 TNS Listener Errors

Connecting to an Oracle database from a remote server can sometimes result in errors, one of … Troubleshooting Oracle Connection Issues: Resolving ORA-12541 TNS Listener ErrorsRead more

database-connection, listener-configuration, ora-12541-error, Oracle Database, tns-listener

Modifying Column Nullability in Relational Databases

In relational databases, columns can be defined as either nullable or not nullable. A nullable column … Modifying Column Nullability in Relational DatabasesRead more

alter table, database-design, MySQL, nullability, Oracle Database, PostgreSQL, relational databases, SQL Server