Explain table?

0 Answers  

---

What is ceil and floor in oracle?

0 Answers  

---

What is blob data type in oracle?

0 Answers  

---

material view and view disadvantages?

0 Answers  

---

We have one Package(which has many function/procedures, SQL quires etc). Now we need to check, which query or procedure is taking lot of time in that Package. ? How do we do it.

2 Answers   IBM,

---

who is the father of oracle and send chodd rules

4 Answers   ME,

---

Where do we use decode and case statements?

0 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,

---

Give the advantages and disadvantages of clusters.

0 Answers  

---

What is program global area (pga) in oracle?

0 Answers  

---

what are the advantages of running a database in NO archive log mode?

1 Answers  

---

What is where clause in oracle?

0 Answers  

---