lets i have a table "bapi" having 6 field like this f1 f2 f3 f4 f5 f6 ... ... .. ... ... ... p r o m o d i want to retrive all the data by using select statement and my output will be look like this: xyz ... p r o m o d