Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    37

    Red face Unanswered: Can you Sort out this problem please?

    How can I sort records based on a non dabase field in a Oracle form?
    Say for eg: I have Item_id in the table and description is in post query which is a non databse field .. then is it possible to sort on this description fld..If yes how?????
    regards..
    Chiranjib
    Last edited by chiranjib_s; 03-16-04 at 06:49.

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: Can you Sort out this problem please?

    No but there are other ways, such as:

    ORDER BY (SELECT col FROM other_table WHERE ...)

    Or create a view that joins the 2 tables and base the block on that view.

Posting Permissions

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