My Oracle Support Banner

R12: AP: How To Eliminate Trailing Spaces From A Table For 1 Or More Record(s) Using a Condition Without A Full Table Scan (Doc ID 429985.1)

Last updated on JUNE 24, 2019

Applies to:

Oracle Payables - Version 11.5.9 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
APXVDMVD.fmb APXINWKB.fmb

Goal

Q1: How does one detect and eliminate the trailing spaces in one table without having to make a full table scan?

Q2: How can the procedure chk_trail_space_per_record be created?

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.