Answer Posted / ssk

1. DENSE_RANK is an Analytical Function which doesn't leave
gaps between the records. Coming to Rank function it leaves
gaps between the records.

Eg:

(RANK) (DENSE_RANK)

Sno Marks Ranks Sno Marks Ranks
----- ----- ----- ----- ----- -----
1 100 1 1 100 1
2 100 1 2 100 1
3 200 3 3 200 2
4 300 4 4 300 3
5 300 4 5 300 3
6 400 6 6 400 4

2. Substr will displays the text from position to TO position.
Instr returns the position of the character.

Eg: SELECT SUBSTR('ORACLE',2,4) FROM DUAL;
O/P : RAC

SELECT INSTR('ORACLE IS A DATABASE','A',1,2) from dual;
O/P : 11

3. PSEUDO Column : A column which is not an actual column in
the table. Eg : ROWNUM,ROWID,SYSDATE,USER,UID..

Explain the use of full option in exp command.

1173

---

What is BBED in Oracle?

1196

---

How can I combine multiple rows into a comma-delimited list in oracle?

1112

---

What is an oracle tablespace?

1092

---

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

1233

---

why dont we assign not null constraint as table level constraint.

2793

---

What is background process in Oracle?

1136

---

In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??

1705

---

What are the uses of linked server and explain it in detail?

1117

---

How to drop an index?

1010

---

How to get execution path reports on query statements?

1041

---

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2393

---

What is a trigger oracle?

1134

---

Explain the blob datatype?

1122

---

How much memory your 10g xe server is using?

1148

---