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 the use of count (*) in sql?

0 Answers  

---

How do you rank data in sql?

0 Answers  

---

How write primary and foreign key relationship between two tables without using constraints? u can use any of procedure/function/trigger and any sql?

1 Answers   Parexel,

---

Which join is default?

0 Answers  

---

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

0 Answers  

---

What is the starting oracle error number?

0 Answers  

---

How to run pl/sql statements in sql*plus?

0 Answers  

---

what are string data types? : Sql dba

0 Answers  

---

Why functions are used in sql?

0 Answers  

---

What are instead of triggers?

0 Answers  

---

What are all ddl commands?

0 Answers  

---