Answer Posted / suresh somayajula

%Type is used to change the size of any datatype but only
for one record.

%Rowtype is used to declare a recoed that represents a
particular row of a table.

Can we write ddl statements in functions?

564

---

Explain the the delete statements in sql?

575

---

What is pl sql commands?

555

---

what is recursive stored procedure? : Sql dba

524

---

Does sqlite need a server?

538

---

---

Can we use insert statement in function?

514

---

Is natural join same as inner join?

505

---

what is csv? : Sql dba

572

---

If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

3546

---

Is sql injection illegal?

595

---

What trigger means?

563

---

What is database white box testing and black box testing?

634

---

List the various privileges that a user can grant to another user?

576

---

Is left join faster than join?

538

---

How can you fetch common records from two tables?

587

---