Home » SQL & PL/SQL » SQL & PL/SQL » urgent
urgent [message #40016] Tue, 03 September 2002 20:54 Go to next message
sha
Messages: 84
Registered: July 2002
Member
hi,
what is the major difference between pl/sql table and pl/sql record?
thanx in advance
Re: urgent [message #40019 is a reply to message #40016] Tue, 03 September 2002 21:36 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
Please use more descriptive text than 'urgent' for your subject.

A PL/SQL record is a placeholder for a single element/row. A PL/SQL table is a collection of zero to many "rows" - basically a sparse array. A "row" in a PL/SQL table can consist of a record, or of scalar values.

type my_record is record(a int, b int, c int);
 
type my_table_of_records is table of my_record index by binary_integer;
 
type my_table_of_scalars is table of number index by binary_integer;
Previous Topic: connecting from PLSQL to DB2
Next Topic: Still: creating user and inserting data
Goto Forum:
  


Current Time: Thu Mar 28 04:30:21 CDT 2024