can i make my own function?

Answer 1

yes you can using create procedure privilege in Oracle database using pl/sql - search create or replace function on Google

Answer 2

please explain this if it possible ..

Answer 3

ya that's called stored procedures

Answer 4

stored procedure is like functions in other programming languages , you can create a stored procedure with specific function ( ex: joining 2 tables and retrieving specific rows) and then you use it in your query.

Answer 5

Yes, you can create a procedure or function and call there.