Hello,
please, I just wanna ask, if FME Desktop is able to generate SQL update script for ORACLE database, e.g. in sql format?
Example:
UPDATE sample
SET band='CCC'
WHERE fid=123456
Thank You for tips!
Lubo
Userlevel 2
+16
- Contributor
- 2180 replies
-
31 January 2017
A way of doing this is concatenating a text attribute using the StringConcatenator or the AttributeCreator and writing the text (SQL statement) to a Text File Writer.
+16
- Contributor
- 1425 replies
-
31 January 2017
why not it's a matter of creating the statement and passing it to the sql executor to be executed...
and that is exactly what a database writer will do if you use it to update the table, just look at the log.
Hope this helps.
+1
Thank You! Both tips helped me so much!
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.