Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: st: How to save Oracle select data?
From
Andrew Dyck <[email protected]>
To
[email protected]
Subject
Re: st: How to save Oracle select data?
Date
Thu, 22 Sep 2011 08:57:02 -0700
While I've never used Oracle, I understand that one can connect to it
via ODBC as you would with MySQL, SQL Server or PostgreSQL. If you are
a windows user you'll probably need to download an ODBC driver for
Oracle, setup a DSN and then look through the help files on -odbc-.
You'll end up running a command in Stata something like:
odbc load, exec("SELECT * FROM my_table") dsn("MyOracleDb")
Good luck!
Andrew
On Wed, Sep 21, 2011 at 11:05 PM, mingchei--ntu <[email protected]> wrote:
>
> I need run some data on oracle. If i need using the Stata.
> I always select data then save to text data, then import into
> Stata, Dose any tips can do that, Just select Oracle data on Stata and save it ?
>
>
> Regard
>
> Mingchei Lin
> [email protected]
> *
> * For searches and help try:
> * http://www.stata.com/help.cgi?search
> * http://www.stata.com/support/statalist/faq
> * http://www.ats.ucla.edu/stat/stata/
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/