Answer Posted / prativa mishra

create or replace function return_date(r_date DATE) return VARCHAR2
is
a number;
b VARCHAR2(200);
begin
begin
select LAST_DAY(TO_DATE(r_date,'DD/MM/RRRR')) - to_date(r_date,'DD/MM/RRRR') into a FROM DUAL;
end;
begin
select to_CHAR(r_date,'DDTH')||' '||'OF'||TO_char(r_date,'MONTH')||' ,'||a||' days left for month end' into b from dual;
end;
return b;
end;

execute:- select return_date(sysdate) from dual;

20TH OFNOVEMBER ,10 days left for month end

How do sql databases work?

1001

---

Can we join tables without foreign key?

962

---

What is an inconsistent dependency?

1046

---

What are different functions in sql?

946

---

how many groups of data types? : Sql dba

1026

---

Which is better varchar or nvarchar?

997

---

how would you enter characters as hex numbers? : Sql dba

985

---

what are null values? : Sql dba

957

---

What is a join query?

964

---

How do I find duplicates in the same column?

1087

---

List out the acid properties and explain?

952

---

can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

997

---

What are the topics in pl sql?

972

---

What is sqlcontext?

1085

---

What is the difference between sql and t sql?

1035

---