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 Mike Lewis 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: sky1
  • Order by date
  1. sky1

    Summarise a SQL List

    You can also do this assumming name of table is food... select distinct aid, decode(count(*),1,atxt,'mixed') from (select distinct a.id aid, a.txt atxt, b.txt btxt from food a, food b where a.id = b.id) group by aid, atxt
  2. sky1

    Inserting a Blob from a Web Page

    Maybe instead of using a blob, you could just keep the path and access the files using the path you have stored in your table. Just a suggestion.
  3. sky1

    Cross tab query in Oracle

    Give me an example of a TRANSFORM/PIVOT and maybe I can help you out.

Part and Inventory Search

Back
Top