Welcome to the final installment of the Oracle SQL Developer series. In this post, we will discuss how to connect Oracle’s SQL Developer with Non-Oracle databases. Oracle’s SQL Developer application is a very powerful GUI interface for working with Oracle databases or as in the case with this post, just about any brand of database. [...]

1 There are 1 comments, care to add yours?

Welcome back to our series introducing you to Oracle’s SQL Developer application. Check out Part I, Part II and Part III. In this post we are going to cover how to backup your data using SQL Developer. It’s a simple process involving a couple of clicks, menu choices and small amounts of typing. Backing up [...]

1 There are 1 comments, care to add yours?

Welcome to the next installment of this Oracle SQL Developer series. You can check out Part I and Part II here. In this post, we will cover the creation of a database function using Oracle’s free SQL Developer application. Oracle’s SQL Developer application is a very powerful GUI interface for working with Oracle databases. SQL [...]

1 There are 1 comments, care to add yours?

Welcome to part two of this several part series regarding Oracle’s SQL Developer application. SQL Developer is a wonderful GUI application that lets us non-Database Administrators (DBA’s) interact with Oracle databases. SQL Developer turns the intimidating command line DBA tasks into simple point and click actions. For those of you that are familiar with MySQL [...]

1 There are 1 comments, care to add yours?

Although you might not be a Database Administrator (DBA), sometimes in the IT industry we have to perform tasks that really aren’t part of our training or job description. If you ever end up working with Oracle tables and would like to use a GUI to make your life easier, this series is for you. [...]

3 There are 3 comments, care to add yours?

In part one of this three part series we covered how to create a stored function. In part two of this series we covered how to create a stored procedure. In this final part of the series, we are going to show you how to tie it all together, how to take it to the [...]

0 There are 0 comments, care to add yours?

In part one of this three part series, we went over the steps necessary to create a stored function in MySQL. In part two of this series we are going to introduce you to stored procedures. A stored procedure is different from a stored function in that a stored procedure has no return value but [...]

1 There are 1 comments, care to add yours?

Stored routines are fairly new to MySQL, but they have been available in other databases for some time.  A stored routine has the following advantages: Speed!  Stored routines use MySQL server caching technology. Speed!  Repetitive tasks can be handled at the database level therefore reducing the amount of “back and forth” network traffic. Speed!  Stored [...]

4 There are 4 comments, care to add yours?