Fetching data using jdbc....query doubt

[Rajesh Agarwal]

can someone help me out with the following query.

Insert into employee select 'rajesh',age,sex from xyz.

The thing is I am trying to insert into employee table the values from zyz table. in future incase a new column is added to xyz table, then I have to manually add to this query.

I need a solution where I need to hardcode 'rajesh in first column and select all other column names from xyz and insert into employee.

[Maximilian Xavier Stocker]

Originally posted by Rajesh Agarwal:
can someone help me out with the following query.

Insert into employee select 'rajesh',age,sex from xyz.

The thing is I am trying to insert into employee table the values from zyz table. in future incase a new column is added to xyz table, then I have to manually add to this query.

I need a solution where I need to hardcode 'rajesh in first column and select all other column names from xyz and insert into employee.

Did you try

SELECT 'rajesh',* FROM xyz

[Rajesh Agarwal]

this is syntactically wrong

[David O'Meara]

did you try it?