The error its complaining about is the comma after CE.location_city.
However, I also think the single quotes before ~(substr~ and after
~session_id,1,5)~ may also give you problems
At 09:05 AM 9/14/00 -0800, you wrote:
>I want to create a view where one column is a
>combination of two columns (from two different tables).
>
>i.e. course_id and sessions_id are both numbers, for example
>if course_id=123 and sessions_id=12345 I want test_id (on view)
>to look like 12312345 (and be a number).
>
>create view test_vw
>as select
>to_number
>'(substr(C.course_id,1,3)||''||substr(CE.sessions_id,1,5)','99999999')
>"test_id",
>C.course_id,
>CE.location_city,
>from COURSES C, COURSES_SESSIONS CE;
>
>What am I doing wrong here? (error is
>
>ERROR at line 3:
>ORA-00923: FROM keyword not found where expected)
> *
>
>
>--
>Author: Bajwa, Sandeep S
> INET: BajwaSS_at_ch.etn.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_at_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).
Received on Thu Sep 14 2000 - 17:34:02 CDT
