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 types of primary keys are there?

1082

---

What does desc stand for?

1125

---

Can we rollback truncate?

1052

---

What is meant by truncate in sql?

1111

---

What is $$ in sql?

1046

---

Is it possible to update views?

1007

---

What is lexical units in pl sql?

1209

---

what is 'mysqldump'? : Sql dba

1169

---

Which is better stored procedure or query?

1017

---

What is column?

1034

---

What is a string data type in sql?

1102

---

What is anonymous block in sql?

1174

---

how do you tune the slow running queries in oracle db , explain the methodology

3236

---

how to create a new table by selecting rows from another table in mysql? : Sql dba

1168

---

What are types of indexes in sql?

1137

---