Also, don't know if it just a typo but the serial column is actually called "serial#"
Ken. > -----Original Message----- > From: Kong, Alan [mailto:[EMAIL PROTECTED] > Sent: 14 March 2003 16:12 > To: Markham, Richard; [EMAIL PROTECTED] > Subject: RE: concatenating & column aliasing > > > 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? >
