Oracle Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsDatabasesOracle Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old September 13th, 2005, 09:53 PM
mcraft59 mcraft59 is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Apr 2004
Location: Brooklyn
Posts: 157 mcraft59 User rank is Lance Corporal (50 - 100 Reputation Level)mcraft59 User rank is Lance Corporal (50 - 100 Reputation Level)mcraft59 User rank is Lance Corporal (50 - 100 Reputation Level) 
Time spent in forums: 1 Day 4 h 16 m 54 sec
Reputation Power: 5
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?

Reply With Quote
  #2  
Old September 14th, 2005, 02:38 AM
pabloj's Avatar
pabloj pabloj is offline
Modding: Oracle MsSQL Firebird
Dev Shed God 6th Plane (7500 - 7999 posts)
 
Join Date: Jun 2001
Location: Outside US
Posts: 7,815 pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level) 
Time spent in forums: 2 Months 3 Weeks 1 Day 14 m 37 sec
Reputation Power: 278
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.

Reply With Quote
  #3  
Old September 18th, 2005, 09:38 AM
mwild8's Avatar
mwild8 mwild8 is offline
Blame it on the falling sky
Dev Shed Novice (500 - 999 posts)
 
Join Date: Jul 2005
Location: ny
Posts: 992 mwild8 User rank is Sergeant Major (2000 - 5000 Reputation Level)mwild8 User rank is Sergeant Major (2000 - 5000 Reputation Level)mwild8 User rank is Sergeant Major (2000 - 5000 Reputation Level)mwild8 User rank is Sergeant Major (2000 - 5000 Reputation Level)mwild8 User rank is Sergeant Major (2000 - 5000 Reputation Level)mwild8 User rank is Sergeant Major (2000 - 5000 Reputation Level) 
Time spent in forums: 1 Week 1 Day 15 h 57 m 43 sec
Reputation Power: 36
Send a message via AIM to mwild8 Send a message via MSN to mwild8
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....

Reply With Quote
Reply

Viewing: Dev Shed ForumsDatabasesOracle Development > Oracle Development


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 2 hosted by Hostway