{"id":9364,"date":"2019-10-24T20:49:20","date_gmt":"2019-10-24T18:49:20","guid":{"rendered":"https:\/\/www.salvis.com\/blog\/?p=9364"},"modified":"2023-11-08T10:43:31","modified_gmt":"2023-11-08T09:43:31","slug":"integrate-sqlplus-scripts-in-sql-developer","status":"publish","type":"post","link":"https:\/\/www.salvis.com\/blog\/2019\/10\/24\/integrate-sqlplus-scripts-in-sql-developer\/","title":{"rendered":"Integrate SQL*Plus Scripts in SQL Developer"},"content":{"rendered":"\n

I envy my DBA colleagues when they work with the Oracle Database from the command line in an incredibly efficient way. They just call a series of scripts with some parameters to get the desired information. Everything looks so easy, so smooth, so natural.<\/p>\n\n\n\n

I’m a developer. Basically a mouse pusher. I like to work in an IDE. It’s comfortable. However, I’d also like to use some of these fancy SQL*Plus scripts from the IDE in an easy way. This means, the scripts have to be accessible and executable via mouse clicks only. The keyboard is used when changing the default values of parameters. Is something like that possible? – Of course. In this blog post, I show how.<\/p>\n\n\n\n

ashtop.sql – The Script to Integrate<\/h2>\n\n\n\n

Tanel Poder<\/a> provides an extensive collection of useful SQL*Plus scripts in his TPT Oracle GitHub repository<\/a>. One of them is ashtop.sql. Here’s the header:<\/p>\n\n\n\n

ashtop.sql – header<\/span><\/path><\/path><\/svg><\/span>
-- Copyright 2018 Tanel Poder. All rights reserved. More info at http:\/\/tanelpoder.com<\/span><\/span>\n-- Licensed under the Apache License, Version 2.0. See LICENSE.txt for terms & conditions.<\/span><\/span>\n<\/span>\n--------------------------------------------------------------------------------<\/span><\/span>\n-- <\/span><\/span>\n-- File name:   ashtop.sql v1.2<\/span><\/span>\n-- Purpose:     Display top ASH time (count of ASH samples) grouped by your<\/span><\/span>\n--              specified dimensions<\/span><\/span>\n--              <\/span><\/span>\n-- Author:      Tanel Poder<\/span><\/span>\n-- Copyright:   (c) http:\/\/blog.tanelpoder.com<\/span><\/span>\n--              <\/span><\/span>\n-- Usage:       <\/span><\/span>\n--     @ashtop <grouping_cols> <filters> <fromtime> <totime><\/span><\/span>\n--<\/span><\/span>\n-- Example:<\/span><\/span>\n--     @ashtop username,sql_id session_type='FOREGROUND' sysdate-1\/24 sysdate<\/span><\/span>\n--<\/span><\/span>\n-- Other:<\/span><\/span>\n--     This script uses only the in-memory V$ACTIVE_SESSION_HISTORY, use<\/span><\/span>\n--     @dashtop.sql for accessiong the DBA_HIST_ACTIVE_SESS_HISTORY archive<\/span><\/span>\n--              <\/span><\/span>\n--------------------------------------------------------------------------------<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
Line 14 shows the usage and line 17 is an example.<\/p>\n\n\n\n
And here’s the output of the example call against my Oracle Cloud ATP instance:<\/p>\n\n\n\n
ashtop.sql – group by username, sql_id<\/span><\/path><\/path><\/svg><\/span>
        Total                                                                                                                      <\/span>Distinct<\/span><\/span>\n      <\/span>Seconds<\/span>     AAS %This                  USERNAME             SQL_ID        FIRST_SEEN          LAST_SEEN                    Execs Seen<\/span><\/span>\n------------- ------- ---------------------- -------------------- ------------- ------------------- ------------------- -------------------<\/span><\/span>\n           <\/span>24<\/span>      .<\/span>0<\/span>   <\/span>28<\/span>% |                SYS                  dshskca5cr6qh <\/span>2019<\/span>-<\/span>10<\/span>-<\/span>24<\/span> <\/span>15<\/span>:<\/span>15<\/span>:<\/span>23<\/span> <\/span>2019<\/span>-<\/span>10<\/span>-<\/span>24<\/span> <\/span>15<\/span>:<\/span>15<\/span>:<\/span>46<\/span>                   <\/span>1<\/span><\/span>\n            <\/span>8<\/span>      .<\/span>0<\/span>    <\/span>9<\/span>% |                <\/span>ADMIN<\/span>                9zg9qd9bm4spu <\/span>2019<\/span>-<\/span>10<\/span>-<\/span>24<\/span> <\/span>15<\/span>:<\/span>15<\/span>:<\/span>24<\/span> <\/span>2019<\/span>-<\/span>10<\/span>-<\/span>24<\/span> <\/span>15<\/span>:<\/span>15<\/span>:<\/span>31<\/span>                   <\/span>1<\/span><\/span>\n            <\/span>5<\/span>      .<\/span>0<\/span>    <\/span>6<\/span>% |                PLSCOPE              28fcqkxut9uu8 <\/span>2019<\/span>-<\/span>10<\/span>-<\/span>24<\/span> <\/span>15<\/span>:<\/span>16<\/span>:<\/span>06<\/span> <\/span>2019<\/span>-<\/span>10<\/span>-<\/span>24<\/span> <\/span>15<\/span>:<\/span>18<\/span>:<\/span>33<\/span>                   <\/span>3<\/span><\/span>\n            <\/span>5<\/span>      .<\/span>0<\/span>    <\/span>6<\/span>% |                SYS                  a8p0u5xxd358d <\/span>2019<\/span>-<\/span>10<\/span>-<\/span>24<\/span> <\/span>15<\/span>:<\/span>17<\/span>:<\/span>54<\/span> <\/span>2019<\/span>-<\/span>10<\/span>-<\/span>24<\/span> <\/span>15<\/span>:<\/span>17<\/span>:<\/span>58<\/span>                   <\/span>1<\/span><\/span>\n            <\/span>5<\/span>      .<\/span>0<\/span>    <\/span>6<\/span>% |                SYS                  dadfjwdntaxx0 <\/span>2019<\/span>-<\/span>10<\/span>-<\/span>24<\/span> <\/span>15<\/span>:<\/span>21<\/span>:<\/span>23<\/span> <\/span>2019<\/span>-<\/span>10<\/span>-<\/span>24<\/span> <\/span>15<\/span>:<\/span>34<\/span>:<\/span>09<\/span>                   <\/span>3<\/span><\/span>\n            <\/span>3<\/span>      .<\/span>0<\/span>    <\/span>3<\/span>% |                SH                   6jyqb60nkd96t <\/span>2019<\/span>-<\/span>10<\/span>-<\/span>24<\/span> <\/span>15<\/span>:<\/span>15<\/span>:<\/span>13<\/span> <\/span>2019<\/span>-<\/span>10<\/span>-<\/span>24<\/span> <\/span>15<\/span>:<\/span>15<\/span>:<\/span>15<\/span>                   <\/span>1<\/span><\/span>\n            <\/span>3<\/span>      .<\/span>0<\/span>    <\/span>3<\/span>% |                SYS                                <\/span>2019<\/span>-<\/span>10<\/span>-<\/span>24<\/span> <\/span>15<\/span>:<\/span>15<\/span>:<\/span>32<\/span> <\/span>2019<\/span>-<\/span>10<\/span>-<\/span>24<\/span> <\/span>15<\/span>:<\/span>15<\/span>:<\/span>32<\/span>                   <\/span>1<\/span><\/span>\n            <\/span>2<\/span>      .<\/span>0<\/span>    <\/span>2<\/span>% |                <\/span>ADMIN<\/span>                a540r9kg3mfa3 <\/span>2019<\/span>-<\/span>10<\/span>-<\/span>24<\/span> <\/span>15<\/span>:<\/span>16<\/span>:<\/span>18<\/span> <\/span>2019<\/span>-<\/span>10<\/span>-<\/span>24<\/span> <\/span>15<\/span>:<\/span>17<\/span>:<\/span>27<\/span>                   <\/span>2<\/span><\/span>\n            <\/span>2<\/span>      .<\/span>0<\/span>    <\/span>2<\/span>% |                SH                   ga8v7p6z5p27u <\/span>2019<\/span>-<\/span>10<\/span>-<\/span>24<\/span> <\/span>15<\/span>:<\/span>15<\/span>:<\/span>16<\/span> <\/span>2019<\/span>-<\/span>10<\/span>-<\/span>24<\/span> <\/span>15<\/span>:<\/span>15<\/span>:<\/span>17<\/span>                   <\/span>2<\/span><\/span>\n            <\/span>2<\/span>      .<\/span>0<\/span>    <\/span>2<\/span>% |                SH                                 <\/span>2019<\/span>-<\/span>10<\/span>-<\/span>24<\/span> <\/span>14<\/span>:<\/span>43<\/span>:<\/span>07<\/span> <\/span>2019<\/span>-<\/span>10<\/span>-<\/span>24<\/span> <\/span>15<\/span>:<\/span>15<\/span>:<\/span>12<\/span>                   <\/span>1<\/span><\/span>\n            <\/span>2<\/span>      .<\/span>0<\/span>    <\/span>2<\/span>% |                SYS                  fh5ufah919kun <\/span>2019<\/span>-<\/span>10<\/span>-<\/span>24<\/span> <\/span>15<\/span>:<\/span>15<\/span>:<\/span>32<\/span> <\/span>2019<\/span>-<\/span>10<\/span>-<\/span>24<\/span> <\/span>15<\/span>:<\/span>15<\/span>:<\/span>32<\/span>                   <\/span>2<\/span><\/span>\n            <\/span>1<\/span>      .<\/span>0<\/span>    <\/span>1<\/span>% |                <\/span>ADMIN<\/span>                8s155kx32c6xy <\/span>2019<\/span>-<\/span>10<\/span>-<\/span>24<\/span> <\/span>15<\/span>:<\/span>15<\/span>:<\/span>35<\/span> <\/span>2019<\/span>-<\/span>10<\/span>-<\/span>24<\/span> <\/span>15<\/span>:<\/span>15<\/span>:<\/span>35<\/span>                   <\/span>1<\/span><\/span>\n            <\/span>1<\/span>      .<\/span>0<\/span>    <\/span>1<\/span>% |                C##CLOUD$<\/span>SERVICE<\/span>     69qb9m1s0z7d6 <\/span>2019<\/span>-<\/span>10<\/span>-<\/span>24<\/span> <\/span>15<\/span>:<\/span>15<\/span>:<\/span>22<\/span> <\/span>2019<\/span>-<\/span>10<\/span>-<\/span>24<\/span> <\/span>15<\/span>:<\/span>15<\/span>:<\/span>22<\/span>                   <\/span>1<\/span><\/span>\n            <\/span>1<\/span>      .<\/span>0<\/span>    <\/span>1<\/span>% |                C##CLOUD$<\/span>SERVICE<\/span>     dygx3s3636fdt <\/span>2019<\/span>-<\/span>10<\/span>-<\/span>24<\/span> <\/span>15<\/span>:<\/span>15<\/span>:<\/span>19<\/span> <\/span>2019<\/span>-<\/span>10<\/span>-<\/span>24<\/span> <\/span>15<\/span>:<\/span>15<\/span>:<\/span>19<\/span>                   <\/span>1<\/span><\/span>\n            <\/span>1<\/span>      .<\/span>0<\/span>    <\/span>1<\/span>% |                PLSCOPE              2jnz9d8909cjy <\/span>2019<\/span>-<\/span>10<\/span>-<\/span>24<\/span> <\/span>15<\/span>:<\/span>17<\/span>:<\/span>20<\/span> <\/span>2019<\/span>-<\/span>10<\/span>-<\/span>24<\/span> <\/span>15<\/span>:<\/span>17<\/span>:<\/span>20<\/span>                   <\/span>1<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
The columns username<\/code> and sql_id<\/code> are the group by columns. When I change the first parameter and pass just username<\/code> the result looks like this:<\/p>\n\n\n\n
ashtop.sql – group by username<\/span><\/path><\/path><\/svg><\/span>
        Total                                                                                                        <\/span>Distinct<\/span><\/span>\n      <\/span>Seconds<\/span>     AAS %This                  USERNAME             FIRST_SEEN          LAST_SEEN                    Execs Seen<\/span><\/span>\n------------- ------- ---------------------- -------------------- ------------------- ------------------- -------------------<\/span><\/span>\n           <\/span>46<\/span>      .<\/span>0<\/span>   <\/span>53<\/span>% |                SYS                  <\/span>2019<\/span>-<\/span>10<\/span>-<\/span>24<\/span> <\/span>15<\/span>:<\/span>15<\/span>:<\/span>23<\/span> <\/span>2019<\/span>-<\/span>10<\/span>-<\/span>24<\/span> <\/span>15<\/span>:<\/span>34<\/span>:<\/span>09<\/span>                  <\/span>10<\/span><\/span>\n           <\/span>16<\/span>      .<\/span>0<\/span>   <\/span>19<\/span>% |                PLSCOPE              <\/span>2019<\/span>-<\/span>10<\/span>-<\/span>24<\/span> <\/span>15<\/span>:<\/span>15<\/span>:<\/span>35<\/span> <\/span>2019<\/span>-<\/span>10<\/span>-<\/span>24<\/span> <\/span>15<\/span>:<\/span>18<\/span>:<\/span>34<\/span>                  <\/span>11<\/span><\/span>\n           <\/span>11<\/span>      .<\/span>0<\/span>   <\/span>13<\/span>% |                <\/span>ADMIN<\/span>                <\/span>2019<\/span>-<\/span>10<\/span>-<\/span>24<\/span> <\/span>15<\/span>:<\/span>15<\/span>:<\/span>24<\/span> <\/span>2019<\/span>-<\/span>10<\/span>-<\/span>24<\/span> <\/span>15<\/span>:<\/span>17<\/span>:<\/span>27<\/span>                   <\/span>4<\/span><\/span>\n            <\/span>8<\/span>      .<\/span>0<\/span>    <\/span>9<\/span>% |                SH                   <\/span>2019<\/span>-<\/span>10<\/span>-<\/span>24<\/span> <\/span>14<\/span>:<\/span>43<\/span>:<\/span>07<\/span> <\/span>2019<\/span>-<\/span>10<\/span>-<\/span>24<\/span> <\/span>15<\/span>:<\/span>15<\/span>:<\/span>47<\/span>                   <\/span>5<\/span><\/span>\n            <\/span>3<\/span>      .<\/span>0<\/span>    <\/span>3<\/span>% |                SONAR                <\/span>2019<\/span>-<\/span>10<\/span>-<\/span>24<\/span> <\/span>15<\/span>:<\/span>15<\/span>:<\/span>32<\/span> <\/span>2019<\/span>-<\/span>10<\/span>-<\/span>24<\/span> <\/span>15<\/span>:<\/span>15<\/span>:<\/span>35<\/span>                   <\/span>2<\/span><\/span>\n            <\/span>2<\/span>      .<\/span>0<\/span>    <\/span>2<\/span>% |                C##CLOUD$<\/span>SERVICE<\/span>     <\/span>2019<\/span>-<\/span>10<\/span>-<\/span>24<\/span> <\/span>15<\/span>:<\/span>15<\/span>:<\/span>19<\/span> <\/span>2019<\/span>-<\/span>10<\/span>-<\/span>24<\/span> <\/span>15<\/span>:<\/span>15<\/span>:<\/span>22<\/span>                   <\/span>2<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
Actually, I can use every combination of columns in gv$active_session_history<\/code> and dba_users<\/code> as grouping columns. A nice SQL*Plus script.<\/p>\n\n\n\n
Let’s integrate ashtop.sql in SQL Developer.<\/p>\n\n\n\n
Step 1 – Install tpt-oracle<\/h2>\n\n\n\n
Download or clone Tanel Poder’s Troubleshooting Scripts (TPT) from GitHub<\/a>. I keep these scripts on my MacBook in `\/Users\/phs\/github\/tpt-oracle`.<\/p>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
Step 2 – Create New Report<\/h2>\n\n\n\n
Select Reports<\/code> from the view menu<\/p>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
and then right-click on User Defined Reports<\/code> and select New Report...<\/code> from the context menu.<\/p>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
In the new window type ashtop<\/code> in the name field, change the style to Script<\/code>, copy the following script and paste it into the SQL<\/code> field:<\/p>\n\n\n\n
SQL*Plus script<\/span><\/path><\/path><\/svg><\/span>
set<\/span> termout <\/span>off<\/span><\/span>\nset<\/span> verify <\/span>off<\/span><\/span>\nset<\/span> linesize <\/span>500<\/span><\/span>\n<\/span>\ncolumn grouping_cols new_value grouping_cols noprint<\/span><\/span>\ncolumn filters       new_value filters       noprint<\/span><\/span>\ncolumn fromtime      new_value fromtime      noprint<\/span><\/span>\ncolumn totime        new_value totime        noprint<\/span><\/span>\ncolumn tptdir        new_value tptdir        noprint<\/span><\/span>\n<\/span>\nselect<\/span> :grouping_cols <\/span>as<\/span> grouping_cols,<\/span><\/span>\n       :filters       <\/span>as<\/span> filters,<\/span><\/span>\n       :fromtime      <\/span>as<\/span> fromtime,<\/span><\/span>\n       :totime        <\/span>as<\/span> totime,<\/span><\/span>\n       :tptdir        <\/span>as<\/span> tptdir<\/span><\/span>\n  <\/span>from<\/span> dual;<\/span><\/span>\n<\/span>\nset<\/span> termout <\/span>on<\/span><\/span>\n<\/span>\ncd &tptdir<\/span><\/span>\n@ashtop <\/span>"&grouping_cols"<\/span> <\/span>"&filters"<\/span> <\/span>"&fromtime"<\/span> <\/span>"&totime"<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
And press Apply<\/code>.<\/p>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
Step 3 – Set Defaults for Bind Variables<\/h2>\n\n\n\n
We have defined 5 bind variables in this report. :grouping_cols<\/code>, :filters<\/code>, :fromtime<\/code>, :totime<\/code> and :tptdir<\/code>. They are converted to SQL*Plus substitution variables and then passed to the ashtop.sql<\/code> script. We can execute the report now, but NULL<\/code> is the default value of all bind variables. This is not very convenient. Hence, we are going to change that.<\/p>\n\n\n\n
Right-click on the ashtop<\/code> report and select Edit...<\/code> from the context menu.<\/p>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
Click on Binds<\/code> and set the values according the following screenshot. Important is the Default<\/code> column.<\/p>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
And press Apply<\/code>.<\/p>\n\n\n\n
Step 4 – Save Report<\/h2>\n\n\n\n
To save the report you have to Select Save All<\/code> from the File<\/code> menu. The report is then saved in your UserReports.xml<\/code> file in your ${ide.pref.dir}<\/code> directory. You find the value of this variable in the Properties<\/code> tab of the About Oracle SQL Developer<\/code> dialog.<\/p>\n\n\n\n
Step 5 – Run Report<\/h2>\n\n\n\n
Click on the ashtop<\/code> report. Select a connection from this dialog and press OK<\/code>.<\/p>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
Then you can optionally change the values of the bind variables in this dialog.<\/p>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
Press Apply<\/code> and then the script is executed and the result is shown in a new tab.<\/p>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
Step 6 – Save Report as XML File<\/h2>\n\n\n\n
Right-click on the ashtop<\/code> report and select Save As...<\/code> from the context menu.<\/p>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
And then save the report in a directory of your choice.<\/p>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
Step 7 – Configure Report as User-defined Extension<\/h2>\n\n\n\n
You can configure the previously saved report in the SQL Developer’s preferences as user-defined extension as shown here:<\/p>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
After restarting SQL Developer the configured report is shown under Shared Reports<\/code>:<\/p>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
Summary<\/h2>\n\n\n\n
SQL Developer reports can be based on SQL but also SQL*Plus scripts. Calling external scripts has the advantage that I only have to maintain the interface to the SQL*Plus script within SQL Developer. This way I can install new versions of the scripts, for example by fetching updates from a Git repository and these new script versions are used the next time I run a report from SQL Developer.<\/p>\n\n\n\n
Updated on 2019-10-25, new screenshot in step 2, formatted code, mentioned that the style needs to be changed to Script<\/code>. Thanks, Dani Schnider<\/a> for your feedback.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"
I envy my DBA colleagues when they work with the Oracle Database from the command line in an incredibly efficient way. They just call a series of scripts with some parameters to get the desired information. Everything looks so easy, so smooth, so natural. I’m a developer. Basically a mouse pusher. I [\u2026]<\/span><\/p>\n","protected":false},"author":1,"featured_media":9380,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[85,87],"class_list":["post-9364","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-sql","tag-sql-developer"],"yoast_head":"\nIntegrate SQL*Plus Scripts in SQL Developer - Philipp Salvisberg's Blog<\/title>\n<meta name=\"description\" content=\"In this blog post I show how to run SQL*Plus scripts from SQL Developer using mouse clicks only. The keyboard is used when changing default values of parameters.\" \/>\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.salvis.com\/blog\/2019\/10\/24\/integrate-sqlplus-scripts-in-sql-developer\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Integrate SQL*Plus Scripts in SQL Developer - Philipp Salvisberg's Blog\" \/>\n<meta property=\"og:description\" content=\"In this blog post I show how to run SQL*Plus scripts from SQL Developer using mouse clicks only. The keyboard is used when changing default values of parameters.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.salvis.com\/blog\/2019\/10\/24\/integrate-sqlplus-scripts-in-sql-developer\/\" \/>\n<meta property=\"og:site_name\" content=\"Philipp Salvisberg's Blog\" \/>\n<meta property=\"article:published_time\" content=\"2019-10-24T18:49:20+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-08T09:43:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2019\/10\/tpt-ashtop-report4.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1294\" \/>\n\t<meta property=\"og:image:height\" content=\"734\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Philipp Salvisberg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@phsalvisberg\" \/>\n<meta name=\"twitter:site\" content=\"@phsalvisberg\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Philipp Salvisberg\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2019\\\/10\\\/24\\\/integrate-sqlplus-scripts-in-sql-developer\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2019\\\/10\\\/24\\\/integrate-sqlplus-scripts-in-sql-developer\\\/\"},\"author\":{\"name\":\"Philipp Salvisberg\",\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/#\\\/schema\\\/person\\\/34352245c48678b1a5a05d4bc1339515\"},\"headline\":\"Integrate SQL*Plus Scripts in SQL Developer\",\"datePublished\":\"2019-10-24T18:49:20+00:00\",\"dateModified\":\"2023-11-08T09:43:31+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2019\\\/10\\\/24\\\/integrate-sqlplus-scripts-in-sql-developer\\\/\"},\"wordCount\":662,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/#\\\/schema\\\/person\\\/34352245c48678b1a5a05d4bc1339515\"},\"image\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2019\\\/10\\\/24\\\/integrate-sqlplus-scripts-in-sql-developer\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/10\\\/tpt-ashtop-report4.png\",\"keywords\":[\"SQL\",\"SQL Developer\"],\"articleSection\":[\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2019\\\/10\\\/24\\\/integrate-sqlplus-scripts-in-sql-developer\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2019\\\/10\\\/24\\\/integrate-sqlplus-scripts-in-sql-developer\\\/\",\"url\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2019\\\/10\\\/24\\\/integrate-sqlplus-scripts-in-sql-developer\\\/\",\"name\":\"Integrate SQL*Plus Scripts in SQL Developer - Philipp Salvisberg's Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2019\\\/10\\\/24\\\/integrate-sqlplus-scripts-in-sql-developer\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2019\\\/10\\\/24\\\/integrate-sqlplus-scripts-in-sql-developer\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/10\\\/tpt-ashtop-report4.png\",\"datePublished\":\"2019-10-24T18:49:20+00:00\",\"dateModified\":\"2023-11-08T09:43:31+00:00\",\"description\":\"In this blog post I show how to run SQL*Plus scripts from SQL Developer using mouse clicks only. The keyboard is used when changing default values of parameters.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2019\\\/10\\\/24\\\/integrate-sqlplus-scripts-in-sql-developer\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2019\\\/10\\\/24\\\/integrate-sqlplus-scripts-in-sql-developer\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2019\\\/10\\\/24\\\/integrate-sqlplus-scripts-in-sql-developer\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/10\\\/tpt-ashtop-report4.png\",\"contentUrl\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/10\\\/tpt-ashtop-report4.png\",\"width\":1294,\"height\":734},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2019\\\/10\\\/24\\\/integrate-sqlplus-scripts-in-sql-developer\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Integrate SQL*Plus Scripts in SQL Developer\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/\",\"name\":\"Philipp Salvisberg's Blog\",\"description\":\"Database-centric development\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/#\\\/schema\\\/person\\\/34352245c48678b1a5a05d4bc1339515\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/#\\\/schema\\\/person\\\/34352245c48678b1a5a05d4bc1339515\",\"name\":\"Philipp Salvisberg\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2010\\\/11\\\/phs_trivadis4.jpg\",\"url\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2010\\\/11\\\/phs_trivadis4.jpg\",\"contentUrl\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2010\\\/11\\\/phs_trivadis4.jpg\",\"width\":400,\"height\":400,\"caption\":\"Philipp Salvisberg\"},\"logo\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2010\\\/11\\\/phs_trivadis4.jpg\"},\"sameAs\":[\"http:\\\/\\\/www.salvis.com\\\/\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Integrate SQL*Plus Scripts in SQL Developer - Philipp Salvisberg's Blog","description":"In this blog post I show how to run SQL*Plus scripts from SQL Developer using mouse clicks only. The keyboard is used when changing default values of parameters.","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.salvis.com\/blog\/2019\/10\/24\/integrate-sqlplus-scripts-in-sql-developer\/","og_locale":"en_US","og_type":"article","og_title":"Integrate SQL*Plus Scripts in SQL Developer - Philipp Salvisberg's Blog","og_description":"In this blog post I show how to run SQL*Plus scripts from SQL Developer using mouse clicks only. The keyboard is used when changing default values of parameters.","og_url":"https:\/\/www.salvis.com\/blog\/2019\/10\/24\/integrate-sqlplus-scripts-in-sql-developer\/","og_site_name":"Philipp Salvisberg's Blog","article_published_time":"2019-10-24T18:49:20+00:00","article_modified_time":"2023-11-08T09:43:31+00:00","og_image":[{"width":1294,"height":734,"url":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2019\/10\/tpt-ashtop-report4.png","type":"image\/png"}],"author":"Philipp Salvisberg","twitter_card":"summary_large_image","twitter_creator":"@phsalvisberg","twitter_site":"@phsalvisberg","twitter_misc":{"Written by":"Philipp Salvisberg","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.salvis.com\/blog\/2019\/10\/24\/integrate-sqlplus-scripts-in-sql-developer\/#article","isPartOf":{"@id":"https:\/\/www.salvis.com\/blog\/2019\/10\/24\/integrate-sqlplus-scripts-in-sql-developer\/"},"author":{"name":"Philipp Salvisberg","@id":"https:\/\/www.salvis.com\/blog\/#\/schema\/person\/34352245c48678b1a5a05d4bc1339515"},"headline":"Integrate SQL*Plus Scripts in SQL Developer","datePublished":"2019-10-24T18:49:20+00:00","dateModified":"2023-11-08T09:43:31+00:00","mainEntityOfPage":{"@id":"https:\/\/www.salvis.com\/blog\/2019\/10\/24\/integrate-sqlplus-scripts-in-sql-developer\/"},"wordCount":662,"commentCount":0,"publisher":{"@id":"https:\/\/www.salvis.com\/blog\/#\/schema\/person\/34352245c48678b1a5a05d4bc1339515"},"image":{"@id":"https:\/\/www.salvis.com\/blog\/2019\/10\/24\/integrate-sqlplus-scripts-in-sql-developer\/#primaryimage"},"thumbnailUrl":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2019\/10\/tpt-ashtop-report4.png","keywords":["SQL","SQL Developer"],"articleSection":["Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.salvis.com\/blog\/2019\/10\/24\/integrate-sqlplus-scripts-in-sql-developer\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.salvis.com\/blog\/2019\/10\/24\/integrate-sqlplus-scripts-in-sql-developer\/","url":"https:\/\/www.salvis.com\/blog\/2019\/10\/24\/integrate-sqlplus-scripts-in-sql-developer\/","name":"Integrate SQL*Plus Scripts in SQL Developer - Philipp Salvisberg's Blog","isPartOf":{"@id":"https:\/\/www.salvis.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.salvis.com\/blog\/2019\/10\/24\/integrate-sqlplus-scripts-in-sql-developer\/#primaryimage"},"image":{"@id":"https:\/\/www.salvis.com\/blog\/2019\/10\/24\/integrate-sqlplus-scripts-in-sql-developer\/#primaryimage"},"thumbnailUrl":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2019\/10\/tpt-ashtop-report4.png","datePublished":"2019-10-24T18:49:20+00:00","dateModified":"2023-11-08T09:43:31+00:00","description":"In this blog post I show how to run SQL*Plus scripts from SQL Developer using mouse clicks only. The keyboard is used when changing default values of parameters.","breadcrumb":{"@id":"https:\/\/www.salvis.com\/blog\/2019\/10\/24\/integrate-sqlplus-scripts-in-sql-developer\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.salvis.com\/blog\/2019\/10\/24\/integrate-sqlplus-scripts-in-sql-developer\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.salvis.com\/blog\/2019\/10\/24\/integrate-sqlplus-scripts-in-sql-developer\/#primaryimage","url":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2019\/10\/tpt-ashtop-report4.png","contentUrl":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2019\/10\/tpt-ashtop-report4.png","width":1294,"height":734},{"@type":"BreadcrumbList","@id":"https:\/\/www.salvis.com\/blog\/2019\/10\/24\/integrate-sqlplus-scripts-in-sql-developer\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.salvis.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Integrate SQL*Plus Scripts in SQL Developer"}]},{"@type":"WebSite","@id":"https:\/\/www.salvis.com\/blog\/#website","url":"https:\/\/www.salvis.com\/blog\/","name":"Philipp Salvisberg's Blog","description":"Database-centric development","publisher":{"@id":"https:\/\/www.salvis.com\/blog\/#\/schema\/person\/34352245c48678b1a5a05d4bc1339515"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.salvis.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.salvis.com\/blog\/#\/schema\/person\/34352245c48678b1a5a05d4bc1339515","name":"Philipp Salvisberg","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2010\/11\/phs_trivadis4.jpg","url":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2010\/11\/phs_trivadis4.jpg","contentUrl":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2010\/11\/phs_trivadis4.jpg","width":400,"height":400,"caption":"Philipp Salvisberg"},"logo":{"@id":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2010\/11\/phs_trivadis4.jpg"},"sameAs":["http:\/\/www.salvis.com\/"]}]}},"_links":{"self":[{"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/posts\/9364","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/comments?post=9364"}],"version-history":[{"count":27,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/posts\/9364\/revisions"}],"predecessor-version":[{"id":12660,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/posts\/9364\/revisions\/12660"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/media\/9380"}],"wp:attachment":[{"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/media?parent=9364"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/categories?post=9364"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/tags?post=9364"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}