What is the difference between SQL table and the PLSQL
table?

Answers were Sorted based on User's Feedback



What is the difference between SQL table and the PLSQL table?..

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.

Is This Answer Correct ?    14 Yes 1 No

What is the difference between SQL table and the PLSQL table?..

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.

Is This Answer Correct ?    1 Yes 5 No

What is the difference between SQL table and the PLSQL table?..

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

Is This Answer Correct ?    3 Yes 18 No

Post New Answer

More SQL PLSQL Interview Questions

What is set serveroutput on?

0 Answers  


what is 'mysqlimport'? : Sql dba

0 Answers  


What is bind reference and how can it be created?

0 Answers  


What sql does db2 use?

0 Answers  


When to use inner join and left join?

0 Answers  






How can multiply values of a column? OR How can multiply value of a row of a column using a single query in SQL?

1 Answers   Pitney Bowes,


What are the possible values for the boolean data field?

0 Answers  


What is a table?

0 Answers  


What pl/sql package consists of?

0 Answers  


I am creating an index on Emp table Empno column,if u using this indexed column in ur SELECT stmt. where clause,then how do u know that yr index will be working or nor? Thanks Advance...

3 Answers  


How do I view a procedure in sql?

0 Answers  


Is sql a case sensitive language?

0 Answers  


Categories