PL/SQL Function to Check Number is Even or Odd

PL/SQL Function to Check Number is Even or Odd: create or replace function evn_od(no in number) return varchar is ans…

add comment

PL/SQL Function to Check Number is Prime or Not

PL/SQL Function to Check Number is Prime or Not: create or replace function check_prime(no in number) return varchar is ans…

add comment

PL/SQL Function to Accept Number and Display in Words

PL/SQL Function to Accept Number and Display in Words: create or replace function ntw(no in number) return varchar is n_t_w…

add comment

PL/SQL Function to Display City of Employee

PL/SQL Function to Display City of Employee: create or replace function get_city(vid in number) return varchar is ciity varchar(15); begin…

add comment

PL/SQL Function to Find Highest Salary of Employee

PL/SQL Function to Find Highest Salary of Employee: create or replace function hig_sal return varchar is vname varchar(15); begin select…

add comment

PL/SQL Function to Find Power of Numbers

PL/SQL Function to Find Power of Numbers: create or replace function powr(x in number,y in number) return number is pno…

add comment

PL/SQL Function to Find Square of Number

PL/SQL Function to Find Square of Number: create or replace function sqr(no in number) return number is sqr_no number; begin…

add comment

PL/SQL Function to Accept Emp No and Returns Employee Details

PL/SQL Function to Accept Emp No and Returns Employee Details: create or replace function detail(no in number) return varchar is…

add comment

PL/SQL Function to Calculate Annual Income of Employee

PL/SQL Function to Calculate Annual Income of Employee: create or replace function tot_cal(veno in number) return number is atax number(20);…

add comment