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 view and what are its advantages?

1115

---

How to create dbo table in sql server?

957

---

What is the difference between migration and upgradation in sql server?

1100

---

What does it mean to normalize data?

948

---

How to run sql server 2005 books online on your local system?

961

---

What is a schema in ms sql server 2005?

975

---

How to assign new column names in a view?

919

---

How data can be copied from one table to another table?

951

---

Define ACID properties in a Database?

1062

---

How can I know what locks are running on which resource?

957

---

what is the system function to get the current user's user id? : Sql server database administration

1027

---

Explain system rowset functions?

1004

---

How do I view a procedure in sql server?

994

---

What are SSL and TSL protocols?

997

---

How will you add a dimension to cube? : sql server analysis services, ssas

1088

---