Answer Posted / sudipta

It is a database object that is based on a select statement
against one or more tables or other view in the database.A
regular view dose not store any data in the database only
the definition is stored.views are also known as stored
queries.

How to create a new user account in oracle?

1014

---

What is tns service name?

1122

---

Explain compound trigger in oracle?

1031

---

What is a data lock in oracle?

1109

---

How to grant create session privilege to a user in oracle?

997

---

List the types of joins used in writing subqueries?

991

---

How to resolve name conflicts between variables and columns?

1026

---

What is procedure overloading in oracle?

1056

---

What is clustered table in Oracle?

1190

---

Explain oracle insert into command?

1110

---

What is blob datatype?

1123

---

In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

2339

---

How to resolve the ORA-39133 error in Oracle?

1107

---

What is the purpose of tables, private synonyms and public synonyms in Oracle?

1043

---

What are the execution control statements?

1063

---