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.

Which kind of parameters cannot have a default value in pl sql?

595

---

Can we commit inside a trigger?

549

---

What are the different types of database management systems?

532

---

what is a scheduled jobs or what is a scheduled tasks? : Sql dba

554

---

How do I clear the screen in sql plus?

553

---

---

Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

497

---

Is mariadb nosql?

586

---

What are sql objects?

542

---

how mysql optimizes distinct? : Sql dba

555

---

What is sap sql anywhere?

535

---

How exception handling is done in advance pl/sql?

501

---

How do you write a complex sql query?

589

---

How to read xml file in oracle pl sql?

509

---

What is the use of double ampersand (&&) in sql queries? Give an example

613

---

Explain the the delete statements in sql?

581

---