Answer / 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

What is format trigger?

0 Answers  

---

Can we convert a date to char in oracle and if so, what would be the syntax?

0 Answers  

---

Please explain joins in oracle?

0 Answers  

---

What are named parameters?

0 Answers  

---

what is the use of system.effective.date variable in oracle?

0 Answers  

---

can you write commit in triggers?

4 Answers  

---

What is not equal to in oracle?

0 Answers  

---

How to set a transaction to be read only in oracle?

0 Answers  

---

What is the difference between SQL, DDL, and DML?

7 Answers   BeBo Technologies, Wipro,

---

Will the Optimizer always use COST-based approach if OPTIMIZER_MODE is set to "Cost"?

1 Answers  

---

Can we create database in oracle using command line ?

0 Answers   MCN Solutions,

---

what is RAID technology?which is better RAID 0+1 OR RAID 5?

2 Answers   CSC,

---