Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

sql statement

Go to solution
Former Member

‎2007 Oct 29 2:08 AM

0 Likes
366

hi all

i want to store the record into an internal table. What is the syntax?

example

select name from student where class = 'abc'.

i want to store all the name from the class 'abc' into a internal table. How can i do it? thankz.

1 ACCEPTED SOLUTION
Read only

Go to solution
Former Member

‎2007 Oct 29 2:26 AM

0 Likes
341

Hi Gary,

data: begin of itab occurs 0,

name type student-name,

end of itab.

select name

from student

INTO TABLE itab

where class = 'abc'.

Regards,

Atish

1 REPLY 1
Read only

Go to solution
Former Member

‎2007 Oct 29 2:26 AM

0 Likes
342

Hi Gary,

data: begin of itab occurs 0,

name type student-name,

end of itab.

select name

from student

INTO TABLE itab

where class = 'abc'.

Regards,

Atish