Answer / barun

A.Yes we can delete data from view.actually we deleting
data from crrospondind tabls or tables data by which view
is created.
b.if view is create by multi table then some condition
oracle follow-
1.if view contain group by,distinct then we cant delete
data.
2.if table contain colume data function or calculation we
can't.
3.if table contain not null value we can't delete.

How does cross join work?

0 Answers  

---

How do I start sql from command line?

0 Answers  

---

how to write date and time literals? : Sql dba

0 Answers  

---

How can we Get the Updated Rows? ie, There is 100s of Rows i updated the Rows who have salary 5000. then i want to select the Updated Rows. How can we achieve it?

4 Answers   Fidelity, KCP,

---

Do view contain data?

6 Answers   Ramco,

---

what is myisam? : Sql dba

0 Answers  

---

What is full join in sql?

0 Answers  

---

How do you update a sql procedure?

0 Answers  

---

List and explain the different types of join clauses supported in ansi-standard sql?

0 Answers  

---

Let us suppose we have a table with structure in order empno empname empdesig empcountry and now i want to re-organize the columns of this table to empno empdesig empname empcountry how can i do this with queries ? assume that table contains the data.

3 Answers  

---

1.when will you use week refcursor and when will you use strong ref cursor ? 2.what is the use of sql trace..how do you use it ? 3.can you please send all the sql plus commands...like set line 6000....

1 Answers   Satyam,

---

What is oracle and pl sql?

0 Answers  

---