Main Page | Report this Page
Computers Forum Index  »  Computer - Databases - Oracle (Tools)  »  question about freeware oracle...
Page 1 of 1    

question about freeware oracle...

Author Message
JSz...
Posted: Thu Oct 08, 2009 11:02 am
Guest
Hello!

I would like connect to database which is located in USA from private home.
I don`t have Oracle licence.
Is there any possiblity to use Oracle client and use some application to
connect to American Oracle database?

I`ve heard that I should use Oracle client and SQL Plus which are freeware?
Can you verify my suggestion?

I would like to write a package in PL/SQL language. I don`t want to use
Oracle Forms & Reports.

Can you paste the link to Oracle client, because I cannot find it:(
I would like to use it on Windows XP system.

Thank you in advance
netman
 
Thomas Olszewicki...
Posted: Thu Oct 08, 2009 1:25 pm
Guest
On Oct 8, 3:02 am, "JSz" <net... at (no spam) poczta.onet.pl> wrote:
Quote:
Hello!

I would like connect to database which is located in USA from private home.
I don`t have Oracle licence.
Is there any possiblity to use Oracle client and use some application to
connect to American Oracle database?

I`ve heard that I should use Oracle client and SQL Plus which are freeware?
Can you verify my suggestion?

I would like to write a package in PL/SQL language. I don`t want to use
Oracle Forms & Reports.

Can you paste the link to Oracle client, because I cannot find it:(
I would like to use it on Windows XP system.

Thank you in advance
netman

You can download Oracle Instant client from here:
http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html
I would suggest reading some basic docs,
starting with:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/toc.htm
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14261/toc.htm

HTH
Thomas
PS.Powodzenia.
 
Shakespeare...
Posted: Fri Oct 09, 2009 12:34 am
Guest
Thomas Olszewicki schreef:
Quote:
On Oct 8, 3:02 am, "JSz" <net... at (no spam) poczta.onet.pl> wrote:
Hello!

I would like connect to database which is located in USA from private home.
I don`t have Oracle licence.
Is there any possiblity to use Oracle client and use some application to
connect to American Oracle database?

I`ve heard that I should use Oracle client and SQL Plus which are freeware?
Can you verify my suggestion?

I would like to write a package in PL/SQL language. I don`t want to use
Oracle Forms & Reports.

Can you paste the link to Oracle client, because I cannot find it:(
I would like to use it on Windows XP system.

Thank you in advance
netman

You can download Oracle Instant client from here:
http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html
I would suggest reading some basic docs,
starting with:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/toc.htm
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14261/toc.htm

HTH
Thomas
PS.Powodzenia.

If you want to use a package, you'll need a database yourself to store
and run the package, unless you can store your packages on the American
server. If you want to use 'client only' packages, you're tied to using
Forms. I don't know any other tool to use client side Pl/sql.
Oracle XE (Express Edition) is a free database. It has some limits
though. It comes with SQLPlus as well, and you can download it on
otn.oracle.com after you registered there (which is free as well)

Shakespeare
 
 
Page 1 of 1    
All times are GMT
The time now is Fri Dec 11, 2009 3:25 am