oracle connector table action clariifcation

vamsi_4a6 · Post by **vamsi_4a6** » Thu Jan 19, 2017 2:52 am

currently i am using below sql statement in oracle connector with writemode:-delete table action is having following options:-create,append,truncate,replace.
what is the purpose of this table action option? It is not clear to me and anybody give input on this
a)DELETE from table1 where CLAIMNUMBER = ORCHESTRATE.CLAIMNUMBER;

chulett · Post by **chulett** » Thu Jan 19, 2017 7:59 am

Have you tried reading the documentation? For example, the Connectivity Guide for Oracle Databases pdf? I'd start there. A search for "Table 11" will get you to the right spot.

vamsi_4a6 · Post by **vamsi_4a6** » Fri Jan 20, 2017 3:04 am

I do not want to so any create,truncate,replace etc.Just i want to delete the data based on above sql.I have gone through
manual.significance of table action is not clear.can anobody provide input on this

table actions:-
options:-create=only create
append=
truncate=only truncate
replace=drop+create

chulett · Post by **chulett** » Fri Jan 20, 2017 8:05 am

Append = what? The entry in the table I mentioned shows it as the default action and very clearly explains what it does. Nothing. The others are there for when you want something at the table level to be done.

qt_ky · Post by **qt_ky** » Fri Jan 20, 2017 8:18 am

vamsi_4a6 wrote:I have gone through manual.significance of table action is not clear.

I have to disagree. The manual very clearly explains the Table action property and each value. Please go through it again.