Quelltext der Seite Open and execute scripts

You sometimes already have worked with the SQL-Developer. But you are not really used to it. Here you will find a short description how to open and execute a saved script.
 
[[File:SQL_Scripts_en_01.png|border|left]]
Open explorer and select D:\setup\sqldeveloper\sqldeveloper.exe.

Start this application with a double click.
<br clear=all>
 
[[File:SQL_Scripts_en_02.png|border|left]]
Make sure that you are connected to your database. If you have questions please do not hesitate to ask for help.

Then click the Icon to open a script (see arrow).
<br clear=all>
 
[[File:SQL_Scripts_en_03.png|border|left]]
Select the correct location first <span style=color:red;">(1)</span>. Beware there are many files.

When you found the location select the file needed <span style=color:red;">(2)</span>. It has to arise in “File name”. Then you can open this file <span style=color:red;">(3)</span>.
<br clear=all>
 
[[File:SQL_Scripts_en_04.png|border|left]]
In this example take care that you use the correct order nr (= auftrnr) and exchange rate (= Kurs) in all the marked lines <span style=color:red;">(1)</span>. In other scripts it could be the article number.

You will execute this script by clicking the second icon <span style=color:red;">(2)</span>.

After this there will open a log window. Here you can read how many lines have been changed. The last line should be: “commit successful”.

You have to run the script for each single order by changing the order numbers.
<br clear=all>

[[File:SQL_Scripts_en_05.png|border|left]]
To replace the order number faster in long scripts it is easier to mark <span style=color:red;">(1)</span> and replace it.

Open the "Edit" <span style=color:red;">(2)</span> and click at "replace" <span style=color:red;">(3)</span>. 

 Now there opens a window with the selected number and a suggestion how to replace. Please correct it.

All same numbers will be marked now <span style=color:red;">(4)</span>.

Now you have the choice <span style=color:red;">(5)</span> to replace one single, skip the marked one or replace all shown selections.
<br clear=all>

[[File:SQL_Scripts_en_06.png|border|left]]
This will be the more modern window wich opens when you use STRG+R.
<br clear=all>