Re: Question on View

> CE.location_city,

.................^ first, get rid of this trailing comma ???

> from COURSES C, COURSES_SESSIONS CE;

On 14 Sep 2000, at 9:05, Bajwa, Sandeep S wrote:

Date sent:      	Thu, 14 Sep 2000 09:05:12 -0800
To:             	Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
From:           	"Bajwa, Sandeep S" <BajwaSS_at_ch.etn.com>
Subject:        	Question on View

> 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)
Received on Thu Sep 14 2000 - 17:26:23 CDT