Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out

function

VIEWS: 7 PAGES: 1

									                             FUNCTION BASED PL/SQL:-
1. Create a Function which will work as addition.
   e.g. select ADDITION(10,10) from dual;

2. Create a function same as above but if you do not pass any value into function then
   give result as any default value.


3. Using a function print the following output.
   ‘Database Management System – II’


4. Write the function to separate out the right character position of string.
   e.g. select RIGHT(‘DBMS-II’,3) from dual;


5. Write the function to separate out the left character position of string.
   e.g. select LEFT(‘DBMS-II’,3) from dual;


5. Create a function that is work as calculator.Use operator like ‘+’ , ‘-‘ , ‘*’ , ‘/’.


7. Write a function for factorial and use in PL/SQL code.

								
To top