2 Replies - 754 Views - Last Post: 24 October 2012 - 12:26 PM Rate Topic: -----

#1 programmer2u  Icon User is offline

  • New D.I.C Head

Reputation: -1
  • View blog
  • Posts: 17
  • Joined: 01-May 09

About PL/SQL Programming Help

Posted 24 October 2012 - 10:41 AM

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.
Is This A Good Question/Topic? 0
  • +

Replies To: About PL/SQL Programming Help

#2 Dogstopper  Icon User is offline

  • The Ninjaducky
  • member icon



Reputation: 2872
  • View blog
  • Posts: 11,031
  • Joined: 15-July 08

Re: About PL/SQL Programming Help

Posted 24 October 2012 - 10:43 AM

Moved to the databases subforum.
Was This Post Helpful? 0
  • +
  • -

#3 rgfirefly24  Icon User is offline

  • D.I.C Lover
  • member icon


Reputation: 267
  • View blog
  • Posts: 1,476
  • Joined: 07-April 08

Re: About PL/SQL Programming Help

Posted 24 October 2012 - 12:26 PM

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

select * from <table>


Was This Post Helpful? 0
  • +
  • -

Page 1 of 1