what is difference between procedure and function, procedure and trigger?

8 Answers   iFlex,

---

I have 2 table A and B. In A 1 lakh record is present. In b 20 thousand data is present. To get the unique data from table A and B which join we should prefer left inner join or right outer join. Please answer.

4 Answers   GE,

---

Does access use sql?

0 Answers  

---

What is a trigger in pl/sql?

1 Answers  

---

What is the Query to print out the individual total number of duplicate row in sql.

5 Answers   TCS,

---

---

What is difference between sql function and stored procedure?

0 Answers  

---

What are the advantages of pl sql?

0 Answers  

---

how to dump a table to a file with 'mysqldump'? : Sql dba

0 Answers  

---

What is a clob 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,

---

What is Primary Key?

4 Answers   Ramco,

---

What is foreign key in sql with example?

0 Answers  

---