hi this is nakka i have been looking for 1+ exp in oracle sql,plsql developer positions also have knoledge on d2k i am not getting proper walkins how to know it? where can i find it?

5 Answers  

---

What are the advantages of pl sql over sql?

0 Answers  

---

Where the Pre_defined_exceptions are stored ?

2 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,

---

What is mutating table?

11 Answers   Saama Tech,

---

---

I Defined SP1, Sp2 (sp=StoreProcedures)In Package Specification but I Implemented Sp1, sp2, sp3, sp4, sp5 then What type of Error You will find????

3 Answers   Infosys,

---

wirte a query to remove null? following table are col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output like col1 col2 col3 dinesh suresh prkaesh

6 Answers   TCS,

---

How can we make an if statement within a select statement?

0 Answers  

---

Explain how can you save or place your msg in a table?

0 Answers  

---

What is a string data type in sql?

0 Answers  

---

What is Temp Table and type of temp table?

1 Answers   HP, SLK,

---

what are numeric data types? : Sql dba

0 Answers  

---