{"id":10626,"date":"2019-07-22T19:56:00","date_gmt":"2019-07-22T19:56:00","guid":{"rendered":"https:\/\/ittutorial.org\/?p=10626"},"modified":"2019-07-22T19:59:00","modified_gmt":"2019-07-22T19:59:00","slug":"pl-sql-programing-1-introduction-to-pl-sql","status":"publish","type":"post","link":"https:\/\/ittutorial.org\/pl-sql-programing-1-introduction-to-pl-sql\/","title":{"rendered":"PL\/SQL Programing -1 Introduction to PL\/SQL"},"content":{"rendered":"<p>Hi, we are starting a new tutorial. In this tutorial we&#8217;ll look PL\/SQL programing, examples and much more.<\/p>\n<p>&nbsp;<\/p>\n<p><span class=\"tlid-translation translation\" lang=\"en\"><span title=\"\">PL \/ SQL is a programming language created by adding the features of the SQL query language developed by Oracle.<\/span> <span class=\"\" title=\"\">Since it is a procedural structure, it can do what SQL cannot do within the code.<\/span><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span class=\"tlid-translation translation\" lang=\"en\"><span title=\"\">The picture shows the PL \/ SQL architecture.<\/span> <span title=\"\">The written code is processed and returned in two different environments.<\/span> <span class=\"\" title=\"\">When the developed code is divided into procedures and normal SQL queries, it can be said that it receives the data in the SQL side database and the procedure does the things SQL cannot do as the software language.<\/span><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"https:\/\/docs.oracle.com\/cd\/B19306_01\/appdev.102\/b14261\/lnpls004.gif\" alt=\"https:\/\/docs.oracle.com\/cd\/B19306_01\/appdev.102\/b14261\/lnpls004.gif\" width=\"562\" height=\"378\" \/><\/p>\n<h6>PL\/SQL Key Futures:<\/h6>\n<ul>\n<li><span class=\"tlid-translation translation\" lang=\"en\"><span class=\"\" title=\"\">Codes work in block structures<\/span><\/span><\/li>\n<li><span class=\"tlid-translation translation\" lang=\"en\"><span class=\"\" title=\"\">Procedures, Functions, Trigger, Package procedures can develop and use programming techniques<\/span><\/span><\/li>\n<li><span class=\"tlid-translation translation\" lang=\"en\"><span title=\"\">We can create our own error conditions and catch them.<\/span><\/span><\/li>\n<li><span class=\"tlid-translation translation\" lang=\"en\"><span class=\"\" title=\"\">Used only for Oracle database.<\/span><\/span><\/li>\n<\/ul>\n<h6>PL\/SQL Blok Structure:<\/h6>\n<p><span class=\"tlid-translation translation\" lang=\"en\"><span class=\"\" title=\"\">The core of PL \/ SQL is DECLARE-BEGIN-END.<\/span> <span class=\"\" title=\"\">PL \/ SQL has three block structures;<\/span><\/span><\/p>\n<ul>\n<li><span class=\"tlid-translation translation\" lang=\"en\"><span class=\"\" title=\"\">Simple (Anonymous) Block Structure<\/span><\/span><\/li>\n<li>Function Block Structure<\/li>\n<li>Procedure Block Structure<\/li>\n<\/ul>\n<p><span class=\"tlid-translation translation\" lang=\"en\"><span class=\"\" title=\"\">I&#8217;ll conclude this post here, and the next post will continue with a simple block structure.<\/span><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hi, we are starting a new tutorial. In this tutorial we&#8217;ll look PL\/SQL programing, examples and much more. &nbsp; PL \/ SQL is a programming language created by adding the features of the SQL query language developed by Oracle. Since it is a procedural structure, it can do what SQL cannot do within the code. &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,3928,3931,3630,3658,3923,3632,3929,3927,3932,3925,3709,3926,3720,3718,3921,3922,3924,3710,3933,1572,3719],"class_list":["post-10626","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-pl-sql","tag-basit-plsql","tag-bastan-sona-pl-sql","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-baslangic-dersleri","tag-plsql-case-yapisi","tag-plsql-degisken-atama","tag-plsql-donguler","tag-plsql-fonksiyonlar","tag-plsql-if-else","tag-plsql-kitaplari","tag-plsql-kurallari","tag-plsql-learning","tag-plsql-lessons","tag-plsql-ogrenmek","tag-plsql-prosedur","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\/10626","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=10626"}],"version-history":[{"count":1,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/10626\/revisions"}],"predecessor-version":[{"id":10629,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/10626\/revisions\/10629"}],"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=10626"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=10626"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=10626"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}