SQL Language (MOSC)

MOSC Banner

output of a column in one table to be used a input (column) of another table

edited Jun 13, 2011 6:41AM in SQL Language (MOSC) 4 commentsAnswered
  I have a table called helitab  in which i select a column  type helitype . output of that column is H1 

select heli_type from heli_tab  where heli_no = 'DS1500000000' 

heli_type      version

------------       -----------

H1               SAY          -------------- out put data value is column name of the query below

I want to use that ouput as a column name   in another table called heli_tab_det  . how to do that using SQL

select   H1,qph_say from heli_tab_det

H1             qph_say

----            ------------

1                  1

2                  5

3                 10

Output of a row in one table to be used as a input(column) in another table

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center