Answer / nishi

yes, using composite primary key.

Answer / a.brahmam

No

How to write a query with a full outer join in oracle?

1 Answers  

---

What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?

1 Answers  

---

What is the function of Redo Log ?

1 Answers  

---

What is null value in oracle?

0 Answers  

---

which institute and which faculty is providing best training for oracle sql, plsql in hyderabad

4 Answers  

---

I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

0 Answers   IBM,

---

What are the types of synonyms?

1 Answers  

---

Explain the use of consistent option in exp command.

0 Answers  

---

can you explain performance tunning in oracle(sql,PL/SQL)

2 Answers  

---

consider some table with 4 r 5 columns in that 1 col is DATE type. The data is like that,For each date in that col some 3 fields r there but all the records r having different data. Now i want to display all the columns by performing grouping on the date field ( as SELECTION Operator(*) cannot be used with group function having only one "group by clause". how to do this? can any one help me in finding out the solution plss?

1 Answers  

---

how can get like this result table A col1 col2 --- ----- a A b B C C .. .. .. ... .. ... wants result like for a single column col1 ------ a,b,c,........n of data and another is col1 ------- A B C D ........ a b b d ........

2 Answers   TCS,

---

What the is the diff between local index and global index. give some example.

0 Answers   TCS,

---