Answer Posted / ruth

Oracle 9i has a new datatype Timestamp

What is rownum?

982

---

How to select 10 records from a table?

1157

---

What is rtm stands for?

1100

---

What is microsoft t sql?

949

---

what are the non-standard sql commands supported by 'mysql'? : Sql dba

1120

---

How to avoid using cursors? What to use instead of cursor and in what cases to do so?

1193

---

What is the difference between explicit and implicit cursors in oracle?

1069

---

Explain character-manipulation functions?

1134

---

What is a sql*loader control file?

1266

---

How to change sql*plus system settings?

1055

---

What is pl sql collection?

970

---

Can you inner join the same table?

991

---

How is pl sql different from sql?

1093

---

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

2555

---

What is an oracle stored procedure?

1053

---