Answer / hr@tgksolutions.com

A deadlock occurs when two or more transactions hold locks that the other needs, causing them to wait indefinitely.
Ways to prevent deadlocks:
• Use consistent lock ordering.
• Keep transactions short and fast.
• Use lower isolation levels when possible.
• Implement deadlock detection mechanisms.

What are the components of physical database structure in the Oracle database?

1 Answers  

---

Can I create users through internet explorer in oracle 10g?

0 Answers   MCN Solutions,

---

> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?

0 Answers  

---

Can a Tablespace hold objects from different Schemes ?

3 Answers  

---

What are the different types of failures that occur in Oracle database?

0 Answers   HCL,

---

Why is oracle used?

0 Answers  

---

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

0 Answers  

---

i must get table name, constraint type, constrain name with using concads "||" and it must be in string type, then with join processes i need code please help immidiately

1 Answers  

---

I have a table like this Table Name:Products Productid Price 1 10 1 10 2 20 3 30 3 30 But i want to output like this. productid price 2 20. please replay me.

3 Answers   TCS,

---

What is define in oracle?

0 Answers  

---

14. Display the item_cost and then round it to the nearest hundred, ten, unit, tenth and hundredth

1 Answers   Wipro,

---

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

0 Answers  

---