Answer / hemant

Interprter works line by line but compiler execute its all
work as a program..like if any sql query has error then sql
will how that x line has error ..

explain access control lists. : Sql dba

0 Answers  

---

Can we use two order by clause in query?

0 Answers  

---

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

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,

---

How many commands are there in sql?

0 Answers  

---

Easy way to convert tableau "IF - ELSEIF" statements to Netezza "CASE" statements.

1 Answers   CTS,

---

What is the purpose of my sql?

0 Answers  

---

what are the demerits of sql?

1 Answers  

---

What are the steps for performance tuning.

0 Answers  

---

What is null in pl/sql?

0 Answers  

---

Explain commit, rollback and savepoint.

0 Answers  

---

write a pl/sql function if enter a value=0 then output value=1 and vise verse with out using if and case statements.

3 Answers   Zensar,

---