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

How to export the table data (this table having 18 million records) to .csv file. Please tell me is there any faster way to export the data.

8 Answers  


How you can copy a file to file content and file to pl/sql table in advance pl/sql?

0 Answers  


how to install mysql? : Sql dba

0 Answers  


Types of optimization?

6 Answers   Microsoft,


What is the difference between local variables and global variables?

0 Answers  






what is the difference between delete and truncate commands? : Sql dba

0 Answers  


Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?

0 Answers  


What can I use instead of union in sql?

0 Answers  


how to drop an existing table in mysql? : Sql dba

0 Answers  


what is isam? : Sql dba

0 Answers  


What are the different operators available in sql?

0 Answers  


What is partition by in sql?

0 Answers  


Categories