Reputation: 3581
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'?
<variable>
Upvotes: 0
Views: 57
Reputation: 52336
It should be:
table_name%RowType
Upvotes: 1