{"id":14735,"date":"2020-01-14T06:25:49","date_gmt":"2020-01-14T06:25:49","guid":{"rendered":"https:\/\/dbtut.com\/?p=14735"},"modified":"2020-01-14T06:25:51","modified_gmt":"2020-01-14T06:25:51","slug":"what-is-oracle-sql-plus-and-sql-plus-usage","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2020\/01\/14\/what-is-oracle-sql-plus-and-sql-plus-usage\/","title":{"rendered":"What is Oracle SQL Plus and SQL Plus Usage"},"content":{"rendered":"

This article contains information about Oracle SQL Plus tool.<\/p>\n

What is Oracle SQL Plus?<\/h2>\n

SQL Plus is a tool for managing the database management system in the command interpreter. When we install Oracle database management system, we can use SQL Plus tool without any further installation.<\/p>\n

SQL Plus Usage<\/h2>\n

To use the SQLPlus tool, simply type the following command into the operating system command interpreter.<\/p>\n

sqlplus<\/pre>\n
SQL Plus with Docker<\/h4>\n
The following command is used to use the SQL Plus tool with Docker.<\/p>\n
docker exec -it oracle bash -c \"source \/home\/oracle\/.bashrc; sqlplus\"<\/pre>\n
Connect Database with SQL Plus<\/h4>\n
sqlplus Your_User_Name\/Your_User_Password;<\/pre>\n
You can connect to the database using the connect command from the SQLPlus tool.<\/p>\n
connect<\/pre>\n
connect Your_User_Name<\/pre>\n
connect Your_User_Name\/Your_User_Password<\/pre>\n
Connect Oracle Database With SQL Plus As SYSDBA<\/h4>\n
connect SYS \/ as SYSDBA<\/pre>\n
Check Connection in SQLPlus<\/h4>\n
The show user command is used to check the connection.<\/p>\n
show user<\/pre>\n
SQLPlus Disconnect From Database<\/h4>\n
The disconnect command is used to close the connection.<\/p>\n
disconnect<\/pre>\n
Clear Screen SQLPlus<\/h4>\n
The clear screen command is used to clear the screen.<\/p>\n
clear screen<\/pre>\n
List queries written in SQLPlus<\/h4>\n
The list command is used to list queries written in SQL Plus.<\/p>\n
list<\/pre>\n
Clear Buffer in SQLPlus<\/h4>\n
The clear buffer and del command are used to delete previously written commands.<\/p>\n
clear buffer<\/pre>\n
cl buffer<\/pre>\n
del<\/pre>\n
Clear a Specific Command in SQL Plus History<\/h4>\n
To delete only a specific command, use the “del number” command. You can read the article “SQL Plus History<\/a>” to find the number of the query. Also you can find the details about clearing all commands in SQL Plus History in this article.<\/p>\n
Append and input Commands in SQLPlus<\/h4>\n
The append and input command is used to append to the SQL query.<\/p>\n
append sql_to_be_appended<\/pre>\n
input sql_to_be_appended<\/pre>\n
Change Command in SQLPlus<\/h4>\n
The change command is used to change the SQL query.<\/p>\n
change old_value\/new_value<\/pre>\n
Save query to file in SQLPlus<\/h4>\n
The save command is used to save SQL commands.<\/p>\n
save file_name<\/pre>\n
Save query result to file in SQLPlus<\/h4>\n
The spool command is used to save SQL commands and their results to a file.<\/p>\n
spool C:\\codes.txt\nspool OFF<\/pre>\n
SQLPlus run sql file<\/h4>\n
Get, start, @ is used to get the SQL commands in the file.<\/p>\n
get file_name\nstart file_name\n@file_name\nrun<\/pre>\n
Host Command in SQLPlus<\/h4>\n
The host command is used to switch from the SQLPlus command line to the operating system command line.<\/p>\n
host<\/pre>\n
host command<\/pre>\n
Temp Variable in SQLPLus<\/h4>\n
The ampersand (&) sign is used to use a temporary variable in SQL queries.<\/p>\n
SELECT * FROM MyTable WHERE Column = &Column_Value<\/pre>\n
The SET command is used to change the variable mark.<\/p>\n
SET DEFINE ON\nSET DEFINE '#'\nSELECT * FROM MyTable WHERE Column = &Column_Value<\/pre>\n
SQLPlus User Friendly Result<\/h4>\n
You can use below command to see results user friendly.<\/p>\n
SET WRAP ON\/OFF\nSET HEAD ON\/OFF\nSET LINESIZE 15<\/pre>\n
Get Information About Commands in SQLPlus<\/h4>\n
The help command is used to get information about the commands.<\/p>\n
help command<\/pre>\n
Although the SQL Plus tool that we can use with Oracle installation is flexible compared to the tools in other database management systems, the use of tools such as APEX, Oracle SQL Developer will be useful against possible errors.<\/p>\n
Have a good day.<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
This article contains information about Oracle SQL Plus tool. What is Oracle SQL Plus? SQL Plus is a tool for managing the database management system in the command interpreter. When we install Oracle database management system, we can use SQL Plus tool without any further installation. SQL Plus Usage To use the SQLPlus tool, simply …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":485,"featured_media":14736,"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":[7812,7806,7807,7834,7833,7811,7771,7774,7805,7802,7803,7792,7787,7785,7786,7788,7750,7751,7769,7768,7770,7766,7804,7778,7828,6220,7827,7758,7775,7808,7822,7823,7776,7800,7801,7764,7757,7752,7784,7749,7817,7777,7816,7798,7796,7799,7835,7743,7744,7759,7809,7760,7761,7797,7789,7794,7795,7793,7765,7753,7754,7755,7756,7763,7767,7762,7782,7780,7783,7779,7781,7748,7747,7746,7820,7836,7837,7810,7824,7829,7830,7818,7814,7813,7815,7825,7826,7821,7838,7745,7819,7832,7831,7772,7773,7790,7839,7742,7791],"class_list":["post-14735","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle","tag-append-and-input-commands-in-sqlplus","tag-append-and-input-in-sqlplus","tag-append-sqlplus","tag-arama-sonuclari-web-sonuclari-ugly-formatting-in-sqlplus","tag-beautifying-sql-plus-output","tag-change-command-in-sqlplus","tag-check-connection-sqlplus","tag-check-connection-using-sqlplus","tag-clear-a-specific-command-in-sql-plus-history","tag-clear-buffer-in-sqlplus","tag-clear-buffer-sqlplus","tag-clear-commands-sqlplus","tag-clear-screen-in-oracle-sqlplus","tag-clear-screen-sqlplus","tag-clear-screen-sqlplus-command","tag-command-to-clear-screen-in-oracle-sql-plus","tag-connect-database-with-sql-plus","tag-connect-database-with-sqlplus","tag-connect-database-with-sqlplus-as-sysdba","tag-connect-oracle-database-with-sql-plus-as-sysdba","tag-connect-oracle-database-with-sqlplus-as-sysdba","tag-connect-to-oracle-database-with-sqlplus","tag-delete-a-command-from-history-sqlplus","tag-disconnect-sqlplus","tag-executing-a-sql-file-in-sql-plus","tag-generate-csv-with-sqlplus","tag-how-do-i-run-a-sqlplus-file","tag-how-to-connect-to-oracle-database-using-sqlplus-as-sysdba","tag-how-to-use-sqlplus-to-connect-to-an-oracle-database","tag-input-in-sqlplus","tag-oracle-spool-query-output-to-file","tag-oracle-spool-query-result-to-file","tag-oracle-sqlplus-check-connection","tag-oracle-sqlplus-clear-command","tag-oracle-sqlplus-clear-screen-command","tag-oracle-sqlplus-command-line-login","tag-oracle-sqlplus-connect-to-database-as-sysdba","tag-oracle-sqlplus-connection","tag-oracle-sqlplus-disconnect","tag-oracle-sqlplus-docker","tag-oracle-sqlplus-save-query-results-to-file","tag-oracle-sqlplus-show-connection","tag-save-query-result-to-file-in-sqlplus","tag-sql-plus-clear-command","tag-sql-plus-command-to-clear-screen","tag-sql-plus-delete-command","tag-sql-plus-formatting","tag-sql-plus-usage","tag-sql-plus-with-docker","tag-sqlplus-as-sysdba","tag-sqlplus-append-command","tag-sqlplus-as-sysdba-command","tag-sqlplus-as-sysdba-oracle","tag-sqlplus-clear-command-buffer","tag-sqlplus-clear-screen-shortcut","tag-sqlplus-command-clear-screen","tag-sqlplus-command-line-clear-screen","tag-sqlplus-commands-clear","tag-sqlplus-connect","tag-sqlplus-connect-as-sysdba","tag-sqlplus-connect-as-sysdba-command","tag-sqlplus-connect-as-sysdba-command-line","tag-sqlplus-connect-as-sysdba-to-database","tag-sqlplus-connect-oracle-db","tag-sqlplus-connect-to-database","tag-sqlplus-connection-examples","tag-sqlplus-disconnect","tag-sqlplus-disconnect-from-database","tag-sqlplus-disconnect-session","tag-sqlplus-disconnect-user","tag-sqlplus-disconnected-from-oracle-database","tag-sqlplus-docker","tag-sqlplus-docker-oracle","tag-sqlplus-docker-run","tag-sqlplus-export-query-result-to-file","tag-sqlplus-formatting","tag-sqlplus-friendly-formatting","tag-sqlplus-input-command","tag-sqlplus-output-query-results-to-file","tag-sqlplus-run-sql-file","tag-sqlplus-run-sql-files","tag-sqlplus-save-query-result-to-file","tag-sqlplus-save-query-results-to-file","tag-sqlplus-save-query-to-file","tag-sqlplus-save-select-result-to-file","tag-sqlplus-spool","tag-sqlplus-spool-command","tag-sqlplus-spool-query-result-to-file","tag-sqlplus-user-friendly-result","tag-sqlplus-with-docker","tag-sqlplus-write-query-results-to-file","tag-temp-variable-in-sqlplus","tag-temp-variable-in-sqplus","tag-test-connection-sqlplus","tag-test-oracle-connection-using-sqlplus","tag-what-are-sql-plus-commands","tag-what-is-oracle-sql-plus","tag-what-is-sqlplus","tag-what-is-the-use-of-sql-plus"],"aioseo_notices":[],"yoast_head":"\nWhat is Oracle SQL Plus and SQL Plus Usage - Database Tutorials<\/title>\n<meta name=\"description\" content=\"What is Oracle SQL Plus and SQL Plus Usage\" \/>\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\/01\/14\/what-is-oracle-sql-plus-and-sql-plus-usage\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What is Oracle SQL Plus and SQL Plus Usage - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"What is Oracle SQL Plus and SQL Plus Usage\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2020\/01\/14\/what-is-oracle-sql-plus-and-sql-plus-usage\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2020-01-14T06:25:49+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-01-14T06:25:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-11.png\" \/>\n\t<meta property=\"og:image:width\" content=\"470\" \/>\n\t<meta property=\"og:image:height\" content=\"307\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\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\/01\/14\/what-is-oracle-sql-plus-and-sql-plus-usage\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/14\/what-is-oracle-sql-plus-and-sql-plus-usage\/\"},\"author\":{\"name\":\"Yusuf SEZER\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/be8bf54494b6a89e626cbed2c940599a\"},\"headline\":\"What is Oracle SQL Plus and SQL Plus Usage\",\"datePublished\":\"2020-01-14T06:25:49+00:00\",\"dateModified\":\"2020-01-14T06:25:51+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/14\/what-is-oracle-sql-plus-and-sql-plus-usage\/\"},\"wordCount\":453,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/14\/what-is-oracle-sql-plus-and-sql-plus-usage\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-11.png\",\"keywords\":[\"Append and input Commands in SQLPlus\",\"Append and input in SQLPlus\",\"append sqlplus\",\"Arama Sonu\u00e7lar\u0131 Web sonu\u00e7lar\u0131 Ugly formatting in SQL*Plus\",\"Beautifying SQL PLUS Output\",\"Change Command in SQLPlus\",\"check connection sqlplus\",\"check connection using sqlplus\",\"Clear a Specific Command in SQL Plus History\",\"Clear Buffer in SQLPlus\",\"Clear Buffer SQLPlus\",\"clear commands SQLPlus\",\"clear screen in oracle sqlplus\",\"clear screen sqlplus\",\"clear screen sqlplus command\",\"command to clear screen in oracle sql plus\",\"Connect Database with SQL Plus\",\"connect database with sqlplus\",\"Connect Database With SQLPlus As SYSDBA\",\"Connect Oracle Database With SQL Plus As SYSDBA\",\"Connect Oracle Database With SQLPlus As SYSDBA\",\"connect to oracle database with sqlplus\",\"delete a command from history sqlplus\",\"disconnect sqlplus\",\"executing a .sql file in sql plus\",\"Generate CSV with SQLPlus\",\"How do I run a Sqlplus file?\",\"how to connect to oracle database using sqlplus as sysdba\",\"How to use sqlplus to connect to an Oracle Database\",\"input in sqlplus\",\"oracle spool query output to file\",\"oracle spool query result to file\",\"oracle sqlplus check connection\",\"oracle sqlplus clear command\",\"oracle sqlplus clear screen command\",\"oracle sqlplus command line login\",\"oracle sqlplus connect to database as sysdba\",\"oracle sqlplus connection\",\"oracle sqlplus disconnect\",\"oracle sqlplus docker\",\"oracle sqlplus save query results to file\",\"oracle sqlplus show connection\",\"Save query result to file in SQLPlus\",\"sql plus clear command\",\"sql plus command to clear screen\",\"sql plus delete command\",\"SQL Plus Formatting\",\"SQL Plus Usage\",\"SQL Plus with Docker\",\"sqlplus \/ as sysdba\",\"sqlplus append command\",\"sqlplus as sysdba command\",\"sqlplus as sysdba oracle\",\"sqlplus clear command buffer\",\"sqlplus clear screen shortcut\",\"sqlplus command clear screen\",\"sqlplus command line clear screen\",\"sqlplus commands clear\",\"sqlplus connect\",\"sqlplus connect as sysdba\",\"sqlplus connect as sysdba command\",\"sqlplus connect as sysdba command line\",\"sqlplus connect as sysdba to database\",\"sqlplus connect oracle db\",\"sqlplus connect to database\",\"sqlplus connection examples\",\"sqlplus disconnect\",\"sqlplus disconnect from database\",\"sqlplus disconnect session\",\"sqlplus disconnect user\",\"sqlplus disconnected from oracle database\",\"sqlplus docker\",\"sqlplus docker oracle\",\"sqlplus docker run\",\"sqlplus export query result to file\",\"SQLPlus Formatting\",\"SQLPlus Friendly Formatting\",\"sqlplus input command\",\"sqlplus output query results to file\",\"sqlplus run sql file\",\"sqlplus run sql files\",\"sqlplus save query result to file\",\"sqlplus save query results to file\",\"sqlplus save query to file\",\"sqlplus save select result to file\",\"sqlplus spool\",\"sqlplus spool command\",\"sqlplus spool query result to file\",\"sqlplus user friendly result\",\"SQLPlus with Docker\",\"sqlplus write query results to file\",\"Temp Variable in SQLPLus\",\"Temp Variable in SQPLus\",\"test connection sqlplus\",\"test oracle connection using sqlplus\",\"What are SQL Plus commands?\",\"What is Oracle SQL Plus?\",\"What is SQLPlus?\",\"What is the use of SQL Plus?\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2020\/01\/14\/what-is-oracle-sql-plus-and-sql-plus-usage\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/14\/what-is-oracle-sql-plus-and-sql-plus-usage\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/14\/what-is-oracle-sql-plus-and-sql-plus-usage\/\",\"name\":\"What is Oracle SQL Plus and SQL Plus Usage - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/14\/what-is-oracle-sql-plus-and-sql-plus-usage\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/14\/what-is-oracle-sql-plus-and-sql-plus-usage\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-11.png\",\"datePublished\":\"2020-01-14T06:25:49+00:00\",\"dateModified\":\"2020-01-14T06:25:51+00:00\",\"description\":\"What is Oracle SQL Plus and SQL Plus Usage\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/14\/what-is-oracle-sql-plus-and-sql-plus-usage\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2020\/01\/14\/what-is-oracle-sql-plus-and-sql-plus-usage\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/14\/what-is-oracle-sql-plus-and-sql-plus-usage\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-11.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-11.png\",\"width\":470,\"height\":307},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/14\/what-is-oracle-sql-plus-and-sql-plus-usage\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"What is Oracle SQL Plus and SQL Plus Usage\"}]},{\"@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 Oracle SQL Plus and SQL Plus Usage - Database Tutorials","description":"What is Oracle SQL Plus and SQL Plus Usage","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\/01\/14\/what-is-oracle-sql-plus-and-sql-plus-usage\/","og_locale":"en_US","og_type":"article","og_title":"What is Oracle SQL Plus and SQL Plus Usage - Database Tutorials","og_description":"What is Oracle SQL Plus and SQL Plus Usage","og_url":"https:\/\/dbtut.com\/index.php\/2020\/01\/14\/what-is-oracle-sql-plus-and-sql-plus-usage\/","og_site_name":"Database Tutorials","article_published_time":"2020-01-14T06:25:49+00:00","article_modified_time":"2020-01-14T06:25:51+00:00","og_image":[{"width":470,"height":307,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-11.png","type":"image\/png"}],"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\/01\/14\/what-is-oracle-sql-plus-and-sql-plus-usage\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/14\/what-is-oracle-sql-plus-and-sql-plus-usage\/"},"author":{"name":"Yusuf SEZER","@id":"https:\/\/dbtut.com\/#\/schema\/person\/be8bf54494b6a89e626cbed2c940599a"},"headline":"What is Oracle SQL Plus and SQL Plus Usage","datePublished":"2020-01-14T06:25:49+00:00","dateModified":"2020-01-14T06:25:51+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/14\/what-is-oracle-sql-plus-and-sql-plus-usage\/"},"wordCount":453,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/14\/what-is-oracle-sql-plus-and-sql-plus-usage\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-11.png","keywords":["Append and input Commands in SQLPlus","Append and input in SQLPlus","append sqlplus","Arama Sonu\u00e7lar\u0131 Web sonu\u00e7lar\u0131 Ugly formatting in SQL*Plus","Beautifying SQL PLUS Output","Change Command in SQLPlus","check connection sqlplus","check connection using sqlplus","Clear a Specific Command in SQL Plus History","Clear Buffer in SQLPlus","Clear Buffer SQLPlus","clear commands SQLPlus","clear screen in oracle sqlplus","clear screen sqlplus","clear screen sqlplus command","command to clear screen in oracle sql plus","Connect Database with SQL Plus","connect database with sqlplus","Connect Database With SQLPlus As SYSDBA","Connect Oracle Database With SQL Plus As SYSDBA","Connect Oracle Database With SQLPlus As SYSDBA","connect to oracle database with sqlplus","delete a command from history sqlplus","disconnect sqlplus","executing a .sql file in sql plus","Generate CSV with SQLPlus","How do I run a Sqlplus file?","how to connect to oracle database using sqlplus as sysdba","How to use sqlplus to connect to an Oracle Database","input in sqlplus","oracle spool query output to file","oracle spool query result to file","oracle sqlplus check connection","oracle sqlplus clear command","oracle sqlplus clear screen command","oracle sqlplus command line login","oracle sqlplus connect to database as sysdba","oracle sqlplus connection","oracle sqlplus disconnect","oracle sqlplus docker","oracle sqlplus save query results to file","oracle sqlplus show connection","Save query result to file in SQLPlus","sql plus clear command","sql plus command to clear screen","sql plus delete command","SQL Plus Formatting","SQL Plus Usage","SQL Plus with Docker","sqlplus \/ as sysdba","sqlplus append command","sqlplus as sysdba command","sqlplus as sysdba oracle","sqlplus clear command buffer","sqlplus clear screen shortcut","sqlplus command clear screen","sqlplus command line clear screen","sqlplus commands clear","sqlplus connect","sqlplus connect as sysdba","sqlplus connect as sysdba command","sqlplus connect as sysdba command line","sqlplus connect as sysdba to database","sqlplus connect oracle db","sqlplus connect to database","sqlplus connection examples","sqlplus disconnect","sqlplus disconnect from database","sqlplus disconnect session","sqlplus disconnect user","sqlplus disconnected from oracle database","sqlplus docker","sqlplus docker oracle","sqlplus docker run","sqlplus export query result to file","SQLPlus Formatting","SQLPlus Friendly Formatting","sqlplus input command","sqlplus output query results to file","sqlplus run sql file","sqlplus run sql files","sqlplus save query result to file","sqlplus save query results to file","sqlplus save query to file","sqlplus save select result to file","sqlplus spool","sqlplus spool command","sqlplus spool query result to file","sqlplus user friendly result","SQLPlus with Docker","sqlplus write query results to file","Temp Variable in SQLPLus","Temp Variable in SQPLus","test connection sqlplus","test oracle connection using sqlplus","What are SQL Plus commands?","What is Oracle SQL Plus?","What is SQLPlus?","What is the use of SQL Plus?"],"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2020\/01\/14\/what-is-oracle-sql-plus-and-sql-plus-usage\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/14\/what-is-oracle-sql-plus-and-sql-plus-usage\/","url":"https:\/\/dbtut.com\/index.php\/2020\/01\/14\/what-is-oracle-sql-plus-and-sql-plus-usage\/","name":"What is Oracle SQL Plus and SQL Plus Usage - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/14\/what-is-oracle-sql-plus-and-sql-plus-usage\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/14\/what-is-oracle-sql-plus-and-sql-plus-usage\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-11.png","datePublished":"2020-01-14T06:25:49+00:00","dateModified":"2020-01-14T06:25:51+00:00","description":"What is Oracle SQL Plus and SQL Plus Usage","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/14\/what-is-oracle-sql-plus-and-sql-plus-usage\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2020\/01\/14\/what-is-oracle-sql-plus-and-sql-plus-usage\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/14\/what-is-oracle-sql-plus-and-sql-plus-usage\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-11.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-11.png","width":470,"height":307},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/14\/what-is-oracle-sql-plus-and-sql-plus-usage\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"What is Oracle SQL Plus and SQL Plus Usage"}]},{"@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\/14735","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=14735"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/14735\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/14736"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=14735"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=14735"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=14735"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}