Oracle Tutorial

ORACLE where clause In Oracle, where clause is used to filter the result. Where clause can be used in INSERT, UPDATE, DELETE,…

Oracle OUTER JOIN An outer join is similar to equijoin but it gets also the non-matched rows from the table. It is…

What is Oracle? Oracle database is a relational database management system (RDBMS) from Oracle Corporation. This article will explain a complete overview…

Oracle Procedures A procedure is a group of PL/SQL statements that can be called by name. The call specification (sometimes called call…

Primary Key In Oracle, Primary key is the column which has unique values, and it cannot be null. In a table, there…

Oracle Queries You can execute many queries in oracle database such as insert, update, delete, alter table, drop, create and select. 1)…

Oracle SELECT Statement The Oracle SELECT statement is used to retrieve data from one or more than one tables, object tables, views,…

Oracle SELF JOIN Self Join is a specific type of Join. In Self Join, a table is joined with itself (Unary relationship).…

Oracle Semi Join Semi-join is introduced in Oracle 8.0. It provides an efficient method of performing a WHERE EXISTS sub-query. A semi-join…

ORACLE Subqueries In Oracle, subqueries are the queries inside a query. Subqueries can be made using WHERE, FROM or SELECT clause. Table…