Answer Posted / vikneswaran

%type is used to declare variable for one column in the table
%type is used to declare variable for entire table

What is the best sql course?

928

---

What is the file extension for sql database?

935

---

what is the difference between nested subquery and correlated subquery?

979

---

What are the types of optimization?

886

---

Explain what is an index?

994

---

What is embedded sql with example?

984

---

Explain ddl statements in pl/sql?

957

---

What does an inner join do?

1089

---

What is difference between stored function and application function?

1096

---

What problem one might face while writing log information to a data-base table in pl/sql?

1065

---

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

1537

---

Differentiate pl/sql and sql?

1010

---

What is varchar used for?

1019

---

Is sql open source?

914

---

Explain the structure of pl/sql in brief.

1040

---