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;

Define SQL and state the differences between SQL and other conventional programming Languages?

1222

---

What is the max nvarchar size?

983

---

What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

1003

---

Can we create view in stored procedure?

979

---

Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

1039

---

What is substitution variable?

1056

---

what is rollback? : Sql dba

1115

---

what is try_catch block in procedure

1753

---

What is trigger explain with example?

1044

---

what is 'mysqlshow'? : Sql dba

1029

---

What are the basic techniques of indexing?

1065

---

What is bind variable in pl sql?

1057

---

What is the difference between a procedure and a function?

1119

---

how to convert character strings to dates? : Sql dba

1065

---

What are all ddl commands?

1086

---