Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Bug in 4.2EA2: Commit statements missing when exporting (insert script)

Peter de VaalFeb 27 2017 — edited Feb 27 2017

The database export utility has the option to insert commit statements after a selected number of rows.

This worked in 4.1.5 but the statements are missing when generating the script in 4.2ea2.

Comments

Frank Kulash

Hi, @user-e2y4b
This question was posted in the English-language space. There's a separate space for Spanish language:
Base de Datos Discusión General — oracle-tech
I'll try to move the thread there for you.

mathguy

Please note that this forum es solo en ingles. Either you state your question and accept answers in English, or look for a Spanish language forum (knowing that participation will be much more limited).
As to the error: Tables like AH135D are understood within the subquery (the join), but not outside it. The UPDATE statement only sees the result of the subquery, with its columns.
Either move the WHERE clause INSIDE the query, or give the subquery and its columns aliases and use those in the WHERE clause. (You may leave out the subquery alias - and perhaps even the column aliases, if there is no risk of confusion - but in a problem like this it is a best practice to alias the subquery and also the columns within it.)

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 27 2017
Added on Feb 27 2017
1 comment
170 views