More Toad Interface to Oracle Install to Stored Procedure Tutorial

More Toad Interface to Oracle Install to Stored Procedure Tutorial

Is there anything as good as the way phpMyAdmin interfaces to MySql available in Oracle? Yes, so please read on.

In today’s tutorial we continue the discovery of functionality of the Toad interface to Oracle that we started back at Toad interface to Oracle Primer Tutorial presented below.

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.

Link to that Oracle PL/SQL Stored Procedure programming code can be gleaned from this AddCircle.sql 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’d like to try your skills at ensuring this blue-moon event can’t happen.

Are you interested in Oracle Backup Reporting? … take a “webcast” peak at … Simplify and Speed Backup Reporting.

Previous Toad interface to Oracle Primer Tutorial is shown below.

Toad Interface to Oracle Primer Tutorial

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’s titles and captions, and gave you the hint “Friend of Mole and Ratty and Badger” would you be warm, or just plain straight confused?

Link to ‘You know Who/What’ home page … here.

If this was interesting you may be interested in this too.

If this was interesting you may be interested in this too.