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 are the advantages of the packages
Define commit, rollback and savepoint?
how can we take a backup of a mysql table and how can we restore it. ? : Sql dba
How many clustered indexes can be created on a table?
What does stand for in sql?
How would you pass hints to the sql processor?
how would you get the current date in mysql? : Sql dba
Whis is not false in primary key?
Why use triggers in sql?
How to use sql*plus built-in timers?
How to add Foreign key in a table after the creation of the table?
i have a table with column sno with 30 records. i want to update this column by item by item in asp.net. i wantto enter new values into that from 1 to 30 how is it possible with backend c#
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)