Answer / dhanashree

Running block of code or the querry having opposite
condition placed in the trigger.When the condition gets
false then the trigger gets called avoiding particular
action such as Update,Delete,Insert depending on the
trigger type.The trigger output is in form of Error massage
used in trigger itself.

Can we insert data into materialized view?

0 Answers  

---

How to add, remove, modify users using sql?

0 Answers  

---

What is lexical units in pl sql?

0 Answers  

---

What are the limitations of sql express?

0 Answers  

---

how to find the First and Last Observation from the table: Ex: OBS Name Sal Ans like: OBS Name Sal 105 E 5000--> 105 E 5000 102 B 2000 104 D 4000 103 C 3000 101 A 1000--> 104 D 4000

4 Answers  

---

What is the syntax to add a record to a table?

0 Answers  

---

What is data profiling in sql?

0 Answers  

---

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

4 Answers  

---

Interchange the value of a column Gender in a table where values are Male and Female. So, where the value is Male, it should changed to Female and Female to Male.

4 Answers   Cap Gemini, IBM,

---

what is the difference between stored procedure and packaged procedure

1 Answers   Google, Infosys,

---

Which are the different case manipulation functions in sql?

0 Answers  

---

what is transaction? : Sql dba

0 Answers  

---