hi, thanks very much for your reply and advice. sorry for delay in reply.
for which config ? as i have posted various i tried out. please inform so i use that particular one :)
i didn't write any sql statement, what you see here is by built in Query Builder.
in model i used: $this->oracle_db=$this->load->database('default',true); ( for very first post i am using ('oracle',true); )