What is SGA ? How it is different from Ver 6.0 and Ver 7.0 ?

1 Answers   TCS,

---

What is oracle update statement with inner join ?

0 Answers  

---

We have one Package(which has many function/procedures, SQL quires etc). Now we need to check, which query or procedure is taking lot of time in that Package. ? How do we do it.

2 Answers   IBM,

---

State the various uses of dbcc command?

0 Answers  

---

Explain a private synonyms?

0 Answers  

---

diff between DELETE and TRUNCATE?.

14 Answers   HCL, Yalamanchili Software,

---

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  

---

What is integrity and what is constraint??Explain with example

0 Answers   Google,

---

How will you differentiate between varchar & varchar2?

0 Answers  

---

How to display First 4 rows From Database Table?

6 Answers  

---

1.display list of all users from ur data base.what is the query?

3 Answers   CGI, IBM,

---

What are the extensions used by oracle reports?

0 Answers  

---