[mongoDB] MongoDB upsert() merge equivalent in Oracle database

Oracle database offers interesting option to perform all the DML operations using a single MERGE. similar to this in mongoDB starting 2.6 version the latest upsert() makes it possible to perform the following
Consider the following commands:
db.collection.find(query criteria).upsert().update(criteria);
db.collection.find(query criteria).upsert().updateOne(criteria);
db.collection.find(query criteria).upsert().replaceOne(criteria);
When documents matching query criteria is found it is either updated/replaced based on query conditions. If no document matching criteria is found, new document is inserted. This works same way as in Oracle MERGE
What is the way to pull protected fields using upsert?
It is possible as follows
{upsert:true,
select:{“protectedfield”:1} }
From mongoDB version 2.7.7 onwards it is possible to determine if upsert() uses correct indexes using explain()

경축! 아무것도 안하여 에스천사게임즈가 새로운 모습으로 재오픈 하였습니다.
어린이용이며, 설치가 필요없는 브라우저 게임입니다.
https://s1004games.com

[출처] http://www.learnersreference.com/mongodb-upsert-merge-equivalent-in-oracle-database/