Answer Posted / debasis dutta

%type is associates a variable with column data of a table..
ex..
empno emp_mast.eno%type;
%rowtype is associates a variable with whole table data of
a database..
ex
tot emp_mast%rowtype;

What is basic structure of pl sql?

984

---

What is example of database?

984

---

how to enter binary numbers in sql statements? : Sql dba

921

---

What is the difference between clustered and non-clustered indexes?

1025

---

what is a view? : Sql dba

1023

---

What are different categories of sql commands?

1067

---

How do I view tables in sql developer?

881

---

How many sql commands are there?

1069

---

What are the different types of constraints?

1070

---

what is sql server agent? : Sql dba

1027

---

how many ways we can we find the current date using mysql? : Sql dba

1034

---

What is the difference between a database and a relational database?

1034

---

What is offset in sql query?

1068

---

How do I make sql search faster?

936

---

Why is pl sql needed?

872

---