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".

Why we use cross join?

997

---

How many types of functions are there in sql?

1002

---

What are the properties of a transaction?

1185

---

Explain what is table in a database?

1108

---

Is merge a dml statement?

1028

---

Can a primary key be a foreign key?

1077

---

What is dialect in sql?

987

---

What is indexes?

1115

---

Why triggers are used?

1035

---

what is the difference between inner and outer join? Explain with example. : Sql dba

1061

---

What is numeric function sql?

1104

---

What are the sql versions?

995

---

What are field types?

1050

---

Is pl sql still used?

1016

---

What are types of joins?

1026

---