What is the cause of mutating table error and how can we solve it?

0 Answers  

---

define sql insert statement ? : Sql dba

0 Answers  

---

What are the pre requisites?

1 Answers  

---

What does the acronym acid stand for in database management?

0 Answers  

---

how do you count the duplicate records in a table

10 Answers   Tech Mahindra,

---

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  

---

how would you enter characters as hex numbers? : Sql dba

0 Answers  

---

Write a query to get last 10 records from the table.

12 Answers   iNautix,

---

Create a procedure to delete certain records from a table and display the total number of records deleted in this process. (Condition for deletion can be of ur choice, for instance delete all records where eid='')

2 Answers  

---

What is the difference between CHAR and VARCHAR2? If VARCHAR2 serves the uses of CHAR why CHAR is still used and not been discarded yet?

9 Answers   Oracle,

---

What is a recursive stored procedure?

0 Answers  

---

how to retrive only second row from table?

31 Answers   IBM,

---