This Oracle SQL tutorial explains and demonstrates how to write a basic Oracle SELECT Statement with explanations and ample examples. This post is a part of many other topics demonstrating how to write select queries, how to filter data using … [Continue reading] about Oracle SELECT Statement
Introduction This Oracle SQL tutorial will help you learn and understand basic concepts of Oracle SQL. We will be going through some of the very basic concepts one must have learnt to crack the PL/SQL and other features of Oracle database. In … [Continue reading] about SQL Tutorial with Examples – Oracle
What is COALESCE in SQL? COALESCE is an SQL function which is specifically used to return the very first NOT NULL value from the list of values or expressions provided within the braces ( ) . COALESCE processes the values in the sequence they … [Continue reading] about What is COALESCE in SQL?
What are SQL Joins? SQL JOINs will help you to combine records from two or more tables in a relational database. As the word JOIN indicates, a SQL JOIN helps you to connect at least two tables (or more than two) and fetch the data which are … [Continue reading] about SQL Joins Explained Step by Step
At times, you end up wanting to Kill active Session in Oracle Database in order for certain reasons. Some of those could be; You want to Kill an active session which has been running long and is never ending.You want to Kill an active session … [Continue reading] about How to kill active Session in Oracle