how many tables will create when we create table, what are they? : Sql dba

0 Answers  

---

How will you a activate/deactivate integrity constraints?

2 Answers  

---

what is the different between unique+not null & primary key,

4 Answers  

---

what is the main difference between join and subqurey?

3 Answers   Oracle,

---

need to split a string into seperate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,b,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.

1 Answers  

---

Why is pl sql needed?

0 Answers  

---

What is an Exception ? What are types of Exception ?

2 Answers  

---

Does truncate free space?

0 Answers  

---

how can we write a column values horizontal by using sql stmt; ex: select name from table_name;(actual output) a b c d require output is a b c d

5 Answers   Honeywell, Interact,

---

What are properties of the transaction?

0 Answers  

---

how to use case expression? : Sql dba

0 Answers  

---

What are different types of keys?

0 Answers  

---