Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Concatenate two columns and store it in existing column

Vasanth Kumar S M-OracleNov 23 2015 — edited Nov 25 2015

Hi All,

I have created an interactive form based report and need some help on this. In report I want to display a column with label CANDIDATE FULL NAME by concatenating existing columns from same table.

Am mentioning the details and questions below:

Table Name: CANDIDATE_DETAILS

Column 1: CANDIDATE_FNAME (First Name)          Datatype: CHAR(50)

Column 2: CANDIDATE_LNAME (Last Name)          Datatype: CHAR(50)

Column 3: CANDIDATE_FULLNAME (Full Name)     Datatype: CHAR(100)

If in case Column 3 i.e., CANDIDATE_FULLNAME is not created in database, I could have written below query to create one with concatenating Column 1 and Column 2

ALTER TABLE CANDIDATE_DETAILS ADD CANDIDATE_FULLNAME CHAR(100 CHAR)

AS (CANDIDATE_FNAME || ' ' || CANDIDATE_LNAME)

Since, I have already created CANDIDATE_FULLNAME column, I just have to modify it or simply want to store concatenation of column1 and column2. I tried using below query but its not working:

ALTER TABLE CANDIDATE_DETAILS

MODIFY CANDIDATE_FULLNAME AS (CANDIDATE_FNAME || ' ' || CANDIDATE_LNAME)

Also am trying to verify the code under SQL Workshop --> SQL Commands by entering below query and its working fine.

Select CANDIDATE_FNAME || ' ' || CANDIDATE_LNAME

from "CANDIDATE_DETAILS"

but don't know where to enter this code in "Page Designer" so that without creating additional column in Database my requirement can be fulfilled.

Please let me know if You need further details and really appreciate any help provided.

Thanks,

Vasanth

This post has been answered by JJ Mahe -Oracle on Nov 25 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 23 2015
Added on Nov 23 2015
10 comments
11,531 views