Insert the ampersand (&) via SQL*Plus
This short write-up examines the role of the ampersand (&) in SQL*Plus, and shows how you can easily turn it into just another text character when you need to insert it into a table.
February 28th 2010
1k
Update a table with itself, with one SQL statement
Sometimes you may need to update a table with its own data, typically when rows contain a link to values stored in other rows. The example SQL and narrative illustrate how to do this via an Update statement with a ...