You asked: I need to have a query which will give me the smallest value in a table and the column containing it. Please note there can be any number of columns. All will be number data type.
We said: This can be achieved by unpivoting the result set and then group them to find their minimum value as shown below.
Tips and Tricks in Oracle Advanced Concepts
Subscribe to:
Posts (Atom)
-
The DESCRIBE_COLUMNS API describes the columns of the SELECT statement which is opened and parsed through a cursor. This procedure consist...
-
The multiset operators are a bunch in number, which combines two or more collection types of the same type and returns a collection resu...
-
We have encrypted our data while storing it in the database, but have we ever tried to encrypt our PL/SQL subprograms while creating them? T...