Can a foreign key be a duplicate?

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  

---

What does the acronym acid stand for in database management?

0 Answers  

---

What is the clause we need to add in function body to return variable?

0 Answers  

---

Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?

0 Answers  

---

---

Why we use join in sql?

0 Answers  

---

Is it possible to link two groups inside a cross products after the cross products group has been created?

0 Answers  

---

What are properties of the transaction?

0 Answers  

---

What is scalar function?

0 Answers  

---

What is the purpose of normalization?

0 Answers  

---

How the execution will be done in exceptions?

2 Answers  

---

Can we use the cursor's to create the collection in PL/SQL?

0 Answers   MCN Solutions,

---