Answer Posted / sanjukata

to_char()is required to convert number type and date type
of value to character type.

try this
select ename,hiredate,to_char(hiredate,'day ddth mon yy')
from emp;

to_date()is required to convert charater type of value to
date type.
try this
select to_date('22092010','dd-mm-yy')from dual;

What is mdb stand for?

1063

---

Is coalesce faster than isnull?

1019

---

What is sql catalog?

1068

---

Is nosql relational?

1002

---

How can I tell if sql is running?

1133

---

explain the delete statements in sql

1137

---

Explain foreign key in sql?

1083

---

Explain the update statement in sql

1046

---

what are the advantages and disadvantages of cascading style sheets? : Sql dba

1105

---

how can you see all indexes defined for a table? : Sql dba

1053

---

Are stored procedures faster than dynamic sql?

1106

---

Is primary key clustered index?

993

---

How do I truncate a word?

1163

---

How can we debug in PL/SQL?

1187

---

how to select unique records from a table? : Sql dba

1176

---