Hello All I am new to Oracle and SQl I have been trying to create the following view for a script and keep getting amissing expression error.
Here is my script and the error any suggestions?
Thanks to all in advance


CREATE VIEW BRANCH_REPORT(BRANCH_NUM,TITLE,PUBL_NAME,PRICE,UOH
) AS
SELECT N.BRANCH_NUM, P.PUBLisher_CODE||'-'||RTRIM(P.PUBLisher_NAME),||' '||RTRIM(B.Book_PRICE),
||RTRIM(I.Units_on_Hand),
FROM BRANCH N, PUBLISHER P, INVENT I, BOOK B
WHERE N.BRANCH_NUM = I.BRANCH_NUM
and P.publisher_code = B.publisher_code
and I.Book_code = b.book_code;
T N.BRANCH_NUM, P.PUBLisher_CODE||'-'||RTRIM(P.PUBLisher_NAME),||' '||RTRIM(B.Book_PRICE),||' '
*
at line 2:
0936: missing expression

Just have a look at the SELECT. "||" is used for concatenation. You cannot start an expression with "||". Also, you put a comma just before the FROM keyword !

Shouldn't your select be :