{"id":17050,"date":"2020-10-11T12:27:37","date_gmt":"2020-10-11T12:27:37","guid":{"rendered":"https:\/\/dbtut.com\/?p=17050"},"modified":"2020-10-11T15:33:24","modified_gmt":"2020-10-11T15:33:24","slug":"what-is-pl-sql","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/what-is-pl-sql\/","title":{"rendered":"What is PL\/SQL"},"content":{"rendered":"

What is PL SQL and what is it used for?<\/h2>\n

PL\/SQL(Procedural Language extensions to SQL) is basically a programming language \u200b\u200bin Oracle database. PL\/SQL allows to use structures such as if, loop, while, function, and procedure in programming languages.<\/p>\n

Many databases use the data query language called SQL. However, advanced database management systems such as Oracle, SQL Server meet the features in various programming languages \u200b\u200bwith additional languages \u200b\u200bto use SQL language flexibly.<\/p>\n

SQL Server meets this need with T-SQL and Oracle meets this need with PL\/SQL.<\/p>\n

The main feature of these languages \u200b\u200bis that they allow the use of variables, conditional expressions, loops, functions and procedures.<\/p>\n

Thanks to these features, operations such as inserting data and processing on data are made easier.<\/p>\n

In fact, these operations can be done by programming languages \u200b\u200bby connecting to the database.<\/p>\n

However, since languages \u200b\u200bsuch as T-SQL, PL\/SQL are included in the database and compiled beforehand, it enables faster processing.<\/p>\n

PL\/SQL Structure<\/h3>\n

In many sources you can see that the PL\/SQL language is passed as a block-based language.<\/p>\n

This is because the commands written are in blocks.<\/p>\n

The PL\/SQL structure is as follows.<\/p>\n

DECLARE\r\n   -- definitions\r\nBEGIN\r\n   -- commands\r\nEXCEPTION\r\n   -- error management\r\nEND;<\/pre>\n
The DECLARE keyword in the PL\/SQL structure is the part where the variables to be used in the PL\/SQL commands are defined and it is not mandatory.<\/p>\n
BEGIN and END is the part where SQL and PL\/SQL commands will be run and it is mandatory to use.<\/p>\n
The part determined by the EXCEPTION keyword is the area used to find and manage errors in SQL or PL\/SQL commands and it is not mandatory.<\/p>\n
What is pl\/sql used for?<\/h3>\n
PL\/SQL can be used after Oracle installation, there is no need for an additional installation.<\/p>\n
PL\/SQL commands are used by writing in SQL Plus or SQL Developer tool in Oracle.<\/p>\n
You can see the sample code that writes Hello Oracle on the screen.<\/p>\n
SET SERVEROUTPUT ON;\r\nBEGIN\r\n   DBMS_OUTPUT.put_line('Hello Oracle!');\r\nEND;<\/pre>\n
You can see the sample code that writes Hello Oracle on the screen using variable.<\/p>\n
SET SERVEROUTPUT ON;\r\nDECLARE\r\n    v_message VARCHAR2(20) := 'Hello Oracle!';\r\nBEGIN\r\n   DBMS_OUTPUT.put_line (v_messagge);\r\nEND;<\/pre>\n
NOTE:<\/strong> Oracle PL\/SQL uses the syntax of Pascal and ADA languages.<\/p>\n
You can find more detailed information about below topics in the below link.<\/p>\n
PL\/SQL Tutorial<\/a><\/strong><\/p>\n
You will find below topics in this article.<\/p>\n
    \n
  1. What is PL\/SQL<\/strong><\/a><\/li>\n
  2. Oracle PL\/SQL Data Types and Variables and Literals<\/strong><\/a><\/li>\n
  3. Oracle PL\/SQL Operators<\/strong><\/a><\/li>\n
  4. Oracle PL\/SQL Conditional Statements<\/strong><\/a><\/li>\n
  5. Oracle PL\/SQL Loops<\/strong><\/a><\/li>\n
  6. Oracle PL\/SQL Procedures and Procedure Parameters<\/strong><\/a><\/li>\n
  7. Oracle PL\/SQL Functions<\/strong><\/a><\/li>\n
  8. Oracle PL\/SQL Cursor<\/strong><\/a><\/li>\n
  9. Oracle PL\/SQL Records<\/strong><\/a><\/li>\n
  10. Oracle PL\/SQL Exception<\/strong><\/a><\/li>\n
  11. Oracle PL\/SQL Trigger<\/strong><\/a><\/li>\n
  12. Oracle PL\/SQL Packages<\/strong><\/a><\/li>\n
  13. Oracle PL\/SQL Collections<\/strong><\/a><\/li>\n<\/ol>\n
    You can find more information about pl\/sql at docs.oracle.com<\/a><\/p>\n
    <\/div>\n
    <\/path><\/svg><\/i> \"Loading\"<\/p>\n
    <\/div>\n","protected":false},"excerpt":{"rendered":"
    What is PL SQL and what is it used for? PL\/SQL(Procedural Language extensions to SQL) is basically a programming language \u200b\u200bin Oracle database. PL\/SQL allows to use structures such as if, loop, while, function, and procedure in programming languages. Many databases use the data query language called SQL. However, advanced database management systems such as …<\/p>\n
    <\/div>\n
    <\/path><\/svg><\/i> \"Loading\"<\/p>\n
    <\/div>\n","protected":false},"author":485,"featured_media":17107,"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,"footnotes":""},"categories":[4],"tags":[10052,10054,10051,10053],"class_list":["post-17050","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle","tag-pl-sql-structure","tag-what-is-oracle-pl-sql","tag-what-is-pl-sql-used-for","tag-what-is-pl-sql"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":152,"today_views":0},"yoast_head":"\nWhat is PL\/SQL - Database Tutorials<\/title>\n<meta name=\"description\" content=\"This article contains information about What is PL\/SQL and what is it used for, pl\/sql structure and simple example code.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/what-is-pl-sql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What is PL\/SQL - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"This article contains information about What is PL\/SQL and what is it used for, pl\/sql structure and simple example code.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/what-is-pl-sql\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2020-10-11T12:27:37+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-10-11T15:33:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/10\/whatisplsql.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"851\" \/>\n\t<meta property=\"og:image:height\" content=\"523\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Yusuf SEZER\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Yusuf SEZER\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/what-is-pl-sql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/what-is-pl-sql\/\"},\"author\":{\"name\":\"Yusuf SEZER\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/be8bf54494b6a89e626cbed2c940599a\"},\"headline\":\"What is PL\/SQL\",\"datePublished\":\"2020-10-11T12:27:37+00:00\",\"dateModified\":\"2020-10-11T15:33:24+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/what-is-pl-sql\/\"},\"wordCount\":454,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/what-is-pl-sql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/10\/whatisplsql.jpg\",\"keywords\":[\"PL\/SQL Structure\",\"what is oracle pl\/sql\",\"what is pl\/sql used for\",\"What is PL\/SQL?\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/what-is-pl-sql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/what-is-pl-sql\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/what-is-pl-sql\/\",\"name\":\"What is PL\/SQL - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/what-is-pl-sql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/what-is-pl-sql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/10\/whatisplsql.jpg\",\"datePublished\":\"2020-10-11T12:27:37+00:00\",\"dateModified\":\"2020-10-11T15:33:24+00:00\",\"description\":\"This article contains information about What is PL\/SQL and what is it used for, pl\/sql structure and simple example code.\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/what-is-pl-sql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/what-is-pl-sql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/what-is-pl-sql\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/10\/whatisplsql.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/10\/whatisplsql.jpg\",\"width\":851,\"height\":523},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/what-is-pl-sql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"What is PL\/SQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/be8bf54494b6a89e626cbed2c940599a\",\"name\":\"Yusuf SEZER\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/19675b3db2d4ce370af047187123e2055a2b254ede3f0e7d9bc934da478146f7?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/19675b3db2d4ce370af047187123e2055a2b254ede3f0e7d9bc934da478146f7?s=96&d=mm&r=g\",\"caption\":\"Yusuf SEZER\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/yusufsezer\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"What is PL\/SQL - Database Tutorials","description":"This article contains information about What is PL\/SQL and what is it used for, pl\/sql structure and simple example code.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/what-is-pl-sql\/","og_locale":"en_US","og_type":"article","og_title":"What is PL\/SQL - Database Tutorials","og_description":"This article contains information about What is PL\/SQL and what is it used for, pl\/sql structure and simple example code.","og_url":"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/what-is-pl-sql\/","og_site_name":"Database Tutorials","article_published_time":"2020-10-11T12:27:37+00:00","article_modified_time":"2020-10-11T15:33:24+00:00","og_image":[{"width":851,"height":523,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/10\/whatisplsql.jpg","type":"image\/jpeg"}],"author":"Yusuf SEZER","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Yusuf SEZER","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/what-is-pl-sql\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/what-is-pl-sql\/"},"author":{"name":"Yusuf SEZER","@id":"https:\/\/dbtut.com\/#\/schema\/person\/be8bf54494b6a89e626cbed2c940599a"},"headline":"What is PL\/SQL","datePublished":"2020-10-11T12:27:37+00:00","dateModified":"2020-10-11T15:33:24+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/what-is-pl-sql\/"},"wordCount":454,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/what-is-pl-sql\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/10\/whatisplsql.jpg","keywords":["PL\/SQL Structure","what is oracle pl\/sql","what is pl\/sql used for","What is PL\/SQL?"],"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2020\/10\/11\/what-is-pl-sql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/what-is-pl-sql\/","url":"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/what-is-pl-sql\/","name":"What is PL\/SQL - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/what-is-pl-sql\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/what-is-pl-sql\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/10\/whatisplsql.jpg","datePublished":"2020-10-11T12:27:37+00:00","dateModified":"2020-10-11T15:33:24+00:00","description":"This article contains information about What is PL\/SQL and what is it used for, pl\/sql structure and simple example code.","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/what-is-pl-sql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2020\/10\/11\/what-is-pl-sql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/what-is-pl-sql\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/10\/whatisplsql.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/10\/whatisplsql.jpg","width":851,"height":523},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/what-is-pl-sql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"What is PL\/SQL"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/be8bf54494b6a89e626cbed2c940599a","name":"Yusuf SEZER","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/19675b3db2d4ce370af047187123e2055a2b254ede3f0e7d9bc934da478146f7?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/19675b3db2d4ce370af047187123e2055a2b254ede3f0e7d9bc934da478146f7?s=96&d=mm&r=g","caption":"Yusuf SEZER"},"url":"https:\/\/dbtut.com\/index.php\/author\/yusufsezer\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/17050","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/485"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=17050"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/17050\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/17107"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=17050"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=17050"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=17050"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}