Answer / Kiran Verma

Yes, you can join views in SQL. You can treat a view as a table, so you can use it in any SELECT statement that involves joining tables.

How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?

1 Answers  

---

What are the query optimization techniques?

1 Answers  

---

can sql servers linked to other servers like oracle? : Sql dba

1 Answers  

---

What is primary and foreign key?

1 Answers  

---

What information is needed to connect sql*plus an oracle server?

1 Answers  

---

What is self-join and what is the requirement of self-join?

1 Answers  

---

What is a REF CURSOR? Compare strong and week ref cursor types.

6 Answers  

---

Which is better cte or subquery?

1 Answers  

---

What is write ahead logging in sql server?

1 Answers  

---

What is the difference between SQL and PLSQL

7 Answers   IBM,

---

what are all the different types of indexes? : Sql dba

1 Answers  

---

how to remove records from table? no name 1 a 2 b 1 a 2 b 3 c

8 Answers   Oracle,

---