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

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

0 Answers   EDC,

---

How to count duplicated values in a column in oracle?

0 Answers  

---

What is the simplest tool to run commands on oracle servers?

0 Answers  

---

What is Hash Cluster ?

2 Answers  

---

how to retrive xml data for using sql query?

3 Answers   IBM, TCS,

---

---

How to create a stored function in oracle?

0 Answers  

---

How to write date and time literals in oracle?

0 Answers  

---

How to find out what privileges a user currently has in oracle?

1 Answers  

---

11. Display the client number and name and the client number and name of the person who referred that client.

0 Answers   Wipro,

---

SELECT THE RECORDS FROM 3 TABLES LIKE(T1,T2,T3) AND HOW CAN WE INSERT THAT RECORD IN ANOTHER TABLE LIKE(T4)?

1 Answers   ESS,

---

how to get last monday of a month?

2 Answers   Multifonds,

---

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

0 Answers  

---