# Update query

**URL:** <https://www.batmunkh.net/t/update-query/35>\
**Category:** Oracle Database\
**Tags:** plsql, sql\
**Created:** [December 6, 2016, 2:52am UTC](https://www.batmunkh.net/t/update-query/35 "2016-12-06T02:52:47Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Hashirama](https://www.batmunkh.net/user_avatar/www.batmunkh.net/hashirama/32/13_2.png) [@Hashirama](https://www.batmunkh.net/u/Hashirama)\
**Post date:** [December 6, 2016, 2:52am UTC](https://www.batmunkh.net/t/update-query/35/1 "2016-12-06T02:52:47Z")

</div>

Сайн байна уу,  
Oracle update trigger дээр доорх кюри ажиллаж байгаа:

```auto
`UPDATE TABLE1 
SET QUANTITY = QUANTITY + 1, 
PERCENT = (QUANTITY * 100) / TOTAL_QUANTITY 
WHERE ID = :NEW.ID`

```

Энэ кюри дээр QUANTITY талбарын утга PERCENT бодож байгаа хэсэгт 1-ээр нэмэгдсэн утга орж ирэх үү? Эсвэл хуучин утгаараа орж ирэх үү?

---

<div class="post-metadata">

**Author:** ![saruulbat](https://www.batmunkh.net/user_avatar/www.batmunkh.net/saruulbat/32/8_2.png) [@saruulbat](https://www.batmunkh.net/u/saruulbat)\
**Post date:** [December 6, 2016, 3:24am UTC](https://www.batmunkh.net/t/update-query/35/2 "2016-12-06T03:24:45Z")

</div>

Миний бодлоор хуучин утгаараа бодогдох байх. Ер нь бол тестлээл үзчих хэрэгтэй дээ 😃

---

<div class="post-metadata">

**Author:** ![batmunkh](https://www.batmunkh.net/user_avatar/www.batmunkh.net/batmunkh/32/297_2.png) [@batmunkh](https://www.batmunkh.net/u/batmunkh)\
**Post date:** [December 6, 2016, 3:26am UTC](https://www.batmunkh.net/t/update-query/35/3 "2016-12-06T03:26:54Z")

</div>

Query ажиллаж дууссаны дараагаар QUANTITY утга нэгээр нэмэгдэж хадгалагдах тул хуучин утга орж ирнэ.

---

<div class="post-metadata">

**Author:** ![batmunkh](https://www.batmunkh.net/user_avatar/www.batmunkh.net/batmunkh/32/297_2.png) [@batmunkh](https://www.batmunkh.net/u/batmunkh)\
**Post date:** [December 6, 2016, 3:40am UTC](https://www.batmunkh.net/t/update-query/35/5 "2016-12-06T03:40:00Z")

</div>

Туршилт:

 ![](https://www.batmunkh.net/uploads/default/original/1X/fe5d71ec731c3a609b767724d029577117f14c76.jpg)

---

<div class="post-metadata">

**Author:** ![tumenzul](https://www.batmunkh.net/user_avatar/www.batmunkh.net/tumenzul/32/6_2.png) [@tumenzul](https://www.batmunkh.net/u/tumenzul)\
**Post date:** [December 6, 2016, 3:40am UTC](https://www.batmunkh.net/t/update-query/35/6 "2016-12-06T03:40:47Z")

</div>

Туршиж үзэхэд бол `PERCENT = (QUANTITY * 100) / TOTAL_QUANTITY` энэ хэсэгт `QUANTITY = 250` байна.

SQL -г ажиллуулахаас өмнө:

 ![](https://www.batmunkh.net/uploads/default/original/1X/568ccff14f71726dddbe049b8e9b7c54fe77092c.png)

PL/SQL

 ![](https://www.batmunkh.net/uploads/default/original/1X/dfadb376a28e9911c177cd2521abd3add9778b9d.png)

SQL-г ажиллуулсны дараа

 ![](https://www.batmunkh.net/uploads/default/original/1X/c2f43ef1119f946c408f76f669039d8a21b0fd77.png)

---

<div class="post-metadata">

**Author:** ![Hashirama](https://www.batmunkh.net/user_avatar/www.batmunkh.net/hashirama/32/13_2.png) [@Hashirama](https://www.batmunkh.net/u/Hashirama)\
**Post date:** [December 6, 2016, 3:46am UTC](https://www.batmunkh.net/t/update-query/35/7 "2016-12-06T03:46:01Z")

</div>

Тэгэхээр хуучин утгаа авна гэсэн үгүү?

---

<div class="post-metadata">

**Author:** ![tumenzul](https://www.batmunkh.net/user_avatar/www.batmunkh.net/tumenzul/32/6_2.png) [@tumenzul](https://www.batmunkh.net/u/tumenzul)\
**Post date:** [December 6, 2016, 3:47am UTC](https://www.batmunkh.net/t/update-query/35/8 "2016-12-06T03:47:05Z")

</div>

> [@Hashirama](#):
>
> Тэгэхээр хуучин утгаа авна гэсэн үгүү?

Тийм, хуучин утгаа авна

---

<div class="post-metadata">

**Author:** ![Hashirama](https://www.batmunkh.net/user_avatar/www.batmunkh.net/hashirama/32/13_2.png) [@Hashirama](https://www.batmunkh.net/u/Hashirama)\
**Post date:** [December 6, 2016, 4:01am UTC](https://www.batmunkh.net/t/update-query/35/9 "2016-12-06T04:01:17Z")

</div>

Баярлалаа. Асуудал шийдэгдлээ.