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
Showing results for 
Search instead for 
Did you mean: 
Read only

reg . sql statements in r/3

Former Member
0 Likes
1,085

what is the query used to fetch all fields from table with out using select* ?

1 ACCEPTED SOLUTION
Read only

former_member156446
Active Contributor
6 REPLIES 6
Read only

Former Member
0 Likes
1,059

hi

no we cannot fetch

we have 2 use select* only to fetch all feilds

Read only

Former Member
0 Likes
1,059

hi,

there is no other way other than select *

Read only

Former Member
0 Likes
1,059

Select key word is mandatory to extract record from a table through this key word only oracle understand exectaly what you mant to do

Read only

former_member156446
Active Contributor
Read only

Former Member
0 Likes
1,059

GET (from a logical database)

IMPORT (from a cluster)

READ (obsolete)

Rob

Read only

Former Member
0 Likes
1,059

Hi Naveen,

Apart from select*, there is another way that is, you have to specify all the fields one by one in select statement to fetch all fields from table.