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

Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

2068

---

Explain oracle insert into command?

1115

---

Explain the importance of .pll extension in oracle?

1013

---

How to define a variable to match a table column data type?

993

---

How to save query output to a local file?

1030

---

How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

2182

---

How do I spool in oracle?

1014

---

What is oracle open database communication (odbc)?

1030

---

How to delete multiple rows from a table in oracle?

1065

---

What are the various oracle database objects?

1148

---

What is Reduced List of Values?

2172

---

What is the oracle implicit cursor?

1068

---

How to view existing locks on the database?

1056

---

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

1994

---

How to create a table in a specific tablespace?

979

---