I’ve often thought about this Oracle Coherence . Nice to have it laid out so clearly. Great eye opener.
Our project DBA Team is planning to migrate Oracle DB from version 11.2.0.4 to 12.2.0.1. Could you please let me know what the Ares which gets impacted from DB Development Team prospective?
Our DBA Team will take care of up gradation. But I want to know any deprecated concepts/impacted Ares in Higher version?
Current Version: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
Thanks a lot. This was a perfect step-by-step guide. Don’t think it could have been done better.
Brilliant article, glad I slogged through the Java interview questions. it seems that a whole lot of the details really come back to from my past project.
i creat a view as(see below) the problem is that i get dublicat rows and with UNION they are deselected, i dont want to use UNION ALL
so my question is, how can i rewrite the two "select .. " to a Group by expression, Group by: YEAR, Month and get the same result as UNION ALL
CREAT VIEW v_test_rerytering (.......) AS select F.ALDER age, cast(P.AR as VARCHAR2(4)) year, ccast((P.MANAD)as VARCHAR2(2)) month, cast(K.KON_KOD as VARCHAR2(50)) SEX, cast('Ext' as VARCHAR2(50)) R_KOD, F.NR_REK REK from test.Table_anstallda F join test.PERIOD P on P.PERIOD = F.PERIOD
union
select F.ALDER age, cast(P.AR as VARCHAR2(4)) year, ccast((P.MANAD)as VARCHAR2(2)) month, cast(K.KON_KOD as VARCHAR2(50)) SEX, cast('Internal' as VARCHAR2(50)) R_KOD, F.NR_dism REK from test.Table_anstallda F join test.PERIOD P on P.PERIOD_SN = F.PERIOD;
Hi Prabhu,
ReplyDeleteI’ve often thought about this Oracle Coherence . Nice to have it laid out so clearly. Great eye opener.
Our project DBA Team is planning to migrate Oracle DB from version 11.2.0.4 to 12.2.0.1.
Could you please let me know what the Ares which gets impacted from DB Development Team prospective?
Our DBA Team will take care of up gradation.
But I want to know any deprecated concepts/impacted Ares in Higher version?
Current Version: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
Thanks a lot. This was a perfect step-by-step guide. Don’t think it could have been done better.
Thanks,
Morgan
Olà,
ReplyDeleteBrilliant article, glad I slogged through the Java interview questions. it seems that a whole lot of the details really come back to from my past project.
i creat a view as(see below)
the problem is that i get dublicat rows and with UNION they are deselected,
i dont want to use UNION ALL
so my question is, how can i rewrite the two "select .. " to a Group by expression, Group by: YEAR, Month
and get the same result as UNION ALL
CREAT VIEW v_test_rerytering (.......) AS
select
F.ALDER
age,
cast(P.AR as VARCHAR2(4)) year,
ccast((P.MANAD)as VARCHAR2(2)) month,
cast(K.KON_KOD as VARCHAR2(50)) SEX,
cast('Ext' as VARCHAR2(50)) R_KOD,
F.NR_REK
REK
from test.Table_anstallda F join test.PERIOD P on P.PERIOD =
F.PERIOD
union
select
F.ALDER
age,
cast(P.AR as VARCHAR2(4)) year,
ccast((P.MANAD)as VARCHAR2(2)) month,
cast(K.KON_KOD as VARCHAR2(50)) SEX,
cast('Internal' as VARCHAR2(50)) R_KOD,
F.NR_dism
REK
from test.Table_anstallda F join test.PERIOD P on P.PERIOD_SN =
F.PERIOD;
Please keep providing such valuable information.
Merci Beaucoup,
Radhey