[programmer2u]

Does anybody know how to call all the Rows of given table using PL/SQL?

Suppose

 select * from employees where employee_id=123 

Now the employee table consists of fields employee_id,first_name etcccc.
I don't want to the declare the Cursor but I want to use the BULK CONTENT.

Thanks.

[Dogstopper]

Moved to the databases subforum.

[rgfirefly24]

If you want to return all the rows from the table then remove the where clause

select * from <table>