Articles by Tag #oracle
Browse our collection of articles on various topics related to IT technologies. Dive in and explore something new!
How to Write a Token Price Oracle Smart Contract
Introduction In the rapidly evolving DeFi ecosystem, accurate and reliable token price...
SQL Recursive Queries - Understanding Common Table Expressions (CTEs)
Recursive queries in SQL, enabled by Common Table Expressions (CTEs), allow us to work with...
A brief example of an SQL serializable transaction
Here are some additional details about a small live demo I presented while discussing Isolation...
Understanding and Configuring Oracle Access Control Lists (ACLs) for Email Sending Using UTL_MAIL
Introduction This article is based on real problems I had in a production environment in...
Oracle Database Fragmentation - How to reorg Tables / Indexes
{ Abhilash Kumar Bhattaram : Follow on LinkedIn } Database fragmenmtation from 12.2...
Unique Index on NULL Values in SQL & NoSQL
NoSQL behavior: MongoDB SQL behavior: PostgreSQL and YugabyteDB A mix of both: Oracle Database You...
Oracle Certified Java 8 Associate (OCA) Exam Preparation
Taking the 1Z0-808 - Java SE 8 requires practice. One has to be fully prepared so as to pass the...
Stored Procedures & Exception Handling when migrating from Oracle to PostgreSQL or YugabyteDB
Lot of companies hope to find a solution to easily move their PL/SQL code from Oracle Database to...
Comparing Execution Plans: MongoDB vs. Compatible APIs
MongoDB is the standard API for document databases, and some cloud providers have created services...
SQL Query Logical Order
In SQL, queries are processed in a specific order known as the Logical Query Processing Order or...
Oracle 19c Benefits!
Oracle 19c is designed to meet the evolving needs of businesses by providing advanced features that...
An experience with Database Modernization: From Oracle for Aurora PostgreSQL – A Cloud Perspective
Hey cloud folks! Recently, As an Solution Architect i had the chance to work on a pretty cool...
Gather Oracle Stats for Schema, Table and Indexes
In the world of Oracle Database Management, gathering statistics plays a crucial role in optimizing...
CTE | Common Table Expression | Real world scenarios examples
A Common Table Expression (CTE) - Common Table Expression (CTE) is a temporary, named...
Performance Pitfalls: Using Hints in Oracle Database
In Oracle Database, hints can guide the optimizer to improve query performance. However, incorrect...
Relationships in databases
Relationships in databases In databases, relationships define how tables are linked to...
%TYPE and %ROWTYPE Attributes in PLSQL
In PL/SQL, both %TYPE and %ROWTYPE are attributes that allow you to define variables that inherit the...
Compound Trigger in Oracle SQL
What is a Compound Trigger in Oracle SQL? A compound trigger in Oracle SQL is a single...
How to list all OCI resources in a Tenancy or Compartment
We walk through how to use list all Oracle Cloud resources in a single tenancy or compartment. ...
VARRAY (Variable-size array) in PL/SQL
VARRAY (Variable-size array) in PL/SQL In PL/SQL, a VARRAY (Variable-size Array) is a type...
Exception Handling in PL/SQL| PRAGMA EXCEPTION_INIT | Part 3
PRAGMA EXCEPTION_INIT In PL/SQL, the PRAGMA EXCEPTION_INIT compiler directive allows you...
Pranav Bakare | PLSQL DEVELOPER
Here’s a resume format based on your provided points for an Oracle PL/SQL Developer role with 3 years...
Creating a backup table in ORACLE SQL
In Oracle SQL, creating a backup table is typically done by copying the structure and data of the...
Cursor in PLSQL
Cursor Basics In PL/SQL, explicit cursors can be used in two primary ways: by manually...
Database Design & Management Tool for ORACLE
When it comes to managing and designing Oracle databases, have you ever thought about whether you're...
Dynamic SQL in PL/SQL
Dynamic SQL in PL/SQL is used in a real-life context, where user input dynamically determines values...
Search for records containing a specified string group in multi fields #eg90
A table in an Oracle database has multiple string fields. Now we need to input a parameter that...
EXECUTE IMMEDIATE in PL/SQL
EXECUTE IMMEDIATE is a PL/SQL command used to execute a dynamically constructed SQL statement. This...
Interval Partitioning in Oracle SQL
Interval Partitioning in Oracle SQL Interval partitioning is a type of partitioning that...
ON DELETE CASCADE Usage with Foreign key
Definition of ON DELETE CASCADE The ON DELETE CASCADE clause is used in a database when...