SQL Script Support in Oracle 10G Express Edition - Creating a script
(Page 3 of 4 )

As we saw earlier, the script editor gives you access to create, modify, delete, save, and so on. Let's create a script file for demonstrating the use of looping using PL/SQL. This control structure in PL/SQL starts with a variable having a value 1 and increments it through 2 each time through the loop, until the final value reached does not exceed 10. It writes out the values as well. The next picture shows the script created (all steps deleted) except for the results, which shows the script as well as the results.

Errors in scripting show up with excellent help to troubleshoot the errors, as it shows the line where the error occurred and other details.

Next: Exporting and Importing of Scripts >>
 

More Oracle Articles
More By Jayaram Krishnaswamy

Comments On: SQL Script Support in Oracle 10G Express Edition

· The three articles, this one and the previous two at Dev Shed site gives you an...    · Excellent article but I'd like to add a tip for those who are looking how to put...    · The blog has achieved its goal- user participation and contribution.Thanks for...   >>> Post your comment now!