Application Development 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: 

reg . sql statements in r/3

former_member1193869
Participant
0 Kudos

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

1 ACCEPTED SOLUTION
6 REPLIES 6

Former Member
0 Kudos

hi

no we cannot fetch

we have 2 use select* only to fetch all feilds

Former Member
0 Kudos

hi,

there is no other way other than select *

Former Member
0 Kudos

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

Former Member
0 Kudos

GET (from a logical database)

IMPORT (from a cluster)

READ (obsolete)

Rob

Former Member
0 Kudos

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.