Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Oracle DB stuff Expand / Collapse
Author
Message
Posted Tuesday, January 29, 2008 1:37 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, February 26, 2008 12:27 AM
Points: 50, Visits: 115
Hello, guys how are you doing?

I am familiar with SQL server 2000 database. and I am interested to learn this Oracle DB staff. do you think it is easy to learn? what is the deference between SQL and Oracle database?

Please guys i need your help and I want to know about this Oracle DB staff.


thank you very much
Post #448724
Posted Tuesday, January 29, 2008 9:11 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, October 17, 2014 7:12 AM
Points: 1,031, Visits: 2,796
This link might help you start...
http://www.microsoft.com/sql/prodinfo/compare/oracle/default.mspx

don't know too much about Oracle training material though sorry. I'm sure there's a similar range of books out there that SQL Server has.


Gethyn Ellis

gethynellis.com
Post #448936
Posted Tuesday, January 29, 2008 10:50 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 8:22 AM
Points: 14,205, Visits: 28,534
Personall, I'd start here.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of:
SQL Server Query Performance Tuning
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #449016
Posted Wednesday, January 30, 2008 12:52 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, February 26, 2008 12:27 AM
Points: 50, Visits: 115


Thank you very much guys

appreciated
Post #449213
Posted Wednesday, January 30, 2008 1:59 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 30, 2014 10:08 PM
Points: 1,038, Visits: 444
Do a search for and downloads a product (there's a free version) called TOAD for Oracle. It makes Oracle a LOT easier to use and more familiar for us MS SQL folk. We've got a client where we need to read stuff from the Oracle tables. Whilst the concepts are the same, the tools aren't as nice (Java GUI controls just miss a lot of nice stuff) and things are just, well, different.... :D


Post #449220
Posted Wednesday, January 30, 2008 3:27 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 6:03 AM
Points: 2,900, Visits: 3,301
Take a look at the Oracle site. Sign up for their free magazine, it contains a lot of useful info similar to SQL Server Magazine. Look for Oracle newsgroups, and start looking at the questions and answers. Expect most things in Oracle to be much the same as SQL Server, but also be prepared for different ways of doing familiar tasks, and for a few significant differences. Download a trial copy of Oracle for Windows (or *nix if you run that) and play with it.

Eventually you will know quite a bit about Oracle, but you will have to use a lot of your time to do so. You just need to decide how much time you are prepared to spend, and hence how much you will eventually know. If you want to know Oracle as more than a hobby, then you will need to get a job where you can use it for real.


Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2014, 2012, 2008 R2, 2008 and 2005. 18 October 2014: now over 31,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.
Post #449244
Posted Wednesday, January 30, 2008 9:57 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, December 3, 2014 8:43 AM
Points: 417, Visits: 1,157
The Oracle Technology Network is a great networking site for developers and DBA's. It contains tons of information on whatever you want to know about Oracle. Use this link to find out more and to join. http://www.oracle.com/technology/index.html

I also like the following book for DBA's:
Oracle Database 11g DBA Handbook by Bob Bryla and Kevin Loney.

Post #449524
Posted Wednesday, January 30, 2008 3:23 PM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Saturday, August 25, 2012 9:48 PM
Points: 777, Visits: 134
hi,
i agree with Ian Yates for using TOAD.its really a good interface between oracle and DB.nice to work.

cheers
sreejith
MCAD
Post #449720
Posted Thursday, January 31, 2008 12:04 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, February 26, 2008 12:27 AM
Points: 50, Visits: 115
Thanks a lot guys :D
Post #449826
Posted Thursday, January 31, 2008 6:46 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, December 18, 2014 12:03 PM
Points: 2,839, Visits: 3,146
Use the web site www.toadsoft.com to download the free version of TOAD. It does not have the full version of TOAD but is good enough to do most of the work, it just does not have debugging and some fancy functions.
If you go to WWW.Quest.com, you will never find the free version of TOAD.
Post #449916
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse