Can a select statement fire a trigger?

0 Answers  

---

What is Materialized View? In What Scenario we Use Materialized View?

2 Answers   Dinesh, Marlabs,

---

Difference between inline query and stored procedure?

4 Answers   Bharat, Microsoft,

---

How can u find column name from a table which have max value in a row.( not max value)

5 Answers  

---

What are sql objects?

0 Answers  

---

What is oracle ? why we should go for oracle database instead of diffrent databases available in the industry.

5 Answers   Polaris,

---

How to avoid using cursors? What to use instead of cursor and in what cases to do so?

0 Answers  

---

What are the advantages of indexing?

0 Answers  

---

What do you understand by case manipulation functions?

0 Answers  

---

What is difference between pls_integer and integer?

0 Answers  

---

What is information schema in sql?

0 Answers  

---

First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.

0 Answers   Prodapt,

---