1) What is dense ranking? 2) Difference between Substring and Instring? 3) Case and Decode? 4) Pseudo column? 5) View vs Materialized views? 6) SQl performance tuning?

2 Answers   Accenture,

---

what is the syntax of UPDATE command?

8 Answers  

---

Explain temporal data types in oracle

0 Answers  

---

how many outer joins are used in a single sql query? is there any limitations for using of outer joins?

2 Answers   BOB Technologies, Cap Gemini, IBM,

---

Is it possible to set second Primary Key Constraint in a table in Oracle Database ?

0 Answers   MCN Solutions,

---

When system tablespace is created?

0 Answers  

---

dear sir/madam, i have done my engg in 2007 after that i did oracle course (sql,plsql,forms,reports) .from 2008 to 2009 i searched job but didnt got.so i planned to move to sales field & i gone to dubai.till now i m in sales only.now i want to shift my career in to IT industry.but now people are not hiring as fresher.so i planned put fake 1 + exp. is it good or bad or any other way is there to enter in IT.please suggest me or call me 09632087338.

3 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 to retrieve data from an cursor to a record?

0 Answers  

---

How are Indexes Update ?

1 Answers  

---

Can you assign multiple query result rows to a variable?

0 Answers  

---

What is Library Cache in Oracle?

0 Answers   MCN Solutions,

---