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.

consider a table which contain 4 columns,ename,eno,sal and deptno, from this table i want to know ename who having maximum salary in deptno 10 and 20.

24 Answers   Mind Tree,

---

can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

0 Answers  

---

What is primary key and unique key?

0 Answers  

---

what is a primary key? : Sql dba

0 Answers  

---

What is a trigger word?

0 Answers  

---

Suppose I have to create a view on a table, that is not yet been created by DBA. I khow the table structure. Is it possible to create the view before DBA creates this table? If yes then how? Is it possible to create synonym in this way?

4 Answers   IBM, Metric Stream,

---

7. Where would you look for errors from the database design?

1 Answers   Fintellix,

---

What do you mean by dbms? What are its different types?

0 Answers  

---

if we give update table_name set column_name= default. what will happen? its given in pl sql block.what will hapen?

5 Answers   iFlex,

---

What SQL keyword must immediately follow the UNION ALL statement? 1. SELECT 2. INTO 3. ORDER 4. WHERE 5. JOIN

4 Answers  

---

How do I restart sql?

0 Answers  

---

Explain what is a view?

0 Answers  

---