What is optimistic concurrency control? : Transact sql

0 Answers  

---

Explain the insert into statements in 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,

---

Is natural join and inner join same?

0 Answers  

---

i want to display 1 to 10 numbers using one select statement.

18 Answers   HCL, Nyros, Oracle,

---

---

If 100 tables are there in user_tables.I want to find in which table zero records are there with table name.Is it possible?

2 Answers  

---

Can we use ddl commands in pl sql?

0 Answers  

---

What is primary key in db?

0 Answers  

---

What is the max nvarchar size?

0 Answers  

---

what are the advantages and disadvantages of views in a database? : Sql dba

0 Answers  

---

Can we insert in sql function?

0 Answers  

---

What is the difference between the Primary and Foreign key?

7 Answers   Cap Gemini,

---