Answer / sreekanth

1)Oracle Database 10g offers superior manageability,
resulting in significant advantages and cost savings over
Microsoft SQL Server 2000 and 2005
2)Typical DBA functions are 38 percent faster
3)Requires 30 percent fewer steps, making it less complex
For More check out in the following link :
http://oraclebabu.blogspot.com/2007/08/august-update.html

12 RULES OF RDBMS

1 Answers  

---

How to invoke the original export import utilities?

0 Answers  

---

How does oracle handle read consistency?

0 Answers  

---

What is TNS File

7 Answers   Thermotech,

---

What is the maximum number of CHECK constraints that can be defined on a column ?

3 Answers  

---

1.display list of all users from ur data base.what is the query?

3 Answers   CGI, IBM,

---

What is the difference between substr and instr?

0 Answers  

---

Can we save images in a database and if yes, how?

0 Answers  

---

How many types of cluster table in Oracle?

0 Answers   MCN Solutions,

---

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

0 Answers  

---

What are inner join and outer join?

3 Answers  

---

create or replace procedure show_tab_rec ( P_tab VARCHAR2 ) IS cmd varchar2(50); begin cmd := 'select * from '|| P_tab; for int in ( execute immediate cmd ) loop dbms_output.put_line ( int.ename||' '||int.deptno); end loop; end; when i m compling this procedure i m getting this error PLS-00103: Encountered the symbol "IMMEDIATE" when expecting one of the following: . ( ) , * @ % & | = - + < / > at in is mod remainder not range rem => .. <an exponent (**)> <> or != or ~= >= <= <> and or like LIKE2_ LIKE4_ LIKEC_ between || multiset member SUBMULTISET_ PLZ solve this error give this question answer asap Thanks advance.......

1 Answers   HCL,

---