| I don't have database [message #266188] |
Mon, 10 September 2007 02:44  |
nomannishat
Messages: 11
Registered: September 2007
Location: PAKISTAN
|
Junior Member |
|
|
Hi,
I don't have database but i have 10g DS. I have excel file and i want to connect this excel file to the sqlplus 10g(DS) how can i connect this file ? its very urgent please let me know ?
Thanks in advance
Noman Nishat
|
|
|
|
| Re: I don't have database [message #266194 is a reply to message #266188] |
Mon, 10 September 2007 02:56  |
ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany
|
Senior Member |
|
|
It's not possible.
You will either have to create a database and load the data into the database ( which can not be done in an 'urgent' environment unless you know exactly what you are doing ) or access the excel file some other way, with Access maybe.
|
|
|
|
|
|
|
|
|
|
|
|
| Re: I don't have database [message #266368 is a reply to message #266234] |
Mon, 10 September 2007 11:55 |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
| nomannishat | Somebudy told me that u can reterive the this data which is in excel sheet through sqlplus of 10g(DS).
|
I believe that buddy of yours meant you could use the external tables feature (available from 9i onwards). A standard pathway is to save Excel file as a CSV (comma separated values) file and load it into an Oracle database using either SQL*Loader utility or make this file an external table.
However, as previously stated, Developer Suite (you installed) is simply not enough - you have a tool (SQL*Plus), but you don't have a database to connect to. Or, do you have it, but didn't tell us?
Just being curious - once you find a database and load data from Excel file into it, what do you plan to do with these records?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
