|
-
March 25th, 2009, 09:10 PM
#2
Re: SQL to copy from one table to another
Be careful with the ID field
If it is an autoallocated field (in both tables) then your statement wont work because the receiving table will want to allocate the ID automatically
But if in the receiving table the ID field is NOT autoallocated, and is not a unique index field, then your statement should work
...... FROM TABLE1 WHERE name = :name
may need to be
...... FROM TABLE1 WHERE name = '" & name & "'"
(But then, I know nothing about Oracle)
Last edited by George1111; March 25th, 2009 at 09:13 PM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote
