01-31-2008 9:54 AM
what is the query used to fetch all fields from table with out using select* ?
01-31-2008 2:07 PM
Hi Naveen
check this link
http://help.sap.com/saphelp_nw04s/helpdata/en/fc/eb3b23358411d1829f0000e829fbfe/content.htm
01-31-2008 12:04 PM
hi
no we cannot fetch
we have 2 use select* only to fetch all feilds
01-31-2008 12:12 PM
01-31-2008 12:27 PM
Select key word is mandatory to extract record from a table through this key word only oracle understand exectaly what you mant to do
01-31-2008 2:07 PM
Hi Naveen
check this link
http://help.sap.com/saphelp_nw04s/helpdata/en/fc/eb3b23358411d1829f0000e829fbfe/content.htm
01-31-2008 2:28 PM
GET (from a logical database)
IMPORT (from a cluster)
READ (obsolete)
Rob
02-01-2008 3:35 AM
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.