Answer Posted / bijaylaxmi

create or replace function cal_date(i_date DATE) return VARCHAR2
is
x number;
y VARCHAR2(200);
begin
begin
select LAST_DAY(TO_DATE(i_date,'DD/MM/yyyy')) - to_date(i_date,'DD/MM/yyyy') into x FROM DUAL;
end;
begin
select to_CHAR(i_date,'DDTH')||' '||'OF'||TO_char(i_date,'MONTH')||' ,'||x||' days left for month end' into y from dual;
end;
return y;
end;
>select cal_date('13-NOV-12') from dual;
o/p:-13th of November, 17 days left for
month end".

Can a foreign key be null?

1090

---

Differentiate between % rowtype and type record.

1301

---

What are user defined functions?

1016

---

What is function and procedure in pl sql?

1042

---

What is the difference between cross join and natural join?

1020

---

What is t sql used for?

1013

---

What is numeric function sql?

1059

---

Is there a 64 bit version of ssms?

961

---

How many types of privileges are available in sql?

1348

---

Why do we create stored procedures & functions in pl/sql and how are they different?

944

---

Is sql workbench free?

992

---

What are the different types of constraints?

1182

---

what is commit? : Sql dba

1071

---

How to set up sql*plus output format in oracle?

1037

---

How can the performance of a trigger be improved?

1047

---