What is pragma in sql?

0 Answers  

---

What is a procedure in pl sql?

0 Answers  

---

Explain the working of primary key?

0 Answers  

---

What are triggers and its types?

0 Answers  

---

what is the command used to fetch first 5 characters of the string? : Sql dba

0 Answers  

---

---

what is 'force view'?

3 Answers   Cap Gemini, SPIC,

---

What are the various levels of constraints?

0 Answers  

---

what is the difference between rownum pseudo column and row_number() function? : Sql dba

0 Answers  

---

What is the best partition size for windows 10?

0 Answers  

---

how do you restrict number of rows for a particular value in a column.For example:there is a table called fruits,having apples,bananas ,papayas.I dont want to have more than 100 apples in that table ,so how can u restrict number of rows for apple to hundred?

6 Answers  

---

Can a view be mutating? If yes, then how?

0 Answers  

---

Name Salary Abc 50000 Abc 50000 xyz 20000 find the max salary using aggregate function?

2 Answers   CTS,

---