{"id":13120,"date":"2019-12-14T17:53:32","date_gmt":"2019-12-14T17:53:32","guid":{"rendered":"https:\/\/ittutorial.org\/?p=13120"},"modified":"2019-12-14T17:57:25","modified_gmt":"2019-12-14T17:57:25","slug":"oracle-introduction-to-sql-tutorial-4","status":"publish","type":"post","link":"https:\/\/ittutorial.org\/oracle-introduction-to-sql-tutorial-4\/","title":{"rendered":"Oracle Introduction to SQL Tutorial \u2013 4"},"content":{"rendered":"

Hi everyone, we continue with the topic of functions. You can read the previous functions article here.<\/p>\n

 <\/p>\n

Raund Function<\/h3>\n

Used to round the numeric values that result from a SQL query to an upper or lower integer.<\/p>\n

Usage of: <\/strong>Select round<\/span>(column_name, number of digits to exclude) from table name<\/pre>\n
SELECT PROD_LIST_PRICE FROM SH.PRODUCTS;<\/pre>\n
\"\"<\/p>\n
If you want to print on the screen by round function according to the upper or lower value.<\/p>\n
\"\"<\/p>\n
 <\/p>\n
Trunct Function<\/h3>\n
It is used to shorten the numerical values that result from the SQL query according to the desired decimal number.<\/p>\n
Usage of: <\/strong>Select trunc (column_name, number of digits to subtract) from table_name;<\/span><\/span><\/p>\n
SELECT PROD_LIST_PRICE FROM SH.PRODUCTS;<\/p>\n
\"\"<\/p>\n
SELECT TRUNC(PROD_LIST_PRICE,1) FROM SH.PRODUCTS ORDER BY PROD_LIST_PRICE ASC;<\/pre>\n
 <\/p>\n
\"\"<\/p>\n
As shown in the picture, a digit was omitted after the comma.<\/p>\n
 <\/p>\n
Mod function<\/h3>\n
Used to represent the remainder of the numerical values from the integer part.<\/p>\n
Usage of: <\/strong>Select Mod (column_name, integer to divide<\/span>) from table_name;<\/p>\n
Let’s create a query by combining the functions we just saw.<\/p>\n
 <\/p>\n
SELECT PROD_LIST_PRICE FROM SH.PRODUCTS order by prod_list_price;<\/pre>\n
\"\"<\/p>\n
 <\/p>\n
Let’s use multiple function,<\/p>\n
select mod(round(prod_list_price,0),3) from sh.products order by prod_list_price;<\/pre>\n
\"\"<\/span><\/p>\n
As shown in the picture, we first rounded with the round function, then we took the mode of the rounded number.<\/p>\n
 <\/p>\n
See you in the next article..<\/p>\n","protected":false},"excerpt":{"rendered":"
Hi everyone, we continue with the topic of functions. You can read the previous functions article here.   Raund Function Used to round the numeric values that result from a SQL query to an upper or lower integer. Usage of: Select round(column_name, number of digits to exclude) from table name SELECT PROD_LIST_PRICE FROM SH.PRODUCTS; If …<\/p>\n","protected":false},"author":67,"featured_media":12330,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[3019],"tags":[4936,4929,4875,4883,4873,4869,4910,1340,4870,4895,4905,4935,4926,4915,4921,4919,4920,4918,4917,3192,4872,4916,4928,4876,4912,4881,4880,4890,4867,3062,4879,4891,4923,4924,4922,4925,4909,4911,4877,4896,4908,4882,4884,4897,4901,4900,4898,4902,4903,4899,4871,3015,3018,4868,4904,4906,4893,4930,4934,4914,4933,4885,4887,4913,3000,4931,4889,4927,4907,4888,4886,4892,4874,4878,4894,4932],"class_list":["post-13120","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle-sql","tag-case-insensetive","tag-create-view","tag-database-nedir","tag-insert-nedir","tag-kolay-sql","tag-mysql-sql","tag-or","tag-oracle-sql","tag-php-sql","tag-plsql","tag-right-outer-join","tag-selecting-multiple-colum","tag-sql-all-drop","tag-sql-all-statements","tag-sql-alter","tag-sql-alter-colum","tag-sql-alter-database","tag-sql-alter-statement","tag-sql-alter-table","tag-sql-and","tag-sql-baslangic-dersleri","tag-sql-creat-table","tag-sql-create-view","tag-sql-database","tag-sql-date-functions","tag-sql-dcl","tag-sql-ddl","tag-sql-delete","tag-sql-dersleri","tag-sql-distinct","tag-sql-dml","tag-sql-dml-nedir","tag-sql-drop-colum","tag-sql-drop-database","tag-sql-drop-statement","tag-sql-drop-table","tag-sql-filtering-data","tag-sql-functions","tag-sql-ifadeleri","tag-sql-ile-ne-yapilir","tag-sql-in-statement","tag-sql-insert","tag-sql-insert-nasil-yapilir","tag-sql-is-ilanlari","tag-sql-join-yapisi","tag-sql-kaynaklari","tag-sql-kullanmak","tag-sql-lef-join","tag-sql-left-outer-join","tag-sql-makaleleri","tag-sql-nasil-ogrenilir","tag-sql-nedir","tag-sql-ogrenme","tag-sql-ogrenmek","tag-sql-right-join","tag-sql-right-outer-join","tag-sql-select-islemi","tag-sql-set-auto-increment","tag-sql-sorting-results","tag-sql-subqueries","tag-sql-syntaxt-rule","tag-sql-tablo-olusturma","tag-sql-tablo-yapisi","tag-sql-to_char-function","tag-sql-tutorial","tag-sql-union-statement","tag-sql-update-islemi","tag-sql-view","tag-sql-where-statement","tag-sql-yapisi","tag-tablo-nedr","tag-tablodan-veri-cekmek","tag-temel-seviye-sql","tag-temel-seviyede-sql","tag-tsql","tag-union-table"],"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/11\/sql.png","jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/13120","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/users\/67"}],"replies":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/comments?post=13120"}],"version-history":[{"count":3,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/13120\/revisions"}],"predecessor-version":[{"id":13344,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/13120\/revisions\/13344"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media\/12330"}],"wp:attachment":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media?parent=13120"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=13120"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=13120"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}