The Oracle Non Equi-Join enables you to join two tables where there is no direct correspondence between columns in the tables. Oracle Non Equi-Join example Select c1.customer_id, c1.name, c2.amount From customers c1, contracts c2 Where c2.amount Between 100 and 200 Select...
The Oracle Left Outer Join is a query that performs an outer join of tables A and B and returns all rows from A. Oracle Left Outer Join example Select c.customer_id, c.name, cd.email, cd.phone From customers c LEFT OUTER JOIN customers_details...
The Oracle Inner Join is a join of two or more tables that returns only those rows that satisfy the join condition. Oracle Inner Join example Select c.contract_id, p.product_id, p.amount From products p, contracts c Where p.product_id = c.product_id And p.amount...
DML (Data manipulation language) statements access and manipulate data in existing tables. Changes made by DML statements do not remain permanently in the database if commit is not used. Insert Statement – inserts rows into an existing table. Update Statement –...
Decode – compares expression to each search value one by one. Instr – search string for substring. Round – returns a number or date rounded. Substr – returns a set of characters from an expression. To_Char – converts an expression to...