How to convert raw data type into text in oracle? Explain

0 Answers  

---

What is the difference between sharding and replication?

0 Answers  

---

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  

---

find the second highest salary of the emp table

6 Answers  

---

What is partitioned table in Oracle?

0 Answers   MCN Solutions,

---

---

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.

0 Answers  

---

how to delete all duplicate records from a table using subquery?

7 Answers   ABC, Cap Gemini,

---

what is IDE,DMV in sql server?

0 Answers  

---

In my table i have 4 columns with 100 records but in that 4 columns one column contains all NULL values so can i add NOT NULL CONSTRAINT on that column......... ok if it is not possible, can i add NOT NULL CONSTRAINT from 101 Record Onwards?

4 Answers   Cap Gemini,

---

What happens if the imported table already exists?

0 Answers  

---

What is a data dictionary and how can it be created?

0 Answers  

---

What is an oracle user role?

0 Answers  

---