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 TouchToneTommy 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: skipizza
  • Content: Threads
  • Order by date
  1. skipizza

    Timestamp conversion

    How does one convert UTC timestamps to human readable form? I could not find a function to do this. Also, is there a function to calculate days between dates? Thanks!
  2. skipizza

    How to query from somewhere in the middle of table

    How does one query starting from the middle of a table? Suppose there is table with 500 rows and the first 250 rows were selected. SELECT * FROM table1 WHERE rownum < 251; How can the second 250 rows be selected? How does one select the 300th to 399th row?
  3. skipizza

    Combine tables, duplicate key rows

    I would like to combine three Oracle 8i tables into one. However, when combined there are duplicate key rows. How can I delete them or create the combined table without allowing the dupes? Thanks.
  4. skipizza

    Combining Tables, Deleting Duplicates

    I would like to combine three Oracle 8i tables, but when the tables are combined there are duplicate key rows. How can I create a combined table without the duplicate key rows or how can I delete the duplicate key rows?

Part and Inventory Search

Back
Top