Answer Posted / naveen

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.

what is the difference between myisam static and myisam dynamic? : Sql dba

1068

---

What is the difference between left outer join and left join?

1000

---

how to enter characters as hex numbers? : Sql dba

1047

---

Can a varchar be a primary key?

1013

---

what is collation? : Sql dba

1158

---

How do you pronounce sql?

1020

---

What are the different set operators available in sql?

1029

---

What does trigger mean in psychology?

967

---

how to shutdown mysql server? : Sql dba

1107

---

Explain the difference between rename and alias?

1018

---

Explain two easy sql optimizations.

1019

---

What is sql integrity?

1165

---

Why we use pl sql?

964

---

What is bulk collect in pl sql?

1096

---

Is there a way to automate sql execution from the command-line, batch job or shell script?

977

---