What is the difference between SQL table and the PLSQL
table?
Answer Posted / 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 |
Post New Answer View All Answers
What is the difference between jpql and sql?
Which is faster count (*) or count 1?
What is the difference between partitioning and sharding?
Is sqlite thread safe?
Does sql full backup truncate logs?
What are sql procedures?
Is sql sequential or random?
Explain the advantages and disadvantages of stored procedure?
what is a constraint? Tell me about its various levels. : Sql dba
what is error ora-03113: end-of-file on communication channel?
What is the source code of a program?
Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com
What is the difference between delete and truncate statement in sql?
What are all the ddl commands?
How to get help at the sql prompt?