by Dexter | Jan 5, 2021 | Oracle SQL
Oracle UPDATE statement is used to update existing values in a table. Syntax The syntax of Oracle UPDATE statement is as follows: UPDATE table_name SET column1 = value1, column2 = value2, column3 = value3, … WHERE condition; Here, table_name : It’s the...
by Dexter | Jan 5, 2021 | Oracle SQL
INSERT statement in Oracle is used to insert data into the table. It comes under DML ( Data Manipulation Language ) Commands in Oracle. Syntax: The Syntax of INSERT Oracle statement is as follows: INSERT INTO table_name (column1, column2,..) VALUES( value1, value2,...
by Dexter | Jan 5, 2021 | Oracle SQL
In this tutorial, we will understand the concept of Sessions and Transactions in Oracle database. Session Session – Each Session encapsulates user interaction from login to logout ( Or Till connection is lost due to Network connectivity issues ) We can start a...
by Dexter | Dec 17, 2020 | Oracle SQL
We will be learning the usage of Oracle SELF JOIN in this tutorial for joining a table with itself. A SELF JOIN is used for joining a table with itself and serves the purpose of either comparing the values in one column from values in other column within the same...
by Dexter | Dec 17, 2020 | Oracle SQL
We will learn the usage of Cross Join in this tutorial for finding out the Cartesian product of two joined tables. If one table contains ‘x’ number of rows and other table contains ‘y’ number of rows then, the final output will contain ( x * y...
by Dexter | Dec 17, 2020 | Oracle SQL
We will be learning the usage of FULL OUTER JOIN in Oracle in this tutorial for joining two or more than two tables. As we know there are three types of Outer Joins, i.e, Left Outer Join, Right Outer Join and Full Outer Join which we use when we want to keep rows from...