Answer / shobhit

we can tune our code as folllows

1:reducing no of lines in code

2: using indexes based columns in our sql select statements.

3: using the best logics

Answer / raaaa

tuning the code is complier the output than code is verify

What is a rank in sql?

0 Answers  

---

What is synchronized subquery?

0 Answers  

---

What is extent clause in table space?

1 Answers   TCS,

---

Is pl sql a programming language?

0 Answers  

---

Which join condition can be specified using on clause?

0 Answers  

---

What is the purpose of the partition table?

0 Answers  

---

What are system versioned tables?

0 Answers  

---

What is the difference between jpql and sql?

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,

---

I have one table and column is c1 pk, c2 not null,c3 not null and 200 row in it and i add c4 column and value, how can is possible

9 Answers  

---

What is data modelling in sql?

0 Answers  

---

What is an index in sql with example?

0 Answers  

---