Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

sorting which keeps the parent child structure

3288275Jul 31 2016 — edited Aug 1 2016

I have the following data in my database table.

rec_id        description        parent_id    ip_address        is_parent

100        Record 1        1000        80.160.4.5          1

101        child               1000        169.60.5.20        0

105        child               1000        169.60.5.20        0

103        Record 2        1002        80.160.4.3          1

104        child               1002        169.60.2.5          0

102        Record 3        1001        80.160.4.2          1

I want a sorting based on the column: ip_address of records where is_parent = 1

The parent record should be listed first and the corresponding child should list immediately after the parent.

The result should be as given below:

rec_id        description        parent_id    ip_address        is_parent

102        Record 3        1001        80.160.4.2          1

103        Record 2        1002        80.160.4.3          1

104        child               1002        169.60.2.5          0

100        Record 1        1000        80.160.4.5          1

101        child               1000        169.60.5.20        0

105        child               1000        169.60.5.20        0

Can anyone please help me to achievethe above result?
This post has been answered by AndrewSayer on Jul 31 2016
Jump to Answer

Comments

Alex Keh-Oracle
Answer

Here's directions on how to call OracleConfiguration class properties from EF Core:

https://docs.oracle.com/en/database/oracle/oracle-data-access-components/19.3/odpnt/EFCoreClasses.html#GUID-D5D99935-D8A…

Marked as Answer by user613363 · Sep 27 2020
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 29 2016
Added on Jul 31 2016
#general-database-discussions
5 comments
941 views