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 an inconsistent dependency?

976

---

Explain unique key in sql.

942

---

what happens if null values are involved in expressions? : Sql dba

999

---

Which is faster truncate or drop?

978

---

can sql servers linked to other servers like oracle? : Sql dba

949

---

What is t sql used for?

968

---

Is id a reserved word in sql?

1088

---

What is sql prepared statement?

936

---

What is pessimistic concurrency control? : Transact sql

1023

---

mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql

989

---

What is a recursive join sql?

1024

---

How can we debug in PL/SQL?

1089

---

What is the difference between microsoft sql and mysql?

919

---

Explain ddl statements in pl/sql?

957

---

Does truncate release storage space?

1012

---