|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Oracle Development
I've been using MySQL for the past two years and have been considering picking up Oracle as a side project. Will it be hard for someone coming from a MySQL end? I've had a friend complain about how it is totally ***-backwards especially if you want something to auto-increment, and he mentioned things about stored procedures....
I briefly viewed Oracles website and there are different versions? I saw something about version 8,9, and now 10g? What would be the best to install and learn? Is it worth it to try and get certified? |
|
#2
|
||||
|
||||
|
Oracle is the leader in database market, so it's certainly worth to know it and possibly be certified.
It has a lot more features than MySQL and this makes the "migration" a bit harder. The latest version is 10g, so go with it. Note that autoincrement fields are less than optimal and Oracle (and Firebird and PostgreSQL) uses sequences and triggers to substitute them with greater control.
__________________
My blog about OpenSource Databases PDF tutorials about OSS databases, DBMonster ... Please contribute to Open Source Development, fill bug reports!!! Developer Shed eSupport Commented my.ini/my.cnf (PLEASE ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins |
|
#3
|
||||
|
||||
|
im still confused what oracle is....
so its not a query language like SQL? cause it looks as if SQL is used with oracle which confuses me even more... i thought it was just another query syntax.... |
![]() |
| Viewing: Dev Shed Forums > Databases > Oracle Development > Oracle Development |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|