 |
|
 |
Oracle Database Scripts
Flip a table on the side (SQL Trick): The Script: SQL: Select name, value from tbl; Results:| Name | Value |
|---|
| Param1 | 10 | | Param1 | 20 | | Param1 | 30 | Flip Table SQL:select max(decode(name,'Param1',value,'')) Param1, max(decode(name,'Param2',value,'')) Param2, max(decode(name,'Param3',value,'')) Param3 from tbl; Results: Donate 5$If you found this information useful, don't be cheap, donate 5 dollars (with PayPal):
|
|
 |