Answer / barun

Function-1.function used for calculation perpose.it must
return value.(call by pl/sql code block,by sql query)

Procedure-it is used to implement business logic.it may or
not return value.it pre compile and stored in server data
base.so it is faster.(call by pl/sql code block_

trigger-it is used to implement business logic and maintain
intigrity.it cant take any para-meter like fun or
procedure.it is automatically fired(implicitely)

How many types of sql are there?

0 Answers  

---

What is the difference between anonymous block and named blocks?

3 Answers  

---

What is recursive join in sql?

0 Answers  

---

What are sql injection vulnerabilities?

0 Answers  

---

If records are inserted into table without committing.How to refer to these values in a procedure?

2 Answers  

---

What is a field in a database?

0 Answers  

---

What is indexing in sql and its types?

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,

---

how to convert character strings to dates? : Sql dba

0 Answers  

---

What is sql injection owasp?

0 Answers  

---

What is dml with example?

0 Answers  

---

how can we know the number of days between two given dates using mysql? : Sql dba

0 Answers  

---