Answer Posted / rao

If a view is created by complex join/set operators/distinct/
group by is called complex view.insert data into those table
then insetead of trigger not ordernary triggers

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3619

---

What is rownum and rowid?

1074

---

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

1007

---

Can we use insert statement in function?

1045

---

How can we implement rollback or commit statement in a trigger?

1083

---

What is scalar function in sql?

1095

---

what is a trigger in mysql? : Sql dba

1211

---

Explain the advantages and disadvantages of stored procedure?

1198

---

What is a stored procedure in sql with example?

1199

---

How long will it take to learn pl sql?

979

---

Can sql function call stored procedure?

1070

---

Which constraints we can use while creating database in sql?

1118

---

Does sql full backup truncate logs?

1077

---

What are the disadvantages of file system?

1354

---

What are different types of sql?

1260

---