What are different data structures supported by PL/SQL.??

Questions by Preeti Kulkarni

Showing Answers 1 - 12 of 12 Answers

sandeep

  • Dec 8th, 2014
 

There are two data types
1.scalar
2.composite

scalar:=number,varchar,car ,varchar2,date
composite := collections , records;
collections:=varray, nested table, plsql tables;
records := table based records , cursor based records, user defined records

  Was this answer useful?  Yes

Mahendra

  • Dec 8th, 2014
 

We have Records which can be used as one of the data structures in PLSQL

  Was this answer useful?  Yes

Hema nagaraju

  • Dec 19th, 2014
 

scallar,composite datatypes.
scllar datatypes are varchar2,number
composite datatypes are records,tables,collections which can store multiple values at a time

  Was this answer useful?  Yes

Yes PL/SQL have different data types compared to C and C++. These two datatypes in SQL i.e scalar and composite are very mush useful in SQL.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions