What are the components of physical database structure in the Oracle database?

1 Answers  

---

What is Database Buffers ?

1 Answers  

---

how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as only NN,but not other alphabets, if NN is thre means i should display , otherwise leave that blank or empty Its some urgent requirement ,thanks in advance

2 Answers  

---

17. Display the order number and average item cost for each order.

1 Answers   Wipro,

---

I have a table emp. There is only one column in the table. In that , there are only three rows in that column. The value in the first row is 'A' and the value in the second row is 'B' and the third row is 'C'. Now, my question is , How will you write a select query to display the output as B C A Note: order by cannot be used coz it gives us output as CBA. But the output should be BCA.

4 Answers  

---

What is Row Chaining ?

3 Answers   Cognizant, CTS,

---

What is the meaning of recursive hints in oracle?

0 Answers  

---

How is it different from a normal table?

0 Answers  

---

What is a Database instance ? Explain?

3 Answers  

---

Use of an integrity constraint is better to validate data. Explain

0 Answers  

---

How to define a specific record type?

0 Answers  

---

How do you store pictures in a database?

0 Answers  

---