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 Chris Miller 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: *

  1. segmentfault

    rollup and group by

    the total_days column will not be store in the database. this column will just be generated when the sql query is run.
  2. segmentfault

    rollup and group by

    i have a table that contain the following visit days total_days 1 2 2 3 3 1 4 2 what i want to do is sum up the days so that the output looks like this visit days total_days 1 2 2 2 3 5 3 1 8 4 2 10 can...
  3. segmentfault

    pipelined table function

    i have a table function (pipelined) which take as an argument a cursor. for each row in the cursor i go and execute another query which produce more than 5 rows. for example, for one row in the cursor, my query can produce 5 rows. for another row in the cursor the query can produce 7 rows...

Part and Inventory Search

Back
Top