Accessing MS-eXcel Data from SQLPlus

I am running Oracle 10g on an Windows XP system.

  1. How do I access data in a MS-eXcel spreadsheet from SQLPlus? I have set up the eXcel ODBC Driver.

  2. What does the following SQL Server code translate to in SQL Plus?

    Declare @equip INT
    Set @equip = (select ID from azteca.PWSYSID where SYSTYPE = 'MISC') + 1
    DBCC CHECKIDENT ('equipment_Raw', reseed, @equip)

1 answer

Please ignore item 2, this is SQL Servers AutoNumber function and I can use SEQUENCE to do the same thing. Also, the @ prefix just identifies the variable as local.