Results 1 to 2 of 2

Thread: Oracle forms

  1. #1
    Join Date
    Jan 2005

    Unanswered: Oracle forms

    I have a multirecord data block what we can see at a form (oracle forms 9).
    Is there a simple way to count the distinct items that a field of that block has?
    A way is to do a loop at this block and count that, is there another simpler way?
    1st   2cnd
     a       b
     b       c
     c       c
    count (*) of distinct items of 2cnd=2
    The query for a table should be

    select count (*) fom (select distinct field from table)

  2. #2
    Join Date
    Jan 2004
    Croatia, Europe
    Provided Answers: 5
    Well, you could create a push button which would (in a loop again, though) store desired column values into a (global temporary?) table and return simple SELECT COUNT(distinct column_name) FROM temp_table.

    Perhaps there is a way to do that using one (or more) of the existing Forms built-ins, but I don' know it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts