Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Doppleganger column names
I have 3 views created In SQL. They all have the same Column names eg.
View called A_VIEW
ALPHA BETA GAMMA DELTA 24 0 0 Alex 32 0 0 Jason View called B_VIEW ALPHA BETA GAMMA DELTA 0 2 0 Phil View called C_VIEW ALPHA BETA GAMMA DELTA 0 0 1 Bishop 0 0 19 Mike
I would like to combine them into 1 VIEW looking like
View Called ALL_VIEWS
ALPHA BETA GAMMA DELTA 24 0 0 Alex 32 0 0 Jason 0 2 0 Phil 0 0 1 Bishop 0 0 19 Mike
IF THIS IS NOT POSSIBLE IS THERE AN IF COMMAND, AS THE 3 TABLES ORIGINALLY CAME FROM 1 TABLE LIKE Called for example NAMES
DELTA TYPE VALUE Alex A 24 Jason A 32 Phil B 2 Bishop C 1 Mike C 19
SO IS THERE A COMMAND THAT WORKS LIKE CREATE VIEW ALL_VIEWS
AS SELECT (IF TYPE='A' THEN to_char(VALUE) ELSE to_char(0)) ALPHA, AS SELECT (IF TYPE='B' THEN to_char(VALUE) ELSE to_char(0)) BETA, AS SELECT (IF TYPE='C' THEN to_char(VALUE) ELSE to_char(0)) GAMMA,DELTA,
SMILE IF YOU BRAIN IS ABOUT TO EXPLODE DUE TO A LARGE NUMBER OF ALPHAs AND BETAs FLYING AROUND AT GREAT SPEED INSIDE YOUR CRANIUM SMILEY