What are sql built in functions?

0 Answers  

---

What is optimistic concurrency control? : Transact sql

0 Answers  

---

In a package if we have 10 procedures or functions,How to know which will execute first?

1 Answers   Sollet Soft,

---

What type of join is sql join?

0 Answers  

---

write a procedure to find top second no from a list of numbers

1 Answers   ABC,

---

---

What are user defined functions?

0 Answers  

---

Why stored procedure is faster than query?

0 Answers  

---

Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

0 Answers  

---

What is the process of debugging?

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,

---

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,

---

Types of cursor locks and explanation each of them ?

3 Answers   DELL, HP Finsoft,

---