Session is a reserved word in oracle, not allowed for aliasing. You can try to use "sessions" instead.
-----Original Message----- From: Markham, Richard [mailto:[EMAIL PROTECTED] Sent: Friday, March 14, 2003 11:05 AM To: '[EMAIL PROTECTED]' Subject: concatenating & column aliasing Normal column aliasing I have no problems. When I try to concatenate two columns and then make an alias (ie. Session) then I will get DBD::Oracle::db prepare failed: ORA-00923: FROM keyword not found where expected. my $sql=q{ select sid||','||serial Session, username from v$session }; any ideas?
