Answer Posted / kathiravan jayachandran

In Oracle

select to_char(sysdate, 'dd/mm/yyy')as year from dual


EG:-

select ed.emp_date_of_birth,ed.first_name,ed.last_name
from emp_details ed where
to_char(ed.emp_date_of_birth,'mm')=to_char(sysdate,'mm')

What is a scheduled job or what is a scheduled task?

1003

---

How do we know if any query is retrieving a large amount of data or very little data?

1032

---

How to add a new dsn with the odbc driver for sql server?

1109

---

What are the types of database schema? : sql server analysis services, ssas

1184

---

Explain forward - only cursors?

1127

---

what's the maximum size of a row? : Sql server database administration

1154

---

Explain the microsoft sql server delete command?

1079

---

What are the difference between “where” and “having” clause in sql server?

1128

---

How can I track the changes or identify the latest insert-update-delete from a table?

1010

---

How to use wildcard characters in like operations in ms sql server?

1186

---

How to find out the list schema name and table name for the database?

977

---

Explain what is it unwise to create wide clustered index keys?

1023

---

Explain the steps to use transact-sql cursor?

1153

---

Explain tablesample?

1037

---

What happens if we shrink log file in sql server?

1029

---