Hello Everyone,
I have a array of ids from my search result and now I want to
fetch the details from the database.
Now IN query is ruined my sort order.So should I go for Union All?
Is there any other method to fetch the data..?
Please help me in this
Thanks in advance...
Bart van Houdt wrote:
Oracle has a nice package procedure (dbms_output.put_line) to display a
message in SQL*Plus, which can display a message to the user. I use this
a lot, to notify users of the progress being made during the execution
of a script.
Is there a way to do this with Postgres
On Nov 5, 2008, at 8:42 AM, Hemant Patel wrote:
Hello Everyone,
I have a array of ids from my search result and now
I want to fetch the details from the database.
Now IN query is ruined my sort order.So should I go for Union All?
IN doesn't ruin your sort order really
Let Say I have the array of primary key of some table say XYZ.
For e.g. (555,222,333,111)
When I query for these results I will get the result like in the order of
(111,222,333,555) .
So now I need to process in the business logic to maintain the search criteria.
But I want the result from IIN
On Wed, Nov 5, 2008 at 9:21 AM, Hemant Patel [EMAIL PROTECTED] wrote:
Let Say I have the array of primary key of some table say XYZ.
For e.g. (555,222,333,111)
When I query for these results I will get the result like in the order of
(111,222,333,555) .
So now I need to process in the
