Ashish Anand
Ashish Anand

Reputation: 3581

Storing multiple values from a table

I want to use

select * into <variable> from <table_name>

inside a stored procedure (pl/sql).

What should be type of <variable> to keep the multiple columns returned from 'table_name'?

Upvotes: 0

Views: 57

Answers (1)

David Aldridge
David Aldridge

Reputation: 52336

It should be:

table_name%RowType

Upvotes: 1

Related Questions