What is pragma restrict_reference in oracle 9i?When we use this?Give me one realtime scenario?

4 Answers   Microsoft, Wipro,

---

Explain oracle’s system global area (sga).

0 Answers  

---

What happens to the current transaction if the session is killed?

0 Answers  

---

10)In an RDBMS, the information content of a table does not depend on the order of the rows and columns. Is this statement Correct? A)Yes B)No C)Depends on the data being stored D)Only for 2-dimensional tables

6 Answers   Mind Tree,

---

We need to compare two successive records of a table based on a field. For example, if the table is CUSTOMER, and the filed is Account_ID, To compare Account_IDs of record1 and record2 of CUSTOMER table, what can be the query ?

3 Answers  

---

---

why pl sql doesn't support retrieving multiple records

1 Answers   Mphasis,

---

which is best insttute for teradata,sybase,mysql,oracle in hyderabad

1 Answers  

---

What is the difference between online and offline backups?

0 Answers   MCN Solutions,

---

ex. one table is having 1 column with 10 records , then how to display all the values in row wise ?

4 Answers  

---

What is the difference between an Oracle Schema and an Oracle Instance?

3 Answers   IBM,

---

What are the advantages of Views ?

3 Answers  

---

How to select all columns of all rows from a table in oracle?

0 Answers  

---