Answer Posted / mohammed ashfaq

SELECT attr1,attr2..attrn
FROM TABLE1,TABLE2..TABLEn;
(IT IS SIMPLE SELECT)
(FOR COMPLEX SELECT)
SELECT attr1,attr2..attrn
FROM TABLE1,TABLE2..TABLEn
WHERE CONDITION;

What are the attributes of the cursor?

1057

---

What is the parameter mode that can be passed to a procedure?

1106

---

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1990

---

What is the use of oracle?

1075

---

Whats the benefit of dbms_stats over analyze?

2064

---

What are the advantages of oracle 12c?

1229

---

What is MTTR advisor in Oracle?

1135

---

How to delete multiple rows from a table in oracle?

1112

---

What happens if the update subquery returns multiple rows?

1164

---

How to use regular expression in pattern match conditions in oracle?

1073

---

What is a table index?

1165

---

Where are the settings stored for each instance in oracle?

1151

---

Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.

1829

---

How to create tables for odbc connection testing?

1202

---

What is set operator oracle?

1034

---