{"id":17147,"date":"2020-10-11T12:25:03","date_gmt":"2020-10-11T12:25:03","guid":{"rendered":"https:\/\/dbtut.com\/?p=17147"},"modified":"2020-10-11T15:25:16","modified_gmt":"2020-10-11T15:25:16","slug":"oracle-pl-sql-procedures-and-procedure-parameters","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-procedures-and-procedure-parameters\/","title":{"rendered":"Oracle PL\/SQL Procedures and Procedure Parameters"},"content":{"rendered":"

This article contains information about PL\/SQL Procedures and parameters in procedures such as IN, OUT, IN OUT.<\/p>\n

What is Procedure in Oracle?<\/h2>\n

PL\/SQL Procedures are the structures that keep Oracle PL\/SQL commands under a name and run them when needed.<\/p>\n

Procedures are compiled the first time they run and a query plan is created.<\/p>\n

When you run stored procedures next time, they use this query plan.<\/p>\n

The keywords to be used when creating the procedure are as follows.<\/p>\n

CREATE [OR REPLACE] PROCEDURE procedure_name\r\n[(parameter_name [IN | OUT | IN OUT] data_type [, ...])]\r\n{IS | AS}\r\nBEGIN\r\n    -- Commands\r\nEND procedure_name;<\/pre>\n
The REPLACE keyword included in the command is not mandatory. However, it would be beneficial to use it as it will throw an error if you try to recreate an existing procedure. Let’s create a sample procedure.<\/p>\n
SET SERVEROUTPUT ON;\r\nCREATE OR REPLACE PROCEDURE First_SP\r\nAS\r\nBEGIN\r\n   DBMS_OUTPUT.put_line('Hello Oracle!');\r\nEND;<\/pre>\n
Once the procedure is created, we can run it as follows.<\/p>\n
EXECUTE First_SP<\/pre>\n
EXEC First_SP<\/pre>\n
The commands in the procedure will be executed each time the procedure is run.<\/p>\n
Procedure Parameters in Oracle<\/h2>\n
Another important feature of the procedure structure is the possibility to take parameters.<\/p>\n
IN Parameter in PL\/SQL Procedures<\/h3>\n
If the parameter is marked with IN, the parameter is passed only to the procedure.<\/p>\n
OUT Parameter in PL\/SQL Procedures<\/h3>\n
If the parameter is marked OUT, the parameter sends out data.<\/p>\n
IN OUT Parameter in PL\/SQL Procedures<\/h3>\n
If the parameter is marked with IN OUT, it takes both IN and OUT.<\/p>\n
PL\/SQL Procedure example with parameters<\/h2>\n
In the example below, the loop start and end values are taken as parameters.<\/p>\n
SET SERVEROUTPUT ON;\r\nCREATE OR REPLACE PROCEDURE MY_LOOP (\r\n    START_VALUE IN PLS_INTEGER,\r\n    END_VALUE IN PLS_INTEGER\r\n) AS\r\nBEGIN\r\n    FOR v_number IN START_VALUE .. END_VALUE LOOP\r\n        DBMS_OUTPUT.put_line('Command executed ' ||v_number || ' times.');\r\n    END LOOP;\r\nEND;<\/pre>\n
EXECUTE MY_LOOP(45,50)<\/pre>\n
SYS.all_procedures table can be used to get information about the created procedures.<\/p>\n
SELECT * FROM SYS.all_procedures WHERE OWNER = 'USER_NAME';<\/pre>\n
The following command is used to delete the created procedure.<\/p>\n
DROP PROCEDURE procedure_name;<\/pre>\n
DROP PROCEDURE MY_LOOP;<\/pre>\n
The reason for using the procedures is to ensure that the written commands are securely stored in the database management system.<\/p>\n
Also, the created procedures will work better because they are compiled beforehand.<\/p>\n
When data is received from a table with any programming language, the SQL sentence must first be written and sent to the database.<\/p>\n
The sent SQL statement is executed after it is checked by the database management system.<\/p>\n
However, since the procedures are compiled beforehand, it is operated without recompilation, thus ensuring performance.<\/p>\n
The procedures are similar to function structures, causing confusion.<\/p>\n
While procedures are not required to return values, functions must return values.<\/p>\n
Procedures are generally used in CRUD processes.<\/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 procedures at docs.oracle.com<\/a><\/p>\n
    <\/div>\n
    <\/path><\/svg><\/i> \"Loading\"<\/p>\n
    <\/div>\n","protected":false},"excerpt":{"rendered":"
    This article contains information about PL\/SQL Procedures and parameters in procedures such as IN, OUT, IN OUT. What is Procedure in Oracle? PL\/SQL Procedures are the structures that keep Oracle PL\/SQL commands under a name and run them when needed. Procedures are compiled the first time they run and a query plan is created. When …<\/p>\n
    <\/div>\n
    <\/path><\/svg><\/i> \"Loading\"<\/p>\n
    <\/div>\n","protected":false},"author":485,"featured_media":17148,"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":[9274,9272,9273,10079,10077,10078],"class_list":["post-17147","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle","tag-in-out-parameter-in-pl-sql-procedures","tag-in-parameter-in-pl-sql-procedures","tag-out-parameter-in-pl-sql-procedures","tag-pl-sql-procedure-example-with-parameters","tag-procedure-parameters-in-oracle","tag-what-is-procedure-in-oracle"],"aioseo_notices":[],"yoast_head":"\nOracle PL\/SQL Procedures and Procedure Parameters - Database Tutorials<\/title>\n<meta name=\"description\" content=\"This article contains information about PL\/SQL Procedures and parameters in procedures such as IN, OUT, IN OUT and examples.\" \/>\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\/oracle-pl-sql-procedures-and-procedure-parameters\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle PL\/SQL Procedures and Procedure Parameters - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"This article contains information about PL\/SQL Procedures and parameters in procedures such as IN, OUT, IN OUT and examples.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-procedures-and-procedure-parameters\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2020-10-11T12:25:03+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-10-11T15:25:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/10\/plsqlprocedures.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"820\" \/>\n\t<meta property=\"og:image:height\" content=\"522\" \/>\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=\"3 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\/oracle-pl-sql-procedures-and-procedure-parameters\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-procedures-and-procedure-parameters\/\"},\"author\":{\"name\":\"Yusuf SEZER\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/be8bf54494b6a89e626cbed2c940599a\"},\"headline\":\"Oracle PL\/SQL Procedures and Procedure Parameters\",\"datePublished\":\"2020-10-11T12:25:03+00:00\",\"dateModified\":\"2020-10-11T15:25:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-procedures-and-procedure-parameters\/\"},\"wordCount\":480,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-procedures-and-procedure-parameters\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/10\/plsqlprocedures.jpg\",\"keywords\":[\"IN OUT Parameter in PL\/SQL Procedures\",\"IN Parameter in PL\/SQL Procedures\",\"OUT Parameter in PL\/SQL Procedures\",\"pl\/sql procedure example with parameters\",\"Procedure Parameters in Oracle\",\"What is Procedure in Oracle?\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-procedures-and-procedure-parameters\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-procedures-and-procedure-parameters\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-procedures-and-procedure-parameters\/\",\"name\":\"Oracle PL\/SQL Procedures and Procedure Parameters - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-procedures-and-procedure-parameters\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-procedures-and-procedure-parameters\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/10\/plsqlprocedures.jpg\",\"datePublished\":\"2020-10-11T12:25:03+00:00\",\"dateModified\":\"2020-10-11T15:25:16+00:00\",\"description\":\"This article contains information about PL\/SQL Procedures and parameters in procedures such as IN, OUT, IN OUT and examples.\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-procedures-and-procedure-parameters\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-procedures-and-procedure-parameters\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-procedures-and-procedure-parameters\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/10\/plsqlprocedures.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/10\/plsqlprocedures.jpg\",\"width\":820,\"height\":522},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-procedures-and-procedure-parameters\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle PL\/SQL Procedures and Procedure Parameters\"}]},{\"@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":"Oracle PL\/SQL Procedures and Procedure Parameters - Database Tutorials","description":"This article contains information about PL\/SQL Procedures and parameters in procedures such as IN, OUT, IN OUT and examples.","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\/oracle-pl-sql-procedures-and-procedure-parameters\/","og_locale":"en_US","og_type":"article","og_title":"Oracle PL\/SQL Procedures and Procedure Parameters - Database Tutorials","og_description":"This article contains information about PL\/SQL Procedures and parameters in procedures such as IN, OUT, IN OUT and examples.","og_url":"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-procedures-and-procedure-parameters\/","og_site_name":"Database Tutorials","article_published_time":"2020-10-11T12:25:03+00:00","article_modified_time":"2020-10-11T15:25:16+00:00","og_image":[{"width":820,"height":522,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/10\/plsqlprocedures.jpg","type":"image\/jpeg"}],"author":"Yusuf SEZER","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Yusuf SEZER","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-procedures-and-procedure-parameters\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-procedures-and-procedure-parameters\/"},"author":{"name":"Yusuf SEZER","@id":"https:\/\/dbtut.com\/#\/schema\/person\/be8bf54494b6a89e626cbed2c940599a"},"headline":"Oracle PL\/SQL Procedures and Procedure Parameters","datePublished":"2020-10-11T12:25:03+00:00","dateModified":"2020-10-11T15:25:16+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-procedures-and-procedure-parameters\/"},"wordCount":480,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-procedures-and-procedure-parameters\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/10\/plsqlprocedures.jpg","keywords":["IN OUT Parameter in PL\/SQL Procedures","IN Parameter in PL\/SQL Procedures","OUT Parameter in PL\/SQL Procedures","pl\/sql procedure example with parameters","Procedure Parameters in Oracle","What is Procedure in Oracle?"],"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-procedures-and-procedure-parameters\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-procedures-and-procedure-parameters\/","url":"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-procedures-and-procedure-parameters\/","name":"Oracle PL\/SQL Procedures and Procedure Parameters - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-procedures-and-procedure-parameters\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-procedures-and-procedure-parameters\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/10\/plsqlprocedures.jpg","datePublished":"2020-10-11T12:25:03+00:00","dateModified":"2020-10-11T15:25:16+00:00","description":"This article contains information about PL\/SQL Procedures and parameters in procedures such as IN, OUT, IN OUT and examples.","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-procedures-and-procedure-parameters\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-procedures-and-procedure-parameters\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-procedures-and-procedure-parameters\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/10\/plsqlprocedures.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/10\/plsqlprocedures.jpg","width":820,"height":522},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2020\/10\/11\/oracle-pl-sql-procedures-and-procedure-parameters\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Oracle PL\/SQL Procedures and Procedure Parameters"}]},{"@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\/17147","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=17147"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/17147\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/17148"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=17147"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=17147"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=17147"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}