Answer Posted / vamsi krishna

we can't say which is executed first among the trigger and
constraraint .
the sequence of execution is
(i) before statement level
(ii) before row level
(iii) after row level
(iv) constraint
(v) after statement level

What has stored procedures in sql and how we can use it?

560

---

what is single byte over head in oracle..?

1860

---

Can we perform dml on view?

548

---

What is record variable?

542

---

What is a left join?

497

---

---

What are the types of join and explain each?

571

---

What is the difference between delete and truncate statement in sql?

484

---

Do foreign keys improve performance?

537

---

What is varchar sql?

606

---

How to run pl/sql statements in sql*plus?

582

---

I need a function for a train ticket reservation please answer it thanks in advance

557

---

What is difference between rank () row_number () and dense_rank () in sql?

566

---

what is data manipulation language? : Sql dba

523

---

What is assignment operator in pl sql?

557

---

how tsql statements can be written and submitted to the database engine? : Transact sql

522

---