Answer Posted / naveen

to_char function is used to convert the given data into
character....
eg:to_char(sysdate,'month') which returns month alone...

to_date is used to convert the given data into date data
formate data type....

eg: to_date('070903', 'MMDDYY') would return a date value
of July 9, 2003.

What are the different types of database management systems?

949

---

What is sql*plus?

1016

---

What are functions in sql?

899

---

What is trigger with example?

1011

---

How do you write an index?

912

---

Does inner join remove duplicates?

884

---

What is java sql driver?

1037

---

How do I count records in sql?

942

---

Are views faster than queries?

916

---

How many parts of a pl sql block are optional?

1031

---

Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

943

---

explain the advantages and disadvantages of stored procedure? : Sql dba

956

---

How do I turn a list into a table?

905

---

Can I create table without primary key?

937

---

How does one load ebcdic data? : aql loader

1092

---