Answer Posted / neha k

to_char function can take both Number and String Values but
one at a time.

ie. select to_char(10) from dual;
select to_char('10') from dual;

both are valid.

Another form of overloaded function to_char accepts two
arguments first is Date and second if its format in which
it needs to be converted as string.

ie. select to_char(sysdate,'YYYYMMDD') from dual;

How to use subqueries with the exists operator in oracle?

1005

---

How to write date and time interval literals in oracle?

1015

---

How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

2149

---

How to invoke the data pump export utility?

1163

---

What is the use of oracle?

1020

---

What are transaction isolation levels supported by oracle?

1046

---

Can we create trigger on materialized view in oracle?

966

---

how the indexes are stored in the Oracle Database?

2257

---

What is the relation of a user account and a schema in oracle?

1067

---

What are the restrictions in a oracle read only transaction?

1008

---

How to commit the current transaction in oracle?

1088

---

What is columnar storage what is the advantage?

1035

---

How to turn on or off recycle bin for the session?

1085

---

How to apply filtering criteria at group level in oracle?

1026

---

What are the roles of dba?

1054

---