From sinardyxing@bcsis.com Mon, 17 Sep 2001 00:41:37 -0700 From: "Sinardy" Date: Mon, 17 Sep 2001 00:41:37 -0700 Subject: Select question Message-ID: MIME-Version: 1.0 Content-Type: text/plain Hi all, Why I can't do this ? Select 'Testing ' || distinct(to_char(mydate, 'MON')) from mytable; * ERROR at line 1 ora-00936: missing expression it is work if I do Select distinct(to_char(mydate, 'mon')) || ' testing' from mytable; WHY ?? Best Regards Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy INET: sinardyxing@bcsis.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).