OK, so I'm really a newbie on Oracle - I've used MS-SQL for a while though...
I have access to a remote server running 10g (I think on a UNIX box) from my WinXP machine. I seem to be able to run some queries (e.g. Select count(*) from table), and can certainly create a table from dta in aother table,whcih is what I have done. I now have a new table which I can count the records from (588 is all!), but I cannot select * from the table to see the records.
I'm trying to use a query tool called AquaDataStudio, as that seems more familiar to me, and when I have tried to use SQL*Plus I can't see a way to copy and paste the data into Excel to be able to do some analysis on it.
Somehow though, there is no way that I can actually select data from the table and see it.
Am I missing something really obvious? I guess I must be, but I have no idea what I can be doing wrong, or how on earth to just get to see my data.
Any help woul be HUGELY appreciated!
Fee.
xx
Fi.
"The question should be, is it worth trying to do, not can it be done"
I have access to a remote server running 10g (I think on a UNIX box) from my WinXP machine. I seem to be able to run some queries (e.g. Select count(*) from table), and can certainly create a table from dta in aother table,whcih is what I have done. I now have a new table which I can count the records from (588 is all!), but I cannot select * from the table to see the records.
I'm trying to use a query tool called AquaDataStudio, as that seems more familiar to me, and when I have tried to use SQL*Plus I can't see a way to copy and paste the data into Excel to be able to do some analysis on it.
Somehow though, there is no way that I can actually select data from the table and see it.
Am I missing something really obvious? I guess I must be, but I have no idea what I can be doing wrong, or how on earth to just get to see my data.
Any help woul be HUGELY appreciated!
Fee.
xx
Fi.
"The question should be, is it worth trying to do, not can it be done"