If records are inserted into table without committing.How to refer to these values in a procedure?

2 Answers  

---

how to retrieve last tree records from table? select *from emp where rownum > (select count(*)-3 from emp); i am using this query to get last three records from table but its not giving any output, so please tell me what is the error in this query.

16 Answers  

---

What is trigger and types?

0 Answers  

---

How is use pl and sql?

0 Answers  

---

What is sp_helptext?

0 Answers  

---

---

what are wild cards used in database for pattern matching ? : Sql dba

0 Answers  

---

i want count no of values in a column i.e enam eempno phoneno x 1 (98765,09887,096561,87964579,156678,678900876) that means if i select phone no from table i want to get total count of phone numbers i.e 6

8 Answers   Satyam,

---

Why we use joins in sql?

0 Answers  

---

What operators deal with null?

0 Answers  

---

What are the different schemas objects that can be created using pl/sql?

0 Answers  

---

What is a parameter query?

0 Answers  

---

How do you use join?

0 Answers  

---