Open and execute scripts - Versionsgeschichte

Schreur am 20. September 2019 um 10:13 Uhr

2019-09-20T10:13:32Z

Schreur am 17. September 2019 um 10:36 Uhr

2019-09-17T10:36:52Z

Schreur am 17. September 2019 um 08:25 Uhr

2019-09-17T08:25:11Z

Schreur: Die Seite wurde neu angelegt: „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 s…“

2019-09-17T08:24:47Z

Die Seite wurde neu angelegt: „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 s…“

Neue Seite

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.
 

[[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).
 

[[File:SQL_Scripts_en_03.png|border|left]]
Select the correct location first (1). Beware there are many files.

When you found the location select the file needed (2). It has to arise in “File name”. Then you can open this file (3).
 

[[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 (1). In other scripts it could be the article number.

You will execute this script by clicking the second icon (2).

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.

← Nächstältere Version		Version vom 20. September 2019, 10:13 Uhr
Zeile 1:		Zeile 1:
	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.		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]]		[[File:SQL_Scripts_en_01.png\|border\|left]]

← Nächstältere Version		Version vom 17. September 2019, 10:36 Uhr
Zeile 28:		Zeile 28:

	You have to run the script for each single order by changing the order numbers.		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>		<br clear=all>

@@ Zeile 5: / Zeile 5: @@
 Open explorer and select D:\setup\sqldeveloper\sqldeveloper.exe.
-Start this Application with a double click.
+Start this application with a double click.
 <br clear=all>