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 sqlcontext?

1006

---

What is the use of nvl function?

1136

---

What is pivot query?

1023

---

List the ways to get the count of records in a table?

868

---

Which one is better sql or oracle?

923

---

Explain some predefined exceptions.

1003

---

What are the sql aggregate functions?

1074

---

what is myisam? : Sql dba

1016

---

what are the different index configurations a table can have? : Sql dba

951

---

Write a sql query to find the names of employees that begin with ‘a’?

966

---

How to Declare Fixed Length String Value In PL SQL

1117

---

What is mutating table error?

1133

---

What is schema in sql?

898

---

How do you clear the screen in sql?

1024

---

What is a join query?

911

---