Home » SQL & PL/SQL » SQL & PL/SQL » How to insert one column from one table to another?
How to insert one column from one table to another? [message #378746] Thu, 01 January 2009 02:55 Go to next message
roome
Messages: 8
Registered: November 2008
Location: Muzaffarabad Kashmir
Junior Member

I WANT TO COPY ONE COLUMN 'FORM_NO' FROM TABLE MASTER INTO TABLE CASES WITH A CONDITION THAT WHERE THIER 'CASE_ NUMBER' MATCH WITH EACH OTHER. PLEASE HELP IN WRITING THE QUERY

[MERGED by LF]

[Updated on: Thu, 01 January 2009 04:31] by Moderator

Report message to a moderator

Re: how to insert one column from one table to another in oracle [message #378747 is a reply to message #378746] Thu, 01 January 2009 03:11 Go to previous messageGo to next message
flyboy
Messages: 1832
Registered: November 2006
Senior Member
Firstly, set the CAPS LOCK OFF.

What shall be done when given CASE_NUMBER exists only in CASES table?
What shall be done when given CASE_NUMBER exists only in MASTER table?
Depending on answers to the last two questions, use UPDATE or MERGE statement eventually combined with DELETE.
Re: how to insert one column from one table to another in oracle [message #378748 is a reply to message #378746] Thu, 01 January 2009 03:11 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please read OraFAQ Forum Guide and:
- Don't post in UPPER case
- Post a Test case: create table and insert statements along with the result you want with these data
- Carefully read "How to format your post?" section
- Use SQL*Plus and copy and paste what you tried so far

Regards
Michel
Re: want to copy one column from a table to another table in all matched rows [message #378756 is a reply to message #378746] Thu, 01 January 2009 04:30 Go to previous message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Mr. White, it is you who makes the first move.

In other words: write the query by yourself, giving the best you can. If it doesn't work, provide the code you have written and someone will certainly help.

Sorry, didn't realize that it was a duplicate; now it's been merged.

[Updated on: Thu, 01 January 2009 04:32]

Report message to a moderator

Previous Topic: MAX Aggregate function
Next Topic: how null values are stored
Goto Forum:
  


Current Time: Thu Dec 08 00:11:34 CST 2016

Total time taken to generate the page: 0.07201 seconds