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;

Can multiple columns be used in group by in oracle?

937

---

Explain integrity constraints?

1067

---

How to synchronize 2 schema's objects?

2125

---

What is sequence?

1021

---

What are the varoius components of physical database structure of oracle database?

954

---

Can we use bind variables in oracle stored procedure?

907

---

How index is implemented in oracle database?

961

---

In which language oracle has been developed?

1024

---

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

991

---

Where are the settings stored for each instance in oracle?

1074

---

What is difference between sid and service name in oracle?

914

---

What is meant by raw datatype?

1016

---

How to insert multiple rows with one insert statement in oracle?

1031

---

Compare and contrast between sql and sql server and explain its various functions?

927

---

How to start your 10g xe server from command line?

1013

---