Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
using Decode alias in where claus
The decode statement is something like: select decode(value1<value2, "late", value1=<value2, "on time", "early") part_status We want to use the alias part_status in the where statement of the same select -- for example select decode(table1.field1<table1.field2...- Mel1
- Post #3
- Forum: Oracle: All versions
-
using Decode alias in where claus
We have a decode statement in the select clause where we are storing the value into a alias field name. Can you use this alias field name in the where clause of the PL/SQL query?- Mel1
- Thread
- Replies: 3
- Forum: Oracle: All versions
-
Set target for hyplerlink formula in CR
We have a crystal reports that pulls data from an ORACLE table. The report contains a list of items currently in work in the shop. The form is viewed via the web using the Crystal viewer. Each item has a unique identifier. The report has a hyperlink formula that sends the unique identifier...- Mel1
- Thread
- Replies: 0
- Forum: Business Objects: Crystal Reports 4 Other topics
