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

2 Answers  

---

How we get all_group_function's(Sum,avg,count,max and min_value of a column(Sal) Using pl/sql anonymous block, with out using group function's. You shouldn't use more than one select statement in entire the program. Like cursor c is select * from <table_name>; except this you can't use another select statement. You can use no of variables as per requirement.

1 Answers  

---

Fetch an entire row from the employees table for a specific employee ID:

2 Answers  

---

What is the difference between UNIQUE KEY and UNIQUE INDEX?

3 Answers   TCS,

---

What is sorting in sql?

0 Answers  

---

what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba

0 Answers  

---

what is the difference between implicit and explicit trigger

2 Answers   Tech Mahindra,

---

How does sql store data?

0 Answers  

---

What is a null value?

0 Answers  

---

write a query find which rows of a table is updated on 2 days before?

3 Answers   TCS,

---

Are stored procedures compiled?

0 Answers  

---

How many unique keys can a table have?

0 Answers  

---