What is a scalar value in sql?

0 Answers  

---

Mention what problem one might face while writing log information to a data-base table in pl/sql?

0 Answers  

---

Can cursors be part of a trigger body?

0 Answers  

---

How to use sql statements in pl/sql?

0 Answers  

---

table name: prod there are three fields in the table that are 1.proddate 2.prodQty 3.model Day wise prodQty is stored in the table prod write a query to display total prodqty in the year 2004 april.

2 Answers   Maruti Suzuki,

---

---

What are the steps you take to tune(performance tuning) the code in plsql?

4 Answers   Cap Gemini, Infosys, TCS,

---

Write the order of precedence for validation of a column in a table ?

2 Answers  

---

What is primary and foreign key?

0 Answers  

---

Can we rollback after truncate?

0 Answers  

---

3. Select sum(a) sum_1,max(a) max_1 ,count(a) count_1 from ( ( select 1 a from dual union all Select to_number(‘2011’) a from dual union all select 1 a from dual) union select 2 b from dual);

1 Answers   Fintellix,

---

Is vs as in pl sql?

0 Answers  

---

Can we use having without group by in sql?

0 Answers  

---