Answer Posted / vijay_1994

declare
cursor
user defined exception
variable
begin
sql statement
plsql statement (application wise/business logic)
exception
end;

Can we use ddl statements in stored procedure?

1152

---

explain advantages of myisam over innodb? : Sql dba

1069

---

what is unique key constraint? : Sql dba

1035

---

Can we rollback truncate?

998

---

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

1069

---

what are the performance and scalability characteristics of mysql? : Sql dba

996

---

What can I use instead of union in sql?

965

---

What is localdb mssqllocaldb?

1068

---

How do I add a database to sql?

1125

---

Is a foreign key always unique?

942

---

Can we call procedure in select statement?

1054

---

How do I run a pl sql program?

1128

---

what are rollup and cube in t-sql? : Transact sql

1095

---

what are null values? : Sql dba

951

---

Explain the difference between drop and truncate commands in sql?

1051

---