Answer Posted / nishi

A cluster is a schema object that contains data from one or more tables, all of which have one or more columns in common. Oracle Databasestores together all the rows from all the tables that share the same cluster key.

How many anonymous blocks can be defined?

1098

---

How to get maxsal , minsal, ename department wise in single query

1498

---

Which is better Oracle or MS SQL? Why?

6259

---

What is a nested table?

1000

---

> 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 do you understand by a database object?

985

---

How to create an oracle database?

975

---

List out the types of joins.

1079

---

What is the string concatenation operator in oracle?

1090

---

What is catalog in Oracle?

1262

---

11. Display the client number and name and the client number and name of the person who referred that client.

2270

---

What is meant by recursive hints in oracle?

1023

---

Explain temporal data types in oracle

1039

---

How to increment dates by 1 in oracle?

986

---

How to find out what oracle odbc drivers are installed?

976

---