What is currency type in database ?

3 Answers   TCS,

---

where we have to use ON clause and where we have to use USING clause in JOINS

2 Answers  

---

Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

0 Answers   TCS,

---

How do I connect to oracle database?

0 Answers  

---

What happens to the indexes if a table is recovered?

0 Answers  

---

---

Is it possible to join two tables, that are in two different users (e.g. SCOTT and HR etc.),but im same database (e.g. ORCL)? If yes, then how it is possible? Explain with step by step procedure.

1 Answers   IBM,

---

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,

---

how can get like this result table A col1 col2 --- ----- a A b B C C .. .. .. ... .. ... wants result like for a single column col1 ------ a,b,c,........n of data and another is col1 ------- A B C D ........ a b b d ........

2 Answers   TCS,

---

How to delete an existing row from a table in oracle?

0 Answers  

---

What is SYSTEM tablespace and When is it Created?

2 Answers  

---

What is an oracle tablespace?

0 Answers  

---

What is the difference between alert log file and tarce file ?

0 Answers   TCS,

---