PL/SQL Function is same as PL/SQL Procedure, The only difference is that function must return a value and a procedure may or may not return a value
Blog about Oracle ADF, JDeveloper, PL/SQL, Java, JavaScript, jQuery and Other Web Technologies
Search this blog
Showing posts with label PL/SQL Function. Show all posts
Showing posts with label PL/SQL Function. Show all posts
Monday 9 April 2018
PL/SQL Function
PL/SQL Function is same as PL/SQL Procedure, The only difference is that function must return a value and a procedure may or may not return a value
You might also like:
Labels:
Call PL/SQL Function
,
PL/SQL Function
,
PL/SQL Tutorials
,
SQL
,
SQL Developer
Tuesday 6 March 2018
PL/SQL Tutorial - What is PL/SQL, Features and Advantages of PL/SQL
PL/SQL is developed by Oracle Corporation to increase/enhance capabilities of SQL, PL/SQL stands for Procedural Language extension to SQL . PL/SQL is highly structured and expressive language and because of its expressive syntax it is very easy to understand and learn
PL/SQL is integrated with Oracle Database and can be called from any other programming language. It is tightly integrated with SQL so it's easy to learn PL/SQL if you have knowledge of SQL
You might also like:
Labels:
new features
,
PL/SQL Basics
,
PL/SQL Function
,
PL/SQL Procedure
,
PL/SQL Tutorials
,
SQL
,
SQL Developer
Sunday 6 March 2016
ADF Basics: Call PL/SQL Function with OUT parameter in ADF Application
Previous post was about calling PL/SQL Procedure with OUT parameters in ADF Application
ADF Basics: Call PL/SQL Procedure with OUT parameter in ADF Application
And this post is about calling PL/SQL Function with OUT parameters. Basic difference between a Function and Procedure is that Function must return a value but procedure may or may not return a value
So there is always one OUT parameter in PL/SQL Function
ADF Basics: Call PL/SQL Procedure with OUT parameter in ADF Application
And this post is about calling PL/SQL Function with OUT parameters. Basic difference between a Function and Procedure is that Function must return a value but procedure may or may not return a value
So there is always one OUT parameter in PL/SQL Function
You might also like:
Labels:
ADF
,
ADF Basics
,
Call PL/SQL Function
,
Oracle ADF Tutorial
,
PL/SQL Function
Monday 14 September 2015
ADF Basics: Call PL/SQL Stored function in ADF Application
This post is about calling stored function in ADF Application , a very basic requirement. Many times we need to call a PL/SQL function in ADF app for any specific requirement.
In this post i am discussing same so for that i have created a PL/SQL function that takes EmployeeId as input parameter and return it's Employees Name (Using Oracle HR Schema)
CREATE OR REPLACE FUNCTION FN_GET_EMPNAME(EMP_NO NUMBER) RETURN VARCHAR2 IS EMP_NAME VARCHAR2(50) := 'N'; BEGIN SELECT FIRST_NAME||' '||LAST_NAME into EMP_NAME FROM EMPLOYEES WHERE EMPLOYEE_ID=EMP_NO; RETURN EMP_NAME; END;
You might also like:
Labels:
Access bindings
,
ADF
,
ADF Basics
,
Call PL/SQL Function
,
Oracle ADF Tutorial
,
PL/SQL Function
Subscribe to:
Posts
(
Atom
)