Answer Posted / rajesh

to_char function is used to convert the given data into
character....
eg:to_char(sysdate,'month') which returns month alone...

to_date is used to convert the given data into date data
formate data type....

eg: to_date('070903', 'MMDDYY') would return a date value
of July 9, 2003.

Is oracle sql free?

926

---

What is the difference between alter trigger and drop trigger statements?

1041

---

What is program debugging?

1128

---

What is the use of partition by in sql?

928

---

How does sql profiler work?

964

---

What is time based sql injection?

900

---

Why partition by is used in sql?

969

---

how do you control the max size of a heap table? : Sql dba

920

---

what is the difference between char_length and length? : Sql dba

989

---

Write a query to find the names of users that begin with "um" in sql?

923

---

what is bcp? When does it used? : Sql dba

932

---

How do I kill a query in postgresql?

1011

---

Why do we create stored procedures & functions in pl/sql and how are they different?

887

---

What is t sql in sql server?

1000

---

what is the command used to fetch first 5 characters of the string? : Sql dba

1584

---