Tables aliases have been specified for all tables in the FROM clause of this SELECT statement. After they have been specified, these table aliases must be used. You can’t mix tables aliases with real table names as shown below. It will generate an error.
Instead, you should have done the following query to make it work.
Substitution variables can be placed inside INSERT statements to create reusable scripts. You can place single ampersand (&) and double ampersand (&&) variables […]
SUBSTR will always return NULL if number of characters to retrieve was specified as negative SUBSTR will also return NULL if […]
Implicit COMMIT is normal behavior for Oracle. In certain situations, Oracle will commit everything automatically without you being involved. It is called […]
If columns are explicitly provided in a column list, then all columns listed must be included in the VALUES clause with […]
