{"id":10791,"date":"2019-07-29T07:00:40","date_gmt":"2019-07-29T07:00:40","guid":{"rendered":"https:\/\/ittutorial.org\/?p=10791"},"modified":"2019-07-29T07:02:20","modified_gmt":"2019-07-29T07:02:20","slug":"plsql-programing-3","status":"publish","type":"post","link":"https:\/\/ittutorial.org\/plsql-programing-3\/","title":{"rendered":"PLSQL Programing -3"},"content":{"rendered":"<p><span class=\"tlid-translation translation\" lang=\"en\"><span title=\"\">Hi, I continue to write PL \/ SQL.<\/span> <span class=\"\" title=\"\">In the previous article, we have examined the simple block structure and made a small start, now we will continue with the function and procedure blocks.<\/span> <span class=\"\" title=\"\">If you haven&#8217;t looked at my previous post, you can find it here.<\/span><\/span><\/p>\n<blockquote class=\"wp-embedded-content\" data-secret=\"dIMhCnQBqB\"><p><a href=\"https:\/\/ittutorial.org\/pl-sql-programing-2\/\">PL\/SQL Programing -2<\/a><\/p><\/blockquote>\n<p><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;PL\/SQL Programing -2&#8221; &#8212; IT Tutorial\" src=\"https:\/\/ittutorial.org\/pl-sql-programing-2\/embed\/#?secret=brureHeu1R#?secret=dIMhCnQBqB\" data-secret=\"dIMhCnQBqB\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n<p><span class=\"tlid-translation translation\" lang=\"en\"><span class=\"\" title=\"\">The functions return a single value in the code, the code that will run in the function runs in the BEGIN-END block, I will refer to the data description later.<\/span><\/span><\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"tlid-translation translation\" lang=\"en\"><span class=\"\" title=\"\">Function Block:<\/span><\/span><\/h3>\n<p>Syntax rule is\u00a0 ,<\/p>\n<pre>FUNCTION function_name\r\n\r\nRETURN data_type\r\n\r\nIS\r\n\r\nBEGIN\r\n\r\nPL\/SQL code\r\n\r\nEND\r\n<\/pre>\n<h3><span class=\"tlid-translation translation\" lang=\"en\"><span class=\"\" title=\"\">Procedure Block:<\/span><\/span><\/h3>\n<p><span class=\"tlid-translation translation\" lang=\"en\"><span title=\"\">Unlike the function block, it can return more than one value to the result value.<\/span> <span class=\"\" title=\"\">I will share your detailed narrative in future articles.<\/span><\/span><\/p>\n<pre>PROCEDURE prodecure_name\r\n\r\nIS\r\n\r\nBEGIN\r\n\r\nPL\/SQL code\r\n\r\nEND\r\n<\/pre>\n<h3>PL\/SQL Data A<span class=\"tlid-translation translation\" lang=\"en\"><span class=\"\" title=\"\">ssignment :<br \/>\n<\/span><\/span><\/h3>\n<p><span class=\"tlid-translation translation\" lang=\"en\"><span title=\"\">As with any software language, we can assign specific values to variables in PL \/ SQL.<\/span> <span class=\"\" title=\"\">For these operations we use certain symbols, for example in assignment operations: = with the symbol assignment process.<\/span><\/span><\/p>\n<pre>DECLARE\r\n\r\nisim VARCHAR2(40);\r\n\r\nBEGIN\r\n\r\nisim:='MUSTAFA KEMAL ATAT\u00dcRK';\r\n\r\nDBMS_OUTPUT.PUT_LINE(isim);\r\n\r\nEND\r\n\/\r\n<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-8487 loaded\" src=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/04\/Screenshot_39-300x184.png\" alt=\"\" width=\"657\" height=\"403\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/04\/Screenshot_39-300x184.png 300w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/04\/Screenshot_39.png 384w\" sizes=\"auto, (max-width: 657px) 100vw, 657px\" \/><\/p>\n<p><span class=\"tlid-translation translation\" lang=\"en\"><span class=\"\" title=\"\">We can also use SQL statements (UPDATE-INSERT-DELETE-SELECT, etc.) in the code.<\/span> <span class=\"\" title=\"\">Let&#8217;s continue with an example<\/span><\/span>,<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-8488 loaded\" src=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/04\/Screenshot_40-300x113.png\" alt=\"\" width=\"788\" height=\"298\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/04\/Screenshot_40-300x113.png 300w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/04\/Screenshot_40.png 474w\" sizes=\"auto, (max-width: 788px) 100vw, 788px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><span class=\"tlid-translation translation\" lang=\"en\"><span title=\"\">As you can see, in this way, we can add and run the inquiries into our plsql code.<\/span> <span title=\"\">In the next post I&#8217;ll continue with the characters data types and variables,<\/span><\/span><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hi, I continue to write PL \/ SQL. In the previous article, we have examined the simple block structure and made a small start, now we will continue with the function and procedure blocks. If you haven&#8217;t looked at my previous post, you can find it here. PL\/SQL Programing -2 The functions return a single &hellip;<\/p>\n","protected":false},"author":67,"featured_media":10628,"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":[3647],"tags":[3930,3664,3626,3928,3931,3630,3658,3923,3632,5629,3929,5628,3927,5625,5626,3932,5630,3925,3709,5623,5627,3926,3720,3718,3921,3922,3924,5624,3710,5622,3933,1572,3719],"class_list":["post-10791","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-pl-sql","tag-basit-plsql","tag-bastan-sona-pl-sql","tag-declare-begin-end","tag-pl-sql-case-when","tag-pl-sql-degiskenler","tag-pl-sql-dersleri","tag-pl-sql-document","tag-pl-sql-lesson","tag-pl-sql-nedir","tag-plsql-administration","tag-plsql-baslangic-dersleri","tag-plsql-case-when","tag-plsql-case-yapisi","tag-plsql-cursor","tag-plsql-declare-begin-end","tag-plsql-degisken-atama","tag-plsql-developer","tag-plsql-donguler","tag-plsql-fonksiyonlar","tag-plsql-function","tag-plsql-if-clouse","tag-plsql-if-else","tag-plsql-kitaplari","tag-plsql-kurallari","tag-plsql-learning","tag-plsql-lessons","tag-plsql-ogrenmek","tag-plsql-procedure","tag-plsql-prosedur","tag-plsql-statement","tag-set-serveroputput-on","tag-sql","tag-sql-ve-plsql"],"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/pl-sql.png","jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/10791","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=10791"}],"version-history":[{"count":1,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/10791\/revisions"}],"predecessor-version":[{"id":10793,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/10791\/revisions\/10793"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media\/10628"}],"wp:attachment":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media?parent=10791"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=10791"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=10791"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}