Skip to Main Content
Forums

SQL & PL/SQL

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

query only outer range

474007Dec 2 2006 — edited Aug 4 2008
Hi,
I have a input table

INPUT
1
2
3
5
7
8
9
11
12
13
15
17
18
20
21
22
23

and i want only the following numbers:

OUPUT
1
3
5
7
9
11
13
15
17
18
20
23

As you see i want only the number from the outer range. Can this be done with without plsql?

Greetings

Comments

maceyah
Answer
Sounds like connection pooling. You might want to try changing your GTT from flush on end of session to flush on commit.
Marked as Answer by 877857 · Sep 27 2020
TexasApexDeveloper
You MIGHT want to read up on GTT's and APEX. Since apex does session sharing, they ARE NOT really supported well in APEX. I would suggest you look at collections, which are a better solution with APEX and temporary data storage..

Thank you,

Tony Miller
LuvMuffin Software
2 people found this helpful
Rod West
Hi,

You need to ensure that your GTTs are created with ON COMMIT DELETE ROWS. If the GTT is created with ON COMMIT PRESERVE ROWS then the contents of the table will be preserved for the life of the session. As Apex reuses sessions from the session pool if you have defined your GTTs with preserve rows you will need to ensure that all rows are deleted from the GTT before the GTT is used in your Apex application.

Rod West
1 person found this helpful
fac586
Rod West wrote:

You need to ensure that your GTTs are created with ON COMMIT DELETE ROWS.
As 710781 to most developers this is likely to be problematic as well. Use APEX collections.
1 person found this helpful
877857
I want to thank everyone for the comments. I put "on commit preserve rows" I did not know that Apex uses connection pooling and this could cause this problem.

thank you

Márcio Gonçalez
1 - 5
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 1 2008
Added on Dec 2 2006
6 comments
2,376 views