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

Is sql injection illegal?

1017

---

How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

1136

---

What is trigger types in sql?

989

---

how to decrement dates by 1 in mysql? : Sql dba

1016

---

What is rtm stands for?

1093

---

What is the use of <> sql?

977

---

what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba

971

---

What is where clause in sql?

1037

---

What is the purpose of the partition table?

1047

---

Is nosql faster than sql?

1017

---

Why do we need cursors in pl sql?

1076

---

What is memory optimized table?

1040

---

What is sql query limit?

975

---

Why do you partition data?

1016

---

how can we know the count/number of elements of an array? : Sql dba

1060

---