Answer / yasaswini

the major differences between Oracle9i and Oracle10g:

Major changes to SQL optimizer internals

Oracle Grid computing

AWR and ASH tables incorporated into Oracle Performance
Pack and Diagnostic Pack options

Automated Session History (ASH) materializes the Oracle
Wait Interface over time

Data Pump replaces imp utility with impdp

Automatic Database Diagnostic Monitor (ADDM)

SQLTuning Advisor

SQLAccess Advisor

Rolling database upgrades (using Oracle10g RAC)

dbms_scheduler package replaces dbms_job for scheduling

How to update salary of employees department wise?

6 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  

---

How to get unique records from a table?

0 Answers  

---

I have a small PL/SQL Block assume in this way begin select * from emp where empno=100; exception when others then <Some Messages> when no_data_found then <Some Messages> when too_many_rows then <Some Messages> end; The question which he asked was whether this block will get executed normally or it will throw error ? If errored out then what is the reason for the error ? Could anybody please help me ? Regards Nakul Venkataraman

3 Answers   Satyam,

---

How to come back in normal stage in Mutating Table if mutating table is locked or update data?

2 Answers  

---

can we update a view which is created from two tables

11 Answers  

---

What is sql server and ase?

0 Answers  

---

what is meant by nl2br()? : Sql dba

0 Answers  

---

how to create object in plsql

2 Answers   TCS,

---

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

1 Answers   Sollet Soft,

---

What is the best sql course?

0 Answers  

---

How do you run a query?

0 Answers  

---