How to convert times to characters in oracle?

0 Answers  

---

What are the data types in oracle?

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,

---

dear sir/madam, i have done my engg in 2007 after that i did oracle course (sql,plsql,forms,reports) .from 2008 to 2009 i searched job but didnt got.so i planned to move to sales field & i gone to dubai.till now i m in sales only.now i want to shift my career in to IT industry.but now people are not hiring as fresher.so i planned put fake 1 + exp. is it good or bad or any other way is there to enter in IT.please suggest me or call me 09632087338.

3 Answers  

---

How to use "in" parameter properly?

0 Answers  

---

---

What are inner join and outer join?

3 Answers  

---

Without giving condition how to retrieve the unmatched records from table.

1 Answers   TCS,

---

which is best institue to learn oracle 11i in ameerpet or maithrivanam or sr nagar please help

5 Answers  

---

What are the different types of trigger and explain its various uses and functions?

0 Answers  

---

What is the difference between substr and instr?

0 Answers  

---

How does the on-delete-cascade statement work?

0 Answers  

---

What is a recycle bin in oracle?

1 Answers  

---