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 a left inner join?

1011

---

1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins

1594

---

What is join view in sql?

944

---

Can we use commit inside a trigger?

1086

---

Can we perform dml in function?

1063

---

What is replication id?

934

---

How many types of sql are there?

986

---

Can we join more than 2 tables in sql?

1015

---

Is progress software supports to ( pl/sql )?

1033

---

Difference between table function and pipelined function?

1017

---

How exception is different from error?

1014

---

Which is faster count (*) or count 1?

1028

---

Can we insert in sql function?

1081

---

What are the features of pl sql?

1063

---

What are reports usually used for?

1019

---