Home » SQL & PL/SQL » SQL & PL/SQL » update telephone type
update telephone type [message #295496] Tue, 22 January 2008 08:24 Go to next message
raj_chmi
Messages: 7
Registered: August 2007
Location: HYDERABAD
Junior Member

hi,

I have uploaded the details of customers in the base table by the customer conversion program (standard program).
but i have uploaded the details of phones(telephone_type='phone')only regarding all customers, while i have not uploaded the details of FAX regarding all same customers.

i couldn't find any api so that i can update the details of fax, can any one help me regarding this. if youget any idea regarding this youcan mail me in 'rajesh.choudhary1@genpact.com'


Regards
Rajesh
mail::: rajesh.choudhary1@genpact.com
Re: update telephone type [message #295498 is a reply to message #295496] Tue, 22 January 2008 08:34 Go to previous messageGo to next message
rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India
Senior Member

Question is not clear .

What do you want to do ? Update or Upload ?

Thumbs Down
Rajuvan
Re: update telephone type [message #295508 is a reply to message #295498] Tue, 22 January 2008 08:43 Go to previous messageGo to next message
raj_chmi
Messages: 7
Registered: August 2007
Location: HYDERABAD
Junior Member

i have already uploaded data for the customers. i just want that if any api or any idea is there so that i can update the information of fax for the same uploaded customers in base tables
Re: update telephone type [message #295510 is a reply to message #295508] Tue, 22 January 2008 08:44 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It depends where you have your original data adn how you load them.

Regards
Michel
Re: update telephone type [message #295513 is a reply to message #295496] Tue, 22 January 2008 08:47 Go to previous message
rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India
Senior Member

Its simple .. right

UPDATE <t_name)
Set   Fax_field = ( select 
                    from  <Base table>
                    Where <condition> )
WHERE <condition>

Thumbs Up
Rajuvan
Previous Topic: Run string as SQL statement
Next Topic: Why is the same query returning the output differently on different databases.
Goto Forum:
  


Current Time: Wed Dec 07 18:30:55 CST 2016

Total time taken to generate the page: 0.12415 seconds