VIEWS: 7 PAGES: 1 POSTED ON: 6/17/2012
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.
Pages to are hidden for
"function"Please download to view full document