Insert query for Oracle

Question

0.00/5 (No votes)

See more:

Sir,
I have two Table Name Table1 and Table2 as below:-
Table1
Mobile Remarks

Table2
Mobile Name Fname Address

Now I want that table2.mobile data should copy into the table1.mobile data and rest of the columns of Table2 data should be copy in the table1.remarks column.
Please send me query

Sir,
As you send the query am using in MS-Access 2007 but its giving error message that Syntax error in query expression "select mobile".

Posted 20-Jan-13 22:45pm

Rajesh Kinger

Updated 21-Jan-13 23:54pm

v3

Add a Solution

Comments

OriginalGriff 21-Jan-13 4:46am

Never post your email address in any forum, unless you really like spam! If anyone replies to you, you will receive an email to let you know

Richard MacCutchan 21-Jan-13 4:46am

This is a repost; see below in QΑ list.

OriginalGriff 21-Jan-13 4:48am

I was just telling him that when you were telling me! :laugh:

OriginalGriff 21-Jan-13 5:00am

Richard, did you edit that?
I got strange characters in the email, that I don't normally:
"This is a repost; see below in QΑ λιστ."
If you didn't, then I'll mention it to Chris in Sugs'n'Bugs.

Richard MacCutchan 21-Jan-13 5:02am

Sorry I hit my "switch language" keys by mistake so it came out as Γρεεκ characters.

OriginalGriff 21-Jan-13 5:05am

I am not going to ask why you have Cyrillic as one of your options! :laugh:

Richard MacCutchan 21-Jan-13 5:12am

I don't, but I do have Greek. I started learning it a few years ago but didn't keep up with the lessons. It remains on my todo list.

OriginalGriff 21-Jan-13 4:47am

And don't repost!
If you have extra data to add to your question, use the "Improve question" widget to edit your question and provide better information.
Posting the same question twice is rude, and can slow a response dramatically.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Anushkar · Answer 1 · 2013-01-20T22:58:00

Solution 1

Try out with below mentioned query.

SQL

INSERT INTO TABLE1 (Mobile, Remarks) VALUES (SELECT MOBILE, NAME||' '||FNAME||' '||ADDRESS FROM TABLE 2)

Hope this will help you..

Posted 20-Jan-13 22:58pm

Anushkar

Comments

Rajesh Kinger 22-Jan-13 5:22am

Sir,
It's still not working its giving error message that "Sytax error in query expression 'select mobile'.