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 many sql statements are used?

1070

---

What are the differences between implicit and explicit cursors?

1109

---

What are packages in pl sql and also explain its advantages?

1120

---

what are myisam tables? : Sql dba

1077

---

How can I speed up sql query?

1004

---

What is self-join and what is the requirement of self-join?

1190

---

What is sql stand for?

1033

---

Define sql delete statement.

1063

---

What is the size of partition table?

1088

---

Is sql easier than java?

1067

---

how to convert dates to character strings? : Sql dba

1249

---

What is the difference between left and left outer join?

990

---

How to add a column ‘salary’ to a table employee_details?

1052

---

When sql appeared?

1146

---

what is the use of set statement in tsql? : Transact sql

1059

---