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...
The Oracle TRUNC function truncates an expression to a number or to a date. The Oracle TRUNC (number) function returns n1 truncated to n2 decimal places. The Oracle TRUNC (date) function returns date with the specified format model fmt. Oracle TRUNC...