What is the difference between the Primary and Foreign key?

7 Answers   Cap Gemini,

---

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 a constraint?

0 Answers  

---

What are % type and % rowtype?

0 Answers  

---

what are the authentication modes in sql server? How can it be changed? : Sql dba

0 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  

---

My select statement is not working as expected, So, to overcome from such issues what are the steps needed to be taken care?

2 Answers   CG,

---

What sql does db2 use?

0 Answers  

---

Explain foreign key in sql?

0 Answers  

---

what is meant by nl2br()? : Sql dba

0 Answers  

---

differentiate between float and double. : Sql dba

0 Answers  

---

How toimport .dmp file in lower version of oracle from higher version ?

4 Answers   TCS,

---