Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: insert subquery problems

Re: insert subquery problems

From: Thomas Bierhance <Bierhance_at_orbital-computer.de>
Date: 17 May 1999 20:20:04 GMT
Message-ID: <37407A7F.7D79C7F6@orbital-computer.de> 





> insert into table_a(column_a,column_b,column_c)


>         select table_b.column_a, 'column_b.string', table_c.column_c


>         from table_b, table_c


>         where table_b_join = table_c_join


>





looks just fine to me. Basically there is nothing wrong with static strings
in a select statement. What is the exact code and error message you get?



Thomas Bierhance



Received on Mon May 17 1999 - 15:20:04 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US