Answer Posted / sudipta santra

select sum(bytes / (1024*1024)) "DB Size in MB" from
dba_data_files;

If u have the access of the table dba_data_files

How to select an oracle system id (sid)?

577

---

How to create a new table in your schema?

601

---

Calculate difference between 2 date / times in oracle sql?

564

---

What happens if you lost a data file?

574

---

How to delete an existing row from a table in oracle?

639

---

---

Give the advantages and disadvantages of clusters.

568

---

How to see the table columns used in an index?

587

---

What is coalesce function?

565

---

Explain the use of Merge statement in oracle 11g

588

---

How do I limit the number of oracle database connections generated by weblogic server?

543

---

Can a parameter be passed to a cursor?

596

---

How to delete a user account in oracle?

547

---

For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

1552

---

What is oracle rowcount?

568

---

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

1613

---