Answer Posted / ajeet

%type is use to declare the data type of single column and % row type is use for more then one table ,in simple words with the help of % row type we can easily declare the data type of any table in database.

What are the differences between in and exists clause?

1111

---

what is “go” in t-sql? : Transact sql

1105

---

what is the different between now() and current_date()? : Sql dba

1023

---

How does a covering index work?

962

---

Is it possible to pass parameters to triggers?

1103

---

What is cross join example?

1008

---

What are sql ddl commands?

1093

---

What is the difference between pl and sql?

1094

---

Is it possible to sort a column using a column alias?

1049

---

How do you rank data in sql?

1006

---

How to create an array in pl/sql?

1070

---

How do I use google cloud in sql?

1091

---

What are functions in sql?

958

---

what are the advantages a stored procedure? : Sql dba

977

---

How can get second highest salary in sql?

989

---