Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to do count(*) and bulk collect in one sql query

Status
Not open for further replies.

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?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top