Home » SQL & PL/SQL » SQL & PL/SQL » concat two columns
concat two columns [message #361465] Wed, 26 November 2008 09:27 Go to next message
shrad2001
Messages: 20
Registered: September 2008
Location: faridabad
Junior Member
Hii

I want to insert values in name column of table by taking values from firstname and last name column both

want to update whole table by one command

i use this
update tablename
set name=(select fname||lname from tablename where id=1)
where id=1;

it is working but i want single command for whole table not for one row

thanks
smily

Re: concat two columns [message #361466 is a reply to message #361465] Wed, 26 November 2008 09:28 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
UPDATE <table>
SET name = first_name||last_name
Re: concat two columns [message #361690 is a reply to message #361466] Thu, 27 November 2008 08:52 Go to previous message
shrad2001
Messages: 20
Registered: September 2008
Location: faridabad
Junior Member

Thanks a lot
Previous Topic: How to store the zip file in oracle table ?
Next Topic: How to create Sequence generating alpha numeric values
Goto Forum:
  


Current Time: Sat Dec 10 20:25:22 CST 2016

Total time taken to generate the page: 0.11035 seconds