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.

what is the difference between undefined value and null value? : Sql dba

0 Answers  

---

how can we replace the particular column value of a resulted set of executed query? I mean write down a sql query to chane the particular column's value of a resulted set of executed query

3 Answers  

---

How does sql*loader handles newline characters in a record? : aql loader

0 Answers  

---

Why use stored procedures?

0 Answers  

---

select 1,col1,col2 from table1. output?

5 Answers   Ramco,

---

What is a composite primary key?

0 Answers  

---

I have 2 packages A and B. Now package A references Package B and Package B references Package A. How do you compile such inter-dependent objects in PL/SQL

5 Answers   Doyensys, Infosys, Metric Stream,

---

explain the difference between delete , truncate and drop commands? : Sql dba

0 Answers  

---

What is sql architecture?

0 Answers  

---

What are the triggers associated with image items?

0 Answers  

---

Is primary key clustered index?

0 Answers  

---

What operators deal with null?

0 Answers  

---