OraFAQ Forum: SQL & PL/SQL » URGENT

Home » SQL & PL/SQL » SQL & PL/SQL » URGENT - select problem

Mon, 10 June 2002 04:34

Kjell
Messages: 7
Registered: February 2002

Junior Member

How can I select a value from a table into another table in one sql-statement

Mon, 10 June 2002 04:55

Jon
Messages: 483
Registered: May 2001

Senior Member

INSERT INTO table1
(SELECT col1
FROM table2
WHERE pk = some_value);

Mon, 10 June 2002 11:36

sridhar
Messages: 119
Registered: December 2001

Senior Member

INSERT INTO table_two(col2)
SELECT col1 FROM table_one
WHERE <<condition here>>;
Thx,
SriDHAR

Previous Topic:	PL/SQL or Perl?
Next Topic:	Re: converting 2.635E+36 to number

Goto Forum:

]

Current Time: Fri Apr 26 07:24:42 CDT 2024