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
Question
Export of SQL update script for Oracle
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+26- Contributor
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.
+18- Supporter
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.