What are privileges and grants?

0 Answers  

---

If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?

8 Answers   IBM,

---

candidate key is subset of super key but not vice-verse explain

0 Answers  

---

How to generate query output in html format?

0 Answers  

---

How to call a stored function in oracle?

0 Answers  

---

Explain the family trees and connection by clause

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  

---

What is the difference between post-database commit and post-form commit?

0 Answers  

---

How to work with data objects interactively?

0 Answers  

---

> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?

0 Answers  

---

What are Schema Objects ?

2 Answers  

---

Maximum how many triggers can be updated in table ?

5 Answers   Accenture, Cap Gemini,

---