Skip to main content
Question

Export of SQL update script for Oracle


lazarlubomir
Contributor
Forum|alt.badge.img+10

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

3 replies

erik_jan
Contributor
Forum|alt.badge.img+18
  • Contributor
  • January 31, 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.


itay
Supporter
Forum|alt.badge.img+17
  • Supporter
  • January 31, 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.


lazarlubomir
Contributor
Forum|alt.badge.img+10
  • Author
  • Contributor
  • February 1, 2017

Thank You! Both tips helped me so much!


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings