Or you can double-quote the alias: select sid||','||serial as "SESSION",
--- "Kong, Alan" <[EMAIL PROTECTED]> wrote: > 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? __________________________________________________ Do you Yahoo!? Yahoo! Web Hosting - establish your business online http://webhosting.yahoo.com
