Answer Posted / kamal saxena

XML Schema is an XML-based alternative to DTD.

 How to use an oracle sequence generator in a mapping?

1016

---

How to create a server parameter file?

1079

---

How view is different from a table?

966

---

Can select statements be used on views in oracle?

978

---

How to find out what oracle odbc drivers are installed?

976

---

How to rename an existing table?

1048

---

> 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?

1979

---

What is the difference between PFILE and SPFILE in Oracle?

993

---

What is pragma autonomous transaction in oracle?

989

---

What is a proxy class?

965

---

What is archive log in Oracle?

1064

---

How to view all columns in an existing table?

869

---

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

2208

---

Explain joins in oracle?

976

---

What is integrity and what is constraint??Explain with example

2213

---