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 |
What is the difference between microsoft access and sql?
what is the difference between union and union all? : Sql dba
wirte a query to filter improper date format follwing table? date 20-apr 22-may-2010 26-jun-2010 feb-2009 i want the output date 22-may-2010 26-jun-2010
In table three columns with 1 milion records(here there is no sequence values) i want add one more column with sequence values from the first how it is posible?
What are the two types of exceptions.
What are sql injection vulnerabilities?
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
how to write utl file pkg in SQL
How did you export data from database to excel file.
write a query filter the null value data following source? name age john 30 smith null null 24 sharp 35 i want output name age john 30 sharp 35
Is primary key always clustered index?
Can you skip header records while loading? : aql loader
Oracle (3253)
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)