OraFAQ Forum: SQL & PL/SQL » insert query getting values using select getting next id logic

Home » SQL & PL/SQL » SQL & PL/SQL » insert query getting values using select getting next id logic

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

insert query getting values using select getting next id logic [message #604428]

Mon, 30 December 2013 09:52

cplusplus1
Messages: 58
Registered: October 2012
Location: usa

Member

I want to create rows in ft_metric table using the select, the first column is primary key. How can i use select ft_metric_seq1.nextval from dual which gets the next available id that can be used to create a new row.

insert into ft_metric(pillar_metric_id, metric_day_id,metric_amount)
select (select ft_metric_seq1.nextval from dual), metric_day_id, metric_amount from ft_metric where metric_id=3423;

Thanks a lot for the helpful info.

Report message to a moderator

Re: insert query getting values using select getting next id logic [message #604429 is a reply to message #604428]

Mon, 30 December 2013 09:54

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

INSERT INTO ft_metric 
            (pillar_metric_id, 
             metric_day_id, 
             metric_amount) 
SELECT ft_metric_seq1.NEXTVAL, 
       metric_day_id, 
       metric_amount 
FROM   ft_metric 
WHERE  metric_id = 3423;

Report message to a moderator

Previous Topic:	sql query problem
Next Topic:	sql query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 02:55:59 CDT 2024