Home » RDBMS Server » Server Administration » Re: Help please!!!!!
Re: Help please!!!!! [message #370233] Tue, 16 March 1999 12:01
Chris Hunt
Messages: 27
Registered: March 1999
Junior Member
Try this, cols 1-4 are the constants, cols 4-8 come from the other table...

INSERT INTO target_table
       (col1,col2,col3,col4,col5,col6,col7,col8)
SELECT 'const1','const2','const3','const4',
       colA,colB,colC,colD
FROM   source_table


Report message to a moderator

Previous Topic: Re: sql+
Next Topic: Re: Copy long to varchar2?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 18 07:40:03 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.