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


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


Current Time: Sun Oct 25 09:13:30 CDT 2020