what is commit? : Sql dba

0 Answers  

---

what is a constraint? : Sql dba

0 Answers  

---

3. Select sum(a) sum_1,max(a) max_1 ,count(a) count_1 from ( ( select 1 a from dual union all Select to_number(‘2011’) a from dual union all select 1 a from dual) union select 2 b from dual);

1 Answers   Fintellix,

---

table name: prod there are three fields in the table that are 1.proddate 2.prodQty 3.model Day wise prodQty is stored in the table prod write a query to display total prodqty in the year 2004 april.

2 Answers   Maruti Suzuki,

---

what is 'mysqlshow'? : Sql dba

0 Answers  

---

which will fire first ? Trigger or Constraint

24 Answers   i2, IBM,

---

How to assign sql query results to pl sql variables?

0 Answers  

---

Differences between UNIQUE and DISTINCT in select statements

26 Answers   ABS, DELL, Deloitte, Hewitt, Oracle, Verinon Technology Solutions, Wipro,

---

how can we find the select statement is indexed or not?

3 Answers   CTS,

---

What view means?

0 Answers  

---

What are the triggers associated with image items?

0 Answers  

---

- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

0 Answers   CTS,

---