How to update a column with different values in Oracle 11g?

Question

I have a table with name "User_Report" with these columns.

ID       Name    City    zip    Report_File
101      AAA     PPP     123     -----
102      BBB     QQQ     345     -----
103      CCC     RRR     567     -----
104      FFF     SSS     789     -----

I added Report_File new column and i need to update this column with Name+".rpt". How i can update Report_File column with corressponding Name column data in a single update statement?

Please send me one example?

Thanks in advance.

TechDo · Accepted Answer · 2014-10-14 05:44:36Z

1

Please try below query. In oracle double pipes (||) are used for concatenation of strings:

Update User_Report
SET Report_File=Name||'.rpt';

OR keyword CONCAT can be used. Refer LINK

Update User_Report
SET Report_File=CONCACT(Name, '.rpt')

edited Oct 14, 2014 at 5:44

answered Oct 14, 2014 at 5:39

TechDo

18.7k3 gold badges55 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

mrjoltcola · Accepted Answer · 2014-10-14 05:52:08Z

0

Your report_file column appears to be a calculated value, if it will never deviate, then you might consider a virtual column.

alter table user_report add (report_file varchar(40) as (name||'.rpt'));

This way you never have to worry about keeping it in synch, it will always be in synch if name changes or new values are inserted.

answered Oct 14, 2014 at 5:52

mrjoltcola

20.9k1 gold badge62 silver badges81 bronze badges

Collectives™ on Stack Overflow

How to update a column with different values in Oracle 11g?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related