{"id":3837,"date":"2013-08-24T05:21:59","date_gmt":"2013-08-23T19:21:59","guid":{"rendered":"http:\/\/www.rjmprogramming.com.au\/wordpress\/?p=3837"},"modified":"2013-08-24T05:21:59","modified_gmt":"2013-08-23T19:21:59","slug":"more-toad-interface-to-oracle-install-to-stored-procedure-tutorial","status":"publish","type":"post","link":"https:\/\/www.rjmprogramming.com.au\/ITblog\/more-toad-interface-to-oracle-install-to-stored-procedure-tutorial\/","title":{"rendered":"More Toad Interface to Oracle Install to Stored Procedure Tutorial"},"content":{"rendered":"<div style=\"width: 230px\" class=\"wp-caption alignnone\"><a target=_blank href=\"http:\/\/www.rjmprogramming.com.au\/Oracle\/Toad\/More\/\"><img decoding=\"async\" style=\"float:left; border: 15px solid pink;\" alt=\"More Toad Interface to Oracle Install to Stored Procedure Tutorial\" src=\"http:\/\/www.rjmprogramming.com.au\/Oracle\/Toad\/More\/Oracle_PLSQL_More-522of.jpg\" title=\"More Toad Interface to Oracle Install to Stored Procedure Tutorial\"   \/><\/a><p class=\"wp-caption-text\">More Toad Interface to Oracle Install to Stored Procedure Tutorial<\/p><\/div>\n<p>Is there anything as good as the way phpMyAdmin interfaces to MySql available in Oracle?  Yes, so please read on. <\/p>\n<p>In today&#8217;s <a target=_blank title='More Toad tutorial' href=\"http:\/\/www.rjmprogramming.com.au\/Oracle\/Toad\/More\/\">tutorial<\/a> we continue the discovery of functionality of the Toad interface to Oracle that we started back at <a href='#titopt' title='Toad interface to Oracle Primer Tutorial'>Toad interface to Oracle Primer Tutorial<\/a> presented below.<\/p>\n<p>For our Toad tutorial today we install it on a Windows laptop, then use Toad to connect to an Oracle 10g client, and use Toad to create a new Oracle database user, then create two tables involving a foreign key constraint, then show some PL\/SQL code to insert records, and finally show how that same PL\/SQL can be incorporated into an Oracle Stored Procedure to be called very simply for any time it is required for any other form of usage.<\/p>\n<p>Link to that Oracle PL\/SQL Stored Procedure programming code can be gleaned from this <a target=_blank title='AddCircle.sql' href='http:\/\/www.rjmprogramming.com.au\/Oracle\/Toad\/More\/AddCircle.sql_GETME'>AddCircle.sql<\/a> link here.   Please note that this PL\/SQL could be improved for that small possibility where a POINT record happens to be inserted by someone else between when the computer processes each of the two INSERT statements.   Perhaps you&#8217;d like to try your skills at ensuring this blue-moon event can&#8217;t happen.<\/p>\n<p>Are you interested in Oracle Backup Reporting?  &#8230; take a &#8220;webcast&#8221; peak at &#8230; <a target=_blank title='Simplify and Speed Backup Reporting ... thanks, Michael' href='http:\/\/www.quest.com\/webcast-ondemand\/simplify-and-speed-backup-reporting816628.aspx?utm_campaign=32216-12678-DB-NA-Toad_TBACampaign_Email1&#038;utm_medium=email&#038;utm_source=Eloqua'>Simplify and Speed Backup Reporting<\/a>.<\/p>\n<hr \/>\n<p id='titopt'>Previous <a target=_blank title='Toad interface to Oracle Primer Tutorial' href='http:\/\/www.rjmprogramming.com.au\/wordpress\/?p=1096'>Toad interface to Oracle Primer Tutorial<\/a> is shown below.<\/p>\n<div style=\"width: 230px\" class=\"wp-caption alignnone\"><a target=_blank href=\"http:\/\/www.quest.com\/toad-for-oracle\/#screens\"><img decoding=\"async\" style=\"float:left; border: 15px solid pink;\" alt=\"Toad Interface to Oracle Primer Tutorial\" src=\"http:\/\/www.rjmprogramming.com.au\/Oracle\/Toad\/Toad_Primer.jpg\" title=\"Toad Interface to Oracle Primer Tutorial\"   \/><\/a><p class=\"wp-caption-text\">Toad Interface to Oracle Primer Tutorial<\/p><\/div>\n<p>Is there anything as good as the way phpMyAdmin interfaces to MySql available in Oracle?    What if I told you not to look at this post&#8217;s titles and captions, and gave you the hint &#8220;<a target=_blank href='https:\/\/www.youtube.com\/watch?v=COijcjdLHgg' title='Jolly Japes'>Friend of Mole and Ratty and Badger<\/a>&#8221; would you be warm, or just plain straight confused?<\/p>\n<div id='witw' style=\"display:none;\">\n<iframe loading=\"lazy\" width=\"420\" height=\"315\" src=\"http:\/\/www.youtube.com\/embed\/COijcjdLHgg\" frameborder=\"0\" allowfullscreen><\/iframe>\n<\/div>\n<p><script>\n  if (document.URL.indexOf(\"witw\") != (0 - 1)) {\n   document.getElementById('witw').style.display = 'block';\n  }\n<\/script><\/p>\n<p>Link to &#8216;You know Who\/What&#8217; home page &#8230; <a target=_blank title='Toad' href='http:\/\/www.quest.com\/toad-for-oracle\/'>here<\/a>.<\/p>\n<p>If this was interesting you may be interested in <a title='Click here to see topics in which you might be interested' href='#d1096' onclick='var dv=document.getElementById(\"d1096\"); dv.innerHTML = \"&lt;iframe width=670 height=600 src=\" + \"http:\/\/www.rjmprogramming.com.au\/wordpress\/?cat=47\" + \"&gt;&lt;\/iframe&gt;\"; dv.style.display = \"block\";'>this<\/a> too.<\/p>\n<div id='d1096' style='display: none; border-left: 2px solid green; border-top: 2px solid green;'><\/div>\n<hr \/>\n<p>If this was interesting you may be interested in <a title='Click here to see topics in which you might be interested' href='#d3837' onclick='var dv=document.getElementById(\"d3837\"); dv.innerHTML = \"&lt;iframe width=670 height=600 src=\" + \"http:\/\/www.rjmprogramming.com.au\/wordpress\/?tag=PL\/SQL\" + \"&gt;&lt;\/iframe&gt;\"; dv.style.display = \"block\";'>this<\/a> too.<\/p>\n<div id='d3837' style='display: none; border-left: 2px solid green; border-top: 2px solid green;'><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Is there anything as good as the way phpMyAdmin interfaces to MySql available in Oracle? Yes, so please read on. In today&#8217;s tutorial we continue the discovery of functionality of the Toad interface to Oracle that we started back at &hellip; <a href=\"https:\/\/www.rjmprogramming.com.au\/ITblog\/more-toad-interface-to-oracle-install-to-stored-procedure-tutorial\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9,12,37],"tags":[299,887,948,997,1186,1287,1319],"class_list":["post-3837","post","type-post","status-publish","format-standard","hentry","category-database","category-elearning","category-tutorials","tag-database-2","tag-oracle","tag-plsql","tag-programming","tag-sql","tag-toad","tag-tutorial"],"_links":{"self":[{"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/posts\/3837"}],"collection":[{"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/comments?post=3837"}],"version-history":[{"count":0,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/posts\/3837\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/media?parent=3837"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/categories?post=3837"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rjmprogramming.com.au\/ITblog\/wp-json\/wp\/v2\/tags?post=3837"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}