[TechDee]

I'm using a query to display the movie number, and movie description for all movies where the movie description is combination of the move name, movie year, and movie genre with the movie year enclosed in parentheses.

I got this far.... Question how to implement parenthesis for each movie year

SQL> SELECT MOVIE_NUM,MOVIE_NAME||' '||MOVIE_YEAR||' '||MOVIE_GENRE AS MOVIE_DESCRIPTION
FROM MOVIE;

MOVIE_NUM      MOVIE_DESCRIPTION
--------------------- ------------------------------------------------------
1234          YOUR THE MAN (2009) FAMILY
2333          THANK YOU (2011)  ACTION

[Hary]

I don't understand the result you want to create. Could you give an example of the result table you'd like to produce?

[Ionut]

The output you post it is what you want to achive? If so, change the query as

SELECT MOVIE_NUM,MOVIE_NAME||' ('||MOVIE_YEAR||') '||MOVIE_GENRE AS MOVIE_DESCRIPTION
FROM MOVIE;