Answer / Ravi Shankar

"The ROWNUM pseudocolumn in Oracle returns the sequence number of a row within a query result set. It is only available after the query has been executed. On the other hand, the ROW_NUMBER() function in both Oracle and SQL Server returns a unique number for each row in the result set. It can be used in the SELECT statement itself."

What are the types of variables use in pl sql?

1 Answers  

---

Is time a data type in sql?

1 Answers  

---

What is replication id?

1 Answers  

---

What does select count (*) mean in sql?

1 Answers  

---

What are the types of join in sql?

1 Answers  

---

Is there any restriction on the use of union in embedded sql?

1 Answers  

---

what is the difference between truncate and drop statements? : Sql dba

1 Answers  

---

What is data modelling in sql?

1 Answers  

---

What are the basic techniques of indexing?

1 Answers  

---

How can analyze query after generating explain plan ?

2 Answers   Thermotech,

---

1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins

1 Answers   CTS,

---

What is sql select statement?

1 Answers  

---