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 |
if table named a is there and 4 records are there then how to swap (1 and 3) and (2 and 4) records at a time
Why are indexes and views important to an organization?
how to see the oracle 9i/10g table in pc? or In my pc where the table is saved and how to see?
What is full join in sql?
What is the difference between nvl function, ifnull function, and isnull function?
Can we use pl sql in sql server?
What are the different types of dbmss?
What is the difference between a procedure and a function?
What is a 'instead of trigger'?
what is user defined functions? : Sql dba
how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba
Explain two virtual tables available at the time of database trigger execution.
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)