Guest_imported
New member
- Jan 1, 1970
- 0
I need to do something like this using pl/sql:
select count(*) into count1,
A.column1, A.column2
BULK collect into column1A, column1B
from A
where rownum<11;
What I am looking for is to get count(*) of all rows of table A and at the same time collect column1 and column2 info for just first 11 or so columns.
Can anybody help?
select count(*) into count1,
A.column1, A.column2
BULK collect into column1A, column1B
from A
where rownum<11;
What I am looking for is to get count(*) of all rows of table A and at the same time collect column1 and column2 info for just first 11 or so columns.
Can anybody help?