How is Oracle 10g helpful when compared to oracle 9i and what is grid computing

1 Answers   Flextronics,

---

Explain constraints in sql?

0 Answers  

---

Are dml statements autocommit?

0 Answers  

---

Is nosql relational?

0 Answers  

---

How do you retrieve the last N records from a table?

10 Answers  

---

What are different types of triggers?

0 Answers  

---

What is difference between ms sql and mysql?

0 Answers  

---

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,

---

Create table emp (id number(9), name varchar2(20),salary number(9,2)); The table has 100 records after table created.Now i nee to change id's Datatype is to be Varchar2(15). now Alter table emp modify(id varchar2(15),name varchar2(20), salary number(9,2)); Whether it will work or returns error? post answer with explanation.

13 Answers   Oracle, TCS,

---

In a package if we have 10 procedures or functions,How to know which will execute first?

1 Answers   Sollet Soft,

---

What is Temp Table and type of temp table?

1 Answers   HP, SLK,

---

what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

0 Answers  

---