what are the types of join and explain each? : Sql dba

0 Answers  

---

difference between table level constraint and column level and advantages of table level constraint

4 Answers   Doyensys,

---

What is scope and visibility in PL/SQL?

0 Answers  

---

How to take user input in pl sql?

0 Answers  

---

How we get all_group_function's(Sum,avg,count,max and min_value of a column(Sal) Using pl/sql anonymous block, with out using group function's. You shouldn't use more than one select statement in entire the program. Like cursor c is select * from <table_name>; except this you can't use another select statement. You can use no of variables as per requirement.

1 Answers  

---

What are expressions?

0 Answers  

---

Explain cursor types?

0 Answers  

---

how i do the database testing of online money transactions between two parties (client and organization). suppose our company makes a website for our client and give a extra feature of online money transaction with there clients then how i test this feature in database testing

1 Answers  

---

overloading of stored procedure is possible in oracle?

3 Answers   Nelco,

---

How many database objects (trigger, packages, sequence etc) uses a particular field in a given table. For ex: I want to know how many database object uses the ATTRIBUTE1 in the PO_VENDORS table. What query will give me the result showing the database object name(package, trigger etc), field_name used (in this case ATTRIBUTE1) and table_name (in this case PO_VENDORS).

2 Answers   IBM,

---

What is the difference between microsoft access and sql server?

0 Answers  

---

List out the acid properties and explain?

0 Answers  

---