Answer / vishwa

below query will get the last day of the month
select last_day(sysdate) from dual

Answer / ajit

select TO_CHAR( last_day(sysdate), 'day')
from dual

Answer / sujit pingale

select to_char(sysdate, 'day') from dual;

This will print output: tuesday i.e

select last_day(sysdate) from dual;

This will print output: 31-Aug-14

Answer / manoranjan sethy

Select LAST_DAY(Sysdate) From Dual;

How to get the 3rd column(i.e all the data along with the column name)in a table?

2 Answers   Logica CMG,

---

Is pl sql better than sql?

0 Answers  

---

What is the benefit of foreign key?

0 Answers  

---

difference between table level constraint and column level and advantages of table level constraint

4 Answers   Doyensys,

---

How many triggers can be applied on a table?

0 Answers  

---

How does join work in sql?

0 Answers  

---

What is differance unique key and primary key.

7 Answers   EDS,

---

How to get the procedure's, function's name from a package if it is wrapped(both spec & body).

2 Answers  

---

how to shut down the server with 'mysqladmin'? : Sql dba

0 Answers  

---

Describe different types of general function used in sql?

0 Answers  

---

what is sp_pkeys? : Transact sql

0 Answers  

---

what is the main difference between join and subqurey?

3 Answers   Oracle,

---