How to write a view to de-normalize the table rows?
04/12/2018 11:47
i have the following table structure with sample data TranxID RowID Table Description NewValueOldValue1000 1 Table1 IDX 11000 1 Table1 MAPPING AB1000 2 Table1 IDX 21000 2 Table1 MAPPING XY1000 1 Table2 IDX 11000 1 Table2 MAPPING CD2000 1 Table1 IDX 12000 1 Table1 MAPPING BU i want to write a view to group them into the following structure TranxID RowID Tb1_IDX_New Tb1_IDX_Old Tb1_MAPPING_New Tb1_MAPPING_OldTb2_IDX_New Tb2_IDX_Old Tb2_MAPPING_New Tb2_MAPPING_Old1000 1 1 A B1 C D1000 2 2 X Y2000 1 1 B U

Source is Usenet: comp.databases.oracle.server
Sign in to add a comment

Answer score: 5
04/12/2018 11:47 - Then by all means do so.

I'm sorry but is there a question in here somewhere? Or do you expectsomeone to do your work for you and also have to figure out the businessrules too.


Source is Usenet: comp.databases.oracle.server
Sign in to add a comment

Answer score: 5
04/12/2018 11:47 - More helpful comments from Daniel Morgan. I must jot them all down. Itreally was so worthy of my time to read this drivel and constantattempts at one-upmanship and newsgroup bullying.

Daniel you post for the sake of posting to this newsgroup probablybecause you have nothing else to do. Write something helpful or don'tbother to write anything. You are a waste of bandwidth and an arsehole.

Godfrey

Source is Usenet: comp.databases.oracle.server
Sign in to add a comment

Answer score: 5
04/12/2018 11:47 - And you helped the OP HOW??? BTW here's a hint for the other person: self join. Without moreinformation on the requirements, it really is unanswerable.


Source is Usenet: comp.databases.oracle.server
Sign in to add a comment

eDiscover
Helpforce eDiscover provides technical articles updated each dayHelpforce eDiscover RSS feed contains the latest technical articles in RSS
Click the logo to go back to the main page
Search eDiscover
  
Categories

Click an icon to go to that category

Helpforce eDiscover contains articles about Microsoft Windows Helpforce eDiscover contains articles about Apple products and MacOS Helpforce eDiscover contains articles about Linux and POSIX operating systems Helpforce eDiscover contains articles about Helpforce Helpforce has a large variety of technical information and articles for you to read Helpforce eDiscover contains articles about databases, MYSQL, SQL Server Oracle Helpforce eDiscover contains articles about Java, JVM and the JRE Helpforce eDiscover contains articles about the QNX operating system Helpforce eDiscover contains articles about Oracle Solaris and Open Solaris Helpforce eDiscover contains articles about RISC OS, Acorn and the BBC Micro Helpforce eDiscover contains articles about Amiga and AmigaOS

Type your comment into the box below