Re: how to load huge data from oracle with insert and update !!!
We do not recommend using QilkView for updating of backend data sources, we are primarily an analytics tool, not a database update tool, so not really sure what you are attempting to do, but I would believe it is likely best done using straight SQL in the DB side. If you can provide further information regarding the full use case here, we may be able to provide a better answer, but this is the best I can do at the moment.
It is possible to make SQL Execute and other calls from our script editor, but you must enable the setting in the attached screenshot in that case, but again, this is not something we recommend doing.
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
Note:Be careful when updating records in a table! Notice the WHERE clause in the UPDATE statement. The WHERE clause specifies which record(s) that should be updated. If you omit the WHERE clause, all records in the table will be updated!