2008 Jan 31 9:54 AM
what is the query used to fetch all fields from table with out using select* ?
2008 Jan 31 2:07 PM
Hi Naveen
check this link
http://help.sap.com/saphelp_nw04s/helpdata/en/fc/eb3b23358411d1829f0000e829fbfe/content.htm
2008 Jan 31 12:04 PM
hi
no we cannot fetch
we have 2 use select* only to fetch all feilds
2008 Jan 31 12:12 PM
2008 Jan 31 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
2008 Jan 31 2:07 PM
Hi Naveen
check this link
http://help.sap.com/saphelp_nw04s/helpdata/en/fc/eb3b23358411d1829f0000e829fbfe/content.htm
2008 Jan 31 2:28 PM
GET (from a logical database)
IMPORT (from a cluster)
READ (obsolete)
Rob
2008 Feb 01 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.