Answer Posted / mamta

Select sal
from salary_tbl
where rownum <= 2
order by sal desc;

Can we write dml inside a function in sql server?

964

---

Why do we use joins?

1050

---

what's the difference between a primary key and a unique key? : Sql dba

1060

---

Define concurrency control. : Transact sql

1195

---

Mention what is the plv (pl/vision) package offers?

1110

---

What is sharding in sql?

994

---

differentiate between float and double. : Sql dba

1065

---

What is sql comments?

1081

---

How do I know if I have sql express or standard?

1043

---

Is like operator in sql case sensitive?

1033

---

How would you reference column values before and after you have inserted and deleted triggers?

1070

---

What is trigger with example?

1106

---

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

2563

---

How do you declare a variable in pl sql?

1033

---

What does the base_object_type column shows in the user.triggers data dictionary view?

1057

---