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!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Mel1
  • Order by date
  1. Mel1

    using Decode alias in where claus

    The decode statement is something like: select decode(value1<value2, &quot;late&quot;, value1=<value2, &quot;on time&quot;, &quot;early&quot;) 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...
  2. Mel1

    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?
  3. Mel1

    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...

Part and Inventory Search

Back
Top