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;

Explain a synonym?

1088

---

What are the roles of dba?

1136

---

How can we create the complete backup of data in the oracle.

2200

---

What is the difference between a hot backup and a cold backup in oracle?

1076

---

How to define a variable to match a table column data type?

1038

---

What is the difference between $oracle_base and $oracle_home?

1136

---

What is program global area (pga) in oracle?

1091

---

How to install oracle odbc drivers?

1144

---

What is sharded cluster?

1070

---

What is the maximum limit on the number of columns in a table?

1152

---

In which language oracle has been developed?

1135

---

List the parts of a database trigger.

1108

---

What is pragma autonomous transaction in oracle?

1123

---

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1992

---

How to import one table back from a dump file?

1085

---