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 convert times to characters in oracle?

994

---

Can select statements be used on views in oracle?

1000

---

How to execute a stored procedure in oracle?

1044

---

What is a initialization parameter file in oracle?

997

---

What is data file?

1058

---

Explain the use of file option in exp command.

1099

---

How to define an oracle cursor variable?

987

---

Explain what are the uses of rollback segment?

972

---

Can we insert data in view oracle?

977

---

What will be the syntax to find current date and time in format "yyyy-mm-dd"?

972

---

How to assign values to variables?

1060

---

How do we display rows from the table without duplicates?

939

---

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2263

---

What are the four Oracle system processes that must always be up and running for the database to be useable?

967

---

What privilege is needed for a user to connect to oracle server?

959

---