Answer / Shobhit Kumar Gupta

Yes, you can modify a view in SQL by using the CREATE OR REPLACE VIEW statement. This statement allows you to change the definition of an existing view. However, keep in mind that you cannot directly modify data through a view; instead, you must update the underlying table.

What is mutating trigger?

1 Answers  

---

Why do we use %rowtype & %type in plsql?

1 Answers  

---

What is normalization in a database?

1 Answers  

---

What is the use of double ampersand (&&) in sql queries? Give an example

1 Answers  

---

How do I view stored procedures?

1 Answers  

---

What is the relation b/w view and trigger

3 Answers   Accenture, TCS,

---

How do you write a complex sql query?

1 Answers  

---

What is the plv (pl/vision) package offers?

1 Answers  

---

select * from emp where sal in(select max(sal) from emp) here there is any limit for in operator how many values accpect ?

2 Answers  

---

In a table i have columns A,B,C and i have a composite index on columns A,B if so will the following query uses index or not? SELECT sal,name FROM <table_name> WHERE A=<value> AND B=<value> AND C=<value>;

2 Answers   Mastek,

---

What are the events on which a database trigger can be based?

1 Answers  

---

What are the triggers associated with image items?

1 Answers  

---