What are the advantages of the packages

6 Answers   Oracle,

---

What are the different types of joins and explain them briefly.

3 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 are the types of sql commands?

0 Answers  

---

Define overloaded procedure?

0 Answers  

---

Does view store data in sql?

0 Answers  

---

table name :Tab fields name 1.trx_no (pk) 2.trx_date 3.account code (7 char) 4.account type (1 char) 5.amt Tab contains account code day wise debit and credit transaction , account type fiels can have 2 value D for debit and c for Credit . write a query to display the account code wise total debit and credit bal for the month of april 2004. write a query to display account code wise new amt credit for the april 2004

2 Answers   Maruti Suzuki,

---

What are the different types of dbms?

0 Answers  

---

Why do we use partitions in sql?

0 Answers  

---

Explain the structure of pl/sql in brief.

0 Answers  

---

What is sql rowcount?

0 Answers  

---

Why sql query is slow?

0 Answers  

---