Skip to Main Content

SQL Developer Data Modeler

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!

How to customize FK Discovery

Kent GrazianoApr 22 2015 — edited Aug 11 2015

I have a 3rd party database that has PKs defined on every table but no FKs in the database. How do I get the FK Dsicover utility to find FK columns with this type of pattern:

Parent PK column = TABCUSTNUM

Child FK column = ABCCUSTNUM

So the root column name (CUSTNUM) is standard but in every table the column name has a different 3 character "prefix" that is effectively the table short name. Is there way to get the utility to ignore the first three characters of the column names?

This post has been answered by Philip Stoyanov-Oracle on Apr 24 2015
Jump to Answer

Comments

fac586

SACH!N-Oracle wrote:

In my apex report, even after setting the 'maximum rows per page' value to 20, I'm able to see all the 29 rows.

I'm using Universal Theme - 42 with tab based navigation.

Apex version i'm using is apex 18.1.

Is this a bug or do i need to set any other attribute in 18.1 release ?

What do you mean by "apex report"? Always specify clearly and unambiguously exactly which APEX region or component type you are referring to.

SACH!N-Oracle

It's an interactive report region.

Thanks,

Sachin

fac586

SACH!N-Oracle wrote:

It's an interactive report region.

Read the online help for the Maximum Rows Per Page property:

Maximum Rows Per Page

Enter the maximum number to display in the Rows Per Page selector.

It would appear that it doesn't do what you think it does. Are you confusing it with the Maximum Rows to Process property in the Performance section of the property sheet?

SACH!N-Oracle
Answer

Yes i'm aware of that property.

I'm not sure whether it's an apex or my browser's (Mozilla) bug, the 'Maximum Rows Per Page' count, which i had given for my IR region (maximum 20 rows per page) was not reflecting.

Later when i changed a few other IR region attribute values it worked for me. I'll explain.

Earlier the IR region 'Heading' property was set as 'Fixed To: Page'

I changed it to 'Fixed To: Region' and also gave the 'Maximum Report Height' value.

After changing the above attribute values and reloading the IR report page, to my surprise i found that the 'Maximum Rows Per Page' property was working (only 20 rows were displayed).

Later i reverted the IR region 'Heading' property as 'Fixed To: Page' and reloaded the page, i found the 'Maximum Rows Per Page' property is working.

Someway the issue got resolved, but as i mentioned earlier, still I'm not sure whether it's an apex or my browser's (Mozilla) bug or some sort of cache issue.

Thanks,
Sachin

Marked as Answer by SACH!N-Oracle · Sep 27 2020
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 8 2015
Added on Apr 22 2015
7 comments
2,355 views