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.

Is mariadb a nosql database?

1055

---

What is cross join sql?

917

---

What are the popular database management systems in the it industry?

999

---

Is sql a dbms?

1010

---

How do temporal tables work?

957

---

What is the basic structure of an sql?

1098

---

State some properties of relational databases?

1056

---

what is an alias command? : Sql dba

1111

---

Does a join table need a primary key?

953

---

What is execute immediate?

1084

---

What does := mean in pl sql?

1042

---

What is a stored procedure in sql with example?

1131

---

Is grant a ddl statement?

896

---

Is sql an operating system?

1019

---

what is the bond code in materialized view?

3002

---