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. 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)
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.
Selected Articles