What is the difference between SQL table and the PLSQL
table?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
how can we know the count/number of elements of an array? : Sql dba
I have a Employee table with columns ename,eid,salary,deptno. How to retrieve sum of salary for each deptno?
what are the properties and different types of sub-queries? : Sql dba
What is difference between inner join and cross join?
Types of joins?
What is cursor and its types?
Does group by remove duplicates?
What is normalization ?
9 Answers BirlaSoft, CTS, HCL,
Which sql most popular?
What is secondary key?
how many tupples can insert in 1 second in sql
What is online transaction processing (oltp)?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)