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...
Best Oracle Database Design Tools in 2025
When you're looking for a database design tool, it's not just for fun - you actually need one! Maybe...
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...
Free $245 Oracle Certifications till May 15th
While all Oracle Cloud and software trainings are free to watch on https://mylearn.oracle.com, the...
Comparing Execution Plans: MongoDB vs. Compatible APIs
MongoDB is the standard API for document databases, and some cloud providers have created services...
Oracle 19c Benefits!
Oracle 19c is designed to meet the evolving needs of businesses by providing advanced features that...
How to list all OCI resources in a Tenancy or Compartment
We walk through how to list all Oracle Cloud resources in the entire tenancy or compartment. ...
SQL Query Logical Order
In SQL, queries are processed in a specific order known as the Logical Query Processing Order or...
CTE | Common Table Expression | Real world scenarios examples
A Common Table Expression (CTE) - Common Table Expression (CTE) is a temporary, named...
%TYPE and %ROWTYPE Attributes in PLSQL
In PL/SQL, both %TYPE and %ROWTYPE are attributes that allow you to define variables that inherit the...
Exception Handling in PL/SQL| PRAGMA EXCEPTION_INIT | Part 3
PRAGMA EXCEPTION_INIT In PL/SQL, the PRAGMA EXCEPTION_INIT compiler directive allows you...
Cursor in PLSQL
Cursor Basics In PL/SQL, explicit cursors can be used in two primary ways: by manually...
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...
Pranav Bakare | PLSQL DEVELOPER
Here’s a resume format based on your provided points for an Oracle PL/SQL Developer role with 3 years...
Relationships in databases
Relationships in databases In databases, relationships define how tables are linked to...
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...
Database Design & Management Tool for ORACLE
When it comes to managing and designing Oracle databases, have you ever thought about whether you're...
RAISE_APPLICATION_ERROR and PRAGMA EXCEPTION_INIT in PLSQL EXCEPT HANDLING
In Oracle PL/SQL, RAISE_APPLICATION_ERROR and PRAGMA EXCEPTION_INIT are used for handling exceptions,...
Compound Trigger in Oracle SQL
What is a Compound Trigger in Oracle SQL? A compound trigger in Oracle SQL is a single...
Dynamic SQL in PL/SQL
Dynamic SQL in PL/SQL is used in a real-life context, where user input dynamically determines values...
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...
Are There “Queries over Trillion-Row Tables in Seconds”? Is “N-Times Faster ThanORACLE”anExaggeration?
We often hear about the advertisements for the performance of a big data product, saying that it is...
Dynamic SQL in Oracle SQL | Best Explanation
Dynamic SQL in Oracle SQL Dynamic SQL in Oracle allows you to build and execute SQL statements at...
Query the Records Closest to the Specified Time Each Day — From SQL to SPL #43
Problem Description & Analysis: A table in Oracle database has a column of datetime...
Table functions and Pipelined functions in PLSQL | Best Explanation
Here’s a structured explanation of table functions and pipelined functions with their definition,...