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 do I run a sql query?

0 Answers  

---

if we give update table_name set column_name= default. what will happen? its given in pl sql block.what will hapen?

5 Answers   iFlex,

---

How insert into statements in sql?

0 Answers  

---

what is SCALAR Queries?

2 Answers   ITC Infotech,

---

What is pseudo column ?

6 Answers   ABB,

---

which will default fire first  statement level trigger or row level trigger

2 Answers   Cap Gemini, Data Vision,

---

what is row? : Sql dba

0 Answers  

---

Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com

0 Answers   TCS,

---

Why do we use joins?

0 Answers  

---

what is a join? : Sql dba

0 Answers  

---

What is package in pl sql with an examples?

0 Answers  

---

can i write pl/sql code in a package

2 Answers  

---