Answer Posted / m

to_char conversion function will convert given data to character data whereas to_data will convert given character data into date format model.


Also we can say like to_char conversion function use for convert invalid data into valid data.
and to_date conversion function will convert valid data into invalid.

How many types of cursors are available in pl/sql?

1100

---

How do you drop a trigger?

984

---

What is normalisation and its types?

996

---

What are the usages of sql?

1056

---

how to install mysql? : Sql dba

1102

---

How you improve the performance of sql*loader? : aql loader

1009

---

how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba

1338

---

What is constant in pl sql?

1012

---

Why truncate is faster than delete?

1103

---

Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?

2277

---

Can we use view in stored procedure?

891

---

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

1139

---

How would you pass hints to the sql processor?

978

---

What is sql query limit?

974

---

what is the functionality of the function htmlentities? : Sql dba

949

---