Which clause of an UPDATE statement allows you to affect only certain rows of a table? 1. The WHERE clause 2. The SET clause 3. The ROWS AFFECTED clause 4. The ORDER BY clause

6 Answers   HCL,

---

Is sql dba a good career? : SQL DBA

0 Answers  

---

Differentiate between %type and %rowtype attribute in Oracle PL/AQL programming ?

7 Answers   PreVator,

---

In a table i have columns A,B,C and i have a composite index on columns A,B if so will the following query uses index or not? SELECT sal,name FROM <table_name> WHERE A=<value> AND B=<value> AND C=<value>;

2 Answers   Mastek,

---

What is a sql schema used for?

0 Answers  

---

What is pl sql package?

0 Answers  

---

Difference between SUBSTR and INSTR?

3 Answers  

---

Can a select statement fire a trigger?

0 Answers  

---

What is cursor status?

0 Answers  

---

What is embedded sql what are its advantages?

0 Answers  

---

What is pl/sql language case sensitive?

0 Answers  

---

Why do you partition data?

0 Answers  

---