Recent content by skipizza

Yes, the SELECT TO_DATE('31-SEP-02') - TO_DATE('01-SEP-01) FROM DUAL; works fine. Thanks. However, I could not get the UTC date, actually a UNIX timestamp based on standard UNIX epoch of 01/01/1970 at 00:00:00 GMT, to convert. SELECT TO_CHAR(1001000000, 'MM-DD-YY') FROM DUAL...

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!

carp, I think most of the time it does. I suppose Oracle does not guarantee the same order every time because some select statments process in parallel.

Thanks, both methods work. The inline view works well on a very large table, too.

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?

All 3 tables have same columns. SQL> desc acma1 Name Null? Type -------------------- ------------------ k$$oid NOT NULL VARCHAR2(20) seq$$ NOT NULL NUMBER(11) value VARCHAR2(20) The key fields would be k$$oid and value.

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.

The sqlldr statement should read: sqlldr uid@host/pwd

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?