PDA

View Full Version : oracle



Leeman_s
08-14-2003, 09:31 PM
Can anyone provide some links on programming for Oracle? I hear its pretty expensive. Can I learn about it, and program for it, without buying it?

I have no idea about anything about it, so any information about it would be useful. thanks.

Perspective
08-14-2003, 09:47 PM
to use a DB like oracle (which i have used and quite liked) you need to learn a query language like SQL. you interface with the DB using something like ODBC or JDBC (java) and use a query language to access/manipulate data.

vasanth
08-14-2003, 10:24 PM
dont worry abt ODBJ etc etc connectivity etc etc.. just learn SQL for now.. once you master it you can then learn to use it in your programs... yes oracle is expensive and it is a very robust RDBMS..

adrianxw
08-15-2003, 02:45 AM
Most of the big DB systems provide their own API for programming, it is often the fastest, but of course, if you decide to dump, say Oracle and insert SyBase, all the API's need changing.

ODBC is old hat now, but is not difficult and still works. OLE DB is what replaced it.

Oracle is frightfully expensive IMHO.

nvoigt
08-15-2003, 05:43 AM
>Oracle is frightfully expensive IMHO.

For a business it really is. But if your corp pays for it and you just need something to play with at home, there is a full version for free private use on Oracles website.

The oracle interface is called OCI ( Oracle Call Interface ).
ODBC is slow and old, but portable enough should you decide to use MySql, MSSql, Access or whateever.

Learn SQL first, this is what you need for all databases.