O'Reilly logo

Oracle and PL/SQL Recipes: A Problem-Solution Approach by Matt Arena, Josh Juneau

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

12-8. Creating a Function

Problem

You want to create a function using Oracle SQL Developer.

Solution

You can manually create the function by typing the code into the SQL worksheet for the database connection for which you want to create. You can also use the Create Function Wizard within Oracle SQL Developer to provide some assistance throughout the function creation process. There are a couple of different ways to invoke the Create Function Wizard. If you go to the File menu and select New, the Create a New window opens, and Function is one of the available options. You can also reach the same menu by selecting the New toolbar button. Both of these paths will lead you to the same window because after clicking OK, the Create PL/SQL Function window ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required