When would you denormalize?

8 Answers   MBT, Microsoft, MMU,

---

i have a word ***********hello********world******. I require a o/p **********hello world**********, Need to delete the middle stars.

3 Answers  

---

What are the different types of constraints?

0 Answers  

---

What is acid property in a database?

0 Answers  

---

type type_name is table of varchar2(30) index by binary_integer for the above type you have to create a identifier... like identifier_name type_name; for the above type you can use the below methods..like first , last , prior, next , delege..etc...like this.. if you create a cursor...like cursor cursor_name is select * from scott.emp; is there any methods like above to use prior, fist , last , next , trim ,etc...

1 Answers   Satyam,

---

how to eliminate null values in a column i.e table vlaues 1 2 3 NULL 3 4 1 5 NULL i want output like this 1 2 3 3 4 1 5 i dnt want to use nvl is null and i dnt want replace the NULL value with any value i.e nvl(col,o);

11 Answers   Satyam,

---

What does pl sql developer do?

0 Answers  

---

What steps server process has to take to execute an update statement?

0 Answers  

---

Which command is used to delete a package?

0 Answers  

---

How do you update f as m and m as f from the below table testtable?

0 Answers  

---

How do I start sql from command line?

0 Answers  

---

What is cursor and its types?

0 Answers  

---