Answer Posted / rajesh

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 is cost in sql execution plan?

977

---

What is offset and limit in sql?

1055

---

Can we join tables without foreign key?

957

---

What is full join in sql?

987

---

Which join is default?

950

---

how to drop an existing table in mysql? : Sql dba

1042

---

Is it important to partition hard disk?

1022

---

How many joins can you have in sql?

934

---

explain access control lists. : Sql dba

997

---

what does it mean to have quoted_identifier on? : Sql dba

1144

---

Can a procedure in a package be overloaded?

1043

---

Which is better join or inner query?

1040

---

Is sql better than excel?

1148

---

how to convert numeric values to character strings? : Sql dba

1101

---

What type of database is cloud sql?

1095

---