CODEWITHSUNDEEP
oracle-databaseplsqluser-defined-types
HalfWebDev
HalfWebDev

Reputation: 7648

TYPE keyword . Help me in interpreting this code in plsql?

 TYPE datatype_type
IS
  TABLE OF datatype%ROWTYPE
     INDEX BY BINARY_INTEGER;

datatype_bulk datatype_type;

I have googled for TYPE keyword but was't able to get answer except for create object types . Please see if anyone can explain this !

Upvotes: 2

Views: 3892

Answers (1)

xionutz2k
xionutz2k

Reputation: 729

TYPE is used for user-defined types within PLSQL packages. Outside the plsql package the statement is CREATE TYPE.

Here's some more information about user-defined types within packages: link

Upvotes: 0

Related Questions