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.

Which are the different case manipulation functions in sql?

1016

---

how to escape special characters in sql statements? : Sql dba

1031

---

What is offset in sql query?

1101

---

Is vs as in pl sql?

982

---

Is a secondary key the same as a foreign key?

1028

---

How to add a column ‘salary’ to a table employee_details?

1006

---

What is pl/sql table? Why it is used?

1030

---

How many joins can you have in sql?

930

---

what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba

1034

---

What is difference between stored procedures and application procedures?

1008

---

does sql support programming? : Sql dba

1034

---

The in operator may be used if you know the exact value you want to return for at least one of the columns.

1122

---

What does count (*) do in sql?

1003

---

Can we use ddl statements in stored procedure?

1138

---

What is oracle pl sql developer?

977

---