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;

How to create a new table in your schema?

1081

---

What are the different editions of oracle?

1105

---

Explain the use of owner option in exp command.

1041

---

Can a parameter be passed to a cursor?

1123

---

What are the set operators union, union all, minus & intersect meant to do?

987

---

What are the differences between char and nchar in oracle?

1094

---

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

2355

---

What language does oracle use?

1098

---

How to delete an existing row from a table in oracle?

1070

---

What are the attributes of the cursor?

1002

---

Where do we use decode and case statements?

1011

---

Are truncate and delete commands same? If so why?

1151

---

What are the ansi data types supported in oracle?

947

---

Design database draw er diagram for a certain scenario ?

4579

---

How to pass parameters to procedures in oracle?

1042

---