{"id":4404,"date":"2024-03-14T01:25:51","date_gmt":"2024-03-14T01:25:51","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-can-i-insert-a-line-break-in-sqlplus\/"},"modified":"2025-07-31T07:23:09","modified_gmt":"2025-07-31T07:23:09","slug":"how-can-i-insert-a-line-break-in-sqlplus","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-can-i-insert-a-line-break-in-sqlplus\/","title":{"rendered":"SQL*Plus Line Break Control Guide"},"content":{"rendered":"<p>In SQL*Plus, you can use the SET PAGESIZE and SET LINESIZE commands to control the number of lines for line breaks and the number of characters per line.<\/p>\n<p>For example, to set the number of rows displayed per page to 20 rows, you can use the following command:<\/p>\n<pre class=\"post-pre\"><code>SET PAGESIZE 20;\r\n<\/code><\/pre>\n<p>To set the number of characters displayed per line to 80 characters, you can use the following command:<\/p>\n<pre class=\"post-pre\"><code>SET LINESIZE 80;\r\n<\/code><\/pre>\n<p>This way, you can control the line break format of the SQL*Plus output.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In SQL*Plus, you can use the SET PAGESIZE and SET LINESIZE commands to control the number of lines for line breaks and the number of characters per line. For example, to set the number of rows displayed per page to 20 rows, you can use the following command: SET PAGESIZE 20; To set the number [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[3915,282,3916,3917,3914],"class_list":["post-4404","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-line-break","tag-oracle","tag-output-formatting","tag-set-commands","tag-sqlplus"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL*Plus Line Break Control Guide - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Master SQL*Plus output formatting: Control line breaks with SET PAGESIZE and SET LINESIZE commands.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/blog\/how-can-i-insert-a-line-break-in-sqlplus\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL*Plus Line Break Control Guide\" \/>\n<meta property=\"og:description\" content=\"Master SQL*Plus output formatting: Control line breaks with SET PAGESIZE and SET LINESIZE commands.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-can-i-insert-a-line-break-in-sqlplus\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-14T01:25:51+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-07-31T07:23:09+00:00\" \/>\n<meta name=\"author\" content=\"Emily Johnson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Emily Johnson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-i-insert-a-line-break-in-sqlplus\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-i-insert-a-line-break-in-sqlplus\/\"},\"author\":{\"name\":\"Emily Johnson\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3b041b19cffc258705478ecfab895378\"},\"headline\":\"SQL*Plus Line Break Control Guide\",\"datePublished\":\"2024-03-14T01:25:51+00:00\",\"dateModified\":\"2025-07-31T07:23:09+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-i-insert-a-line-break-in-sqlplus\/\"},\"wordCount\":85,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"line break\",\"Oracle\",\"output formatting\",\"SET commands\",\"SQL*Plus\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-i-insert-a-line-break-in-sqlplus\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-can-i-insert-a-line-break-in-sqlplus\/\",\"name\":\"SQL*Plus Line Break Control Guide - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-14T01:25:51+00:00\",\"dateModified\":\"2025-07-31T07:23:09+00:00\",\"description\":\"Master SQL*Plus output formatting: Control line breaks with SET PAGESIZE and SET LINESIZE commands.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-i-insert-a-line-break-in-sqlplus\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-can-i-insert-a-line-break-in-sqlplus\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-i-insert-a-line-break-in-sqlplus\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL*Plus Line Break Control Guide\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3b041b19cffc258705478ecfab895378\",\"name\":\"Emily Johnson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a5cb4e73d02ab1d79f2dfe919389ff7c1de072baa97686392031c03d858cc358?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a5cb4e73d02ab1d79f2dfe919389ff7c1de072baa97686392031c03d858cc358?s=96&d=mm&r=g\",\"caption\":\"Emily Johnson\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/emilyjohnson\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL*Plus Line Break Control Guide - Blog - Silicon Cloud","description":"Master SQL*Plus output formatting: Control line breaks with SET PAGESIZE and SET LINESIZE commands.","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:\/\/www.silicloud.com\/blog\/how-can-i-insert-a-line-break-in-sqlplus\/","og_locale":"en_US","og_type":"article","og_title":"SQL*Plus Line Break Control Guide","og_description":"Master SQL*Plus output formatting: Control line breaks with SET PAGESIZE and SET LINESIZE commands.","og_url":"https:\/\/www.silicloud.com\/blog\/how-can-i-insert-a-line-break-in-sqlplus\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-14T01:25:51+00:00","article_modified_time":"2025-07-31T07:23:09+00:00","author":"Emily Johnson","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Emily Johnson","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-can-i-insert-a-line-break-in-sqlplus\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-i-insert-a-line-break-in-sqlplus\/"},"author":{"name":"Emily Johnson","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3b041b19cffc258705478ecfab895378"},"headline":"SQL*Plus Line Break Control Guide","datePublished":"2024-03-14T01:25:51+00:00","dateModified":"2025-07-31T07:23:09+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-i-insert-a-line-break-in-sqlplus\/"},"wordCount":85,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["line break","Oracle","output formatting","SET commands","SQL*Plus"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-can-i-insert-a-line-break-in-sqlplus\/","url":"https:\/\/www.silicloud.com\/blog\/how-can-i-insert-a-line-break-in-sqlplus\/","name":"SQL*Plus Line Break Control Guide - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-14T01:25:51+00:00","dateModified":"2025-07-31T07:23:09+00:00","description":"Master SQL*Plus output formatting: Control line breaks with SET PAGESIZE and SET LINESIZE commands.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-i-insert-a-line-break-in-sqlplus\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-can-i-insert-a-line-break-in-sqlplus\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-can-i-insert-a-line-break-in-sqlplus\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL*Plus Line Break Control Guide"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3b041b19cffc258705478ecfab895378","name":"Emily Johnson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/a5cb4e73d02ab1d79f2dfe919389ff7c1de072baa97686392031c03d858cc358?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a5cb4e73d02ab1d79f2dfe919389ff7c1de072baa97686392031c03d858cc358?s=96&d=mm&r=g","caption":"Emily Johnson"},"url":"https:\/\/www.silicloud.com\/blog\/author\/emilyjohnson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/4404","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=4404"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/4404\/revisions"}],"predecessor-version":[{"id":149062,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/4404\/revisions\/149062"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=4404"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=4404"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=4404"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}