Answer Posted / dharmendra

select to_char(sysdate,'DD/MON/YYYY') from dual;

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2396

---

How to sort output in descending order in oracle?

1101

---

What are the various types of snapshots ?

1082

---

what is difference between sql plus and sql*plus? (not sql and sql plus).

3941

---

How to create a new tablespace in oracle?

1032

---

How many file formats are supported to export data?

1266

---

What happens to the indexes if a table is recovered?

1045

---

How are extents allocated to a segment?

1181

---

How to recover a dropped table in oracle?

1094

---

Can multiple cursors being opened at the same time?

1115

---

How to select an oracle system id (sid)?

1120

---

What is a system tablespace?

1132

---

How to work with data objects interactively?

1042

---

How can I combine multiple rows into a comma-delimited list in oracle?

1115

---

How to use an explicit cursor without open statements?

1100

---