Answer / saisravanthi

sql tables are used to store data permanently.pl/sql tables
are used to hold data just like other variables during the
execution of programs.

Answer / shivakanth reddy

In case sql table we use PRIMARY KEY to avoid duplicates and
null values.
But in case of PL/SQL PRIMARY KEY is used as an index to
ann array for accessing rows.

Answer / ganesh

sql table:

it has n number of field(column) with sql datatype,
it is scheema object

plsql table:

it is one of type of collection in plsql, it can hold two
column only(it can one column from table),in which one
column hold scalar variable and another hold binar integer

What is cascade in sql?

0 Answers  

---

What is rowtype?

0 Answers  

---

Which sql statement is used to return only different values?

0 Answers  

---

Give an example of any procedure.

5 Answers   Accenture, iFlex, Wipro,

---

What are the PL/SQL Statements used in cursor processing ?

4 Answers  

---

---

write a query to delete similar records in same table

13 Answers   TCS,

---

What are the types pl/sql code blocks?

0 Answers  

---

How much does sql certification cost?

0 Answers  

---

Can a foreign key have a different name?

0 Answers  

---

What is clustered and non-clustered indexes?

4 Answers   Microsoft,

---

wirte a query to remove null? following table are col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output like col1 col2 col3 dinesh suresh prkaesh

6 Answers   TCS,

---

Is pl sql different from sql?

0 Answers  

---