Check Database Status
Use the following SQL queries to get key information about the Oracle database and instance status. 1. Detailed Database & Instance Info 2. Compact…
CATEGORY
Database
Master SQL, PostgreSQL, MySQL, MongoDB, and trending open-source databases. Learn optimization, design patterns, and best practices for modern data management.
323 articles
Connect to Database
Use these methods to quickly connect to Oracle DB in various environments. 1. SQL*Plus (EZConnect) Example: 2. SQL*Plus (Local as SYSDBA) Works when you’re…
Oracle 19c Silent Install & DB Creation on Oracle Linux 8
In this guide, you’ll learn how to perform a fully silent Oracle 19c installation and create a database on Oracle Linux 8, step-by-step. We…
Install Oracle 19c on Amazon Linux 2 (GUI-Based)
Installing Oracle 19c on Amazon Linux 2 is now easier than ever with this step-by-step guide designed for a real-world production setup. This tutorial…
Overview
This guide is a practical reference for Oracle Database Administrators (DBAs), designed to support day-to-day operational needs in real-world environments. 📌 Key Focus:From basic…
SQL Operators List
SQL operators are symbols or keywords used to perform operations on data, such as comparisons, arithmetic calculations, logical evaluations, and more. Knowing the common…
SQL Error Handling (TRY/CATCH / Exception blocks)
When running SQL code, errors can happen — like constraint violations or syntax errors. Handling these errors gracefully lets you control what happens next…
SQL Transactions (BEGIN, COMMIT, ROLLBACK)
A transaction is a sequence of SQL operations treated as a single unit. Transactions ensure data integrity — either all operations succeed, or none…
SQL Triggers
A Trigger is a special kind of stored procedure that automatically executes in response to certain events on a table or view, such as…
SQL Stored Procedures
Stored Procedures are pre-written SQL code saved in the database that you can execute repeatedly. They help encapsulate logic, improve performance, and simplify complex…
SQL Math Functions
SQL provides built-in math functions to perform calculations directly in queries. These functions help with numeric analysis, transformations, and conditional logic. 🔹 Common SQL…
SQL String Functions
String functions are essential for cleaning, transforming, and analyzing text data in SQL. Each DBMS offers slightly different syntax, but the core idea is…