{"id":18934,"date":"2020-09-16T08:54:54","date_gmt":"2020-09-16T08:54:54","guid":{"rendered":"https:\/\/ittutorial.org\/?p=18934"},"modified":"2021-06-07T16:36:37","modified_gmt":"2021-06-07T16:36:37","slug":"dbms_output-put_line-in-pl-sql","status":"publish","type":"post","link":"https:\/\/ittutorial.org\/dbms_output-put_line-in-pl-sql\/","title":{"rendered":"DBMS_OUTPUT.PUT_LINE in PL\/SQL"},"content":{"rendered":"

I will explain dbms_output.put_line in PL\/SQL in this post.<\/p>\n

<\/p>\n

<\/h1>\n

DBMS_OUTPUT.PUT_LINE<\/span><\/h2>\n

 <\/p>\n

PL\/SQL has DBMS_OUTPUT package that is used to send messages from procedures, packages, and triggers. This package is used to display output to a screen.<\/p>\n

 <\/p>\n

PUT_LINE<\/span><\/h3>\n

DBMS_OUTPUT.PUT_LINE procedure is used to place a line in the buffer or display output to a screen.<\/p>\n

Syntax<\/p>\n

DBMS_OUTPUT.PUT_LINE (\r\n   item IN VARCHAR2);\r\n\r\n\r\n\r\n<\/pre>\n\n
 <\/p>\n
Example:<\/p>\n
SQL> SET SERVEROUTPUT ON \r\nSQL> BEGIN DBMS_OUTPUT.PUT_LINE ('Hello IT Tutorial'); \r\n2 DBMS_LOCK.SLEEP (10); \r\n3 END;\r\n4 \/\r\n\r\nHello IT Tutorial<\/strong><\/span>\r\n\r\nPL\/SQL procedure successfully completed.\r\n\r\nSQL><\/pre>\n
\r\n<\/pre>\n
dbms_output.put_line\u00a0procedure trims off white space from output as follows.<\/p>\n
SQL> \r\nSQL> SET SERVEROUTPUT ON\r\nSQL> BEGIN DBMS_OUTPUT.PUT_LINE ('\u00a0 \u00a0Hello IT Tutorial\u00a0 \u00a0 ');\r\n2 END;\r\n3 \/\r\nHello IT Tutorial\r\n\r\nPL\/SQL procedure successfully completed.\r\n\r\nSQL>\r\n\r\n\r\n<\/pre>\n
<\/pre>\n
When your lines exceeds the line limit, you receive an error message after execution.<\/p>\n
https:\/\/ittutorial.org\/pl-sql-for-real-world-8-features-that-you-have-to-know\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
I will explain dbms_output.put_line in PL\/SQL in this post.<\/p>\n","protected":false},"author":1,"featured_media":14361,"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":[13129,13130,7458,3618,13128],"class_list":["post-18934","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-pl-sql","tag-dbms_output","tag-dbms_output-package","tag-dbms_output-put_line","tag-pl-sql","tag-put_line"],"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/ittutorial.org\/wp-content\/uploads\/2020\/04\/plsql.png","jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/18934","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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/comments?post=18934"}],"version-history":[{"count":3,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/18934\/revisions"}],"predecessor-version":[{"id":34642,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/18934\/revisions\/34642"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media\/14361"}],"wp:attachment":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media?parent=18934"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=18934"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=18934"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}