SQL

Removing table rows using an inline view

Leave a Comment / Oracle / By / February 26, 2010 / , , , , , , , ,

The SQL standard allows you to use an inline view in a DELETE statement, see the pseudo form below – If a condition such as key-preserved table is not met then it will result in error, “ORA-01752: cannot delete from view without exactly one key-preserved table.” I would like to show you the caveat of …

Removing table rows using an inline view Read More »

Joins, Join Conditions, Filters and Join Types

1 Comment / Oracle / By / February 11, 2010 / , , , , , ,

Joins A join is a query that combines rows from two or more tables. Oracle performs a join whenever multiple tables appear in the FROM clause of the query. Below is a SQL join statement, legacy syntax and ANSI/ISO syntax (also referred as new join syntax, was first introduced in Oracle 9i release) in a …

Joins, Join Conditions, Filters and Join Types Read More »