This blog explains about testing Pl/SQL stored procedure using Jdeveloper
- Connect to the corresponding database where your function created.
- Right click on the database connection , Choose SQL Worksheet
- In this example, I have created a stored function named 'get_emp_fullname()' which accepts one parameter i.e called Employee ID and returns Employee Full Name
- As shown below, use the query to test the function by passing required values for the arguments, you will see the response as shown below
s
what is dual in this example, is it the table that you are trying to get the results from?
ReplyDeleteIt's a sort of dummy table with a single record used for selecting when you're not actually interested in the data, but instead want the results of some system function in a select statement:
ReplyDelete