Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Server Adventures for the Oracle DBA


SQL Server Adventures for the Oracle DBA

Author
Message
Loner
Loner
Hall of Fame
Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)

Group: General Forum Members
Points: 3028 Visits: 3345
Comments posted here are about the content posted at temp
David Coster
David Coster
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
Points: 6 Visits: 148
Well said and I am glad that you have got past the whole experience of being yelled at and gone to a place that appreciates you! I don't think yelling at other staff members is acceptable. I have worked with a programmer who couldn't program and my approach to that difficult situation was first to try and help them. When it became fairly obvious that they were not cut out to be a programmer I guess I tried to suggest they change career. Not like your case, howevwer, where you clearly are a competent developer.

Thanks
David :-)
Kevin Seng
Kevin Seng
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
Points: 5 Visits: 2
Good article, I still remember when I move from T-SQL to PL/SQL I found the SQL was so much difference. Luckly I use SQL Navigator which make things lot more simple. Now I still code in both SQL :-) Personally I like PL/SQL especially the CURSOR
Luis Garcia
Luis Garcia
SSC Rookie
SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)

Group: General Forum Members
Points: 49 Visits: 123
Experience, experience, experience and a will to spend some time banging your head on the desk is what is required to do such a swap of working tools...

After going through Oracle, SQL server and Sybase I think that is just a question of a few months missing it. After that is a piece of cake!

Having a tough job teaches you a lot!! All good!

Congratuilations with your new job, perseverance pays back!!

Can be applied to programming languages, once you understand what it is important to learn first you will be ok!!

Next step then is CLR C# ? ;P
RichB
RichB
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1207 Visits: 1024

Good story, sounds like you had fun...

Btw you say "though in SQL 2000 there is array processing." Perhaps I am being a little daft - but could you explain?

Cheers

Wang.





Stephen Hirsch
Stephen Hirsch
SSC-Enthusiastic
SSC-Enthusiastic (172 reputation)SSC-Enthusiastic (172 reputation)SSC-Enthusiastic (172 reputation)SSC-Enthusiastic (172 reputation)SSC-Enthusiastic (172 reputation)SSC-Enthusiastic (172 reputation)SSC-Enthusiastic (172 reputation)SSC-Enthusiastic (172 reputation)

Group: General Forum Members
Points: 172 Visits: 161
Very nice article. I'm an Oracle person who's dabbled in SQL, yes, it does seem very true that SQL is not SQL (shhh, don't tell the recruiters (:=))
Loner
Loner
Hall of Fame
Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)

Group: General Forum Members
Points: 3028 Visits: 3345

Array processing - before SQL Server 2000, you can only create temporary table, but now you can create an arrary.

DECLARE arraryname TABLE (....)

It is just liked creating a temp table but it does not take up space in Tempdb.

You use the exact same command to insert data and select data but you don't have to delete it afterward.


sheepoo
sheepoo
SSC-Enthusiastic
SSC-Enthusiastic (139 reputation)SSC-Enthusiastic (139 reputation)SSC-Enthusiastic (139 reputation)SSC-Enthusiastic (139 reputation)SSC-Enthusiastic (139 reputation)SSC-Enthusiastic (139 reputation)SSC-Enthusiastic (139 reputation)SSC-Enthusiastic (139 reputation)

Group: General Forum Members
Points: 139 Visits: 34
...though in SQL 2000 there is array processing

This definitely stumped me!!!!!
How come?
jay-h
jay-h
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1173 Visits: 2257

Good article, appreciate your writing about your experiences (sounds a bit tough, glad you survived).

I think there is a need for more articles about the conceptual mapping: how does one do a job in SQL Server vs Oracle. SQL syntax is reasonably similar, but other operations are radically different. Most of my experience is in SQL server, but I am occasionally called on to do something in an Oracle instance and it can be a bit intimidating. For example I had to make an archive copy of an Oracle data model on the same machine under a different name (this was part of a third party application). In MS, I would simply do a .bak and restore it under a different name, but that does not seem directly mappable to Oracle. The way I finally did it in Oracle was a whole lot messier and I'm sure it's not the best way.



...

-- FORTRAN manual for Xerox Computers --
Jambu Krishnamurthy
Jambu Krishnamurthy
SSC Veteran
SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)

Group: General Forum Members
Points: 230 Visits: 98

Real nice article. It exactly mirrors reality. I worked

in Oracle 8i very extensively almost 5 years plus. from 95 to 2000 probably. After that for the last 5 years I am working on SQL Server. Now I have to get back to Oracle 10g for my new job.

same plight here.


Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search