Moving into new territory...

Sander Rossel

Going from SQL Server to Oracle. Say goodbye to good tooling. Say goodbye to civilized (T-)SQL (I think the PL in PL/SQL means Oracle outsourced the language to some cheap Polish labor... (no offence to Polish people)). Say hello to steep learning curve. All in all I just miss SQL Server. Any "surviving Oracle for SQL Server devs" tips or guides? :sigh:

Visit my blog at Sander's bits - Writing the code you need. Or read my articles at my CodeProject profile.

Regards, Sander

CPallini

You might ask the oracle... :rolleyes:

Sander Rossel

They should've called it Miracle instead. It's a Miracle anyone can get work done with this crap ;p I'm sure it'll get better as I figure this out...

Visit my blog at Sander's bits - Writing the code you need. Or read my articles at my CodeProject profile.

Regards, Sander

OriginalGriff

Tips and guides[^] ;)

Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...

Brittle1618

Been using oracle at work since the last 7 months, and I feel satisfied. No idea about

I developed the database of my final year project in SQL server, it was pretty good. But haven't used SQL server on professional level yet. But yeah it's very difficult to search for the solution of oracle problems on internet, you rarely find anything except the hell lengthy and descriptive oracle documentation, which you just damn hate to read :sigh:

GuyThiebaut

I moved from SQL Server to Oracle for around 4 years and am back on SQL Server now. There are differences although the differences are not that big nowadays as SQL Server has come closer to Oracle. The hardest part for me was discovering that many Oracle developers tend to have a preference for non-ANSI joins. Get yourself a book on PL/SQL clicketty[^] and you should be fine.

“That which can be asserted without evidence, can be dismissed without evidence.”

― Christopher Hitchens

Stefto

aaaah! so thats what PL stands for!

#region(start signature) Life's like a nose, you've got to get out of it whats in it! \#endregion

Slacker007

I actually prefer Oracle to SQL Server, hands down. I just wish Oracle was able to integrate with Visual Studio at the same level SQL Server does. Anyhow, PL SQL is awesome stuff when done correctly, and used correctly. BTW, you can use Entity Framework with Oracle, you just need to install the Visual Studio tools for Oracle.

Marc Clifton

For years I used Oracle and SQL Server interchangeably, there are slight differences in certain things (like wildcard character), but otherwise, I really like Oracle. I strongly recommend Toad[^] for a decent tool to work with Oracle. Marc

Imperative to Functional Programming Succinctly Contributors Wanted for Higher Order Programming Project!

Lost User

+1 for Toad - invaluable !

PooperPig - Coming Soon

QuantumPlumber

If you use the unix command line, installing gqlplus will make your life easier. http://gqlplus.sourceforge.net/

Treading on the toes of giants . . .

Vivi Chellappa

Congratulations! You are talking job security well into your 80's!:rose:

Sander Rossel

Might as well do some COBOL then :laugh:

Visit my blog at Sander's bits - Writing the code you need. Or read my articles at my CodeProject profile.

Regards, Sander

Sander Rossel

I'm not doing anything Unix and I try to avoid command lines as much as possible on any OS ;)

Visit my blog at Sander's bits - Writing the code you need. Or read my articles at my CodeProject profile.

Regards, Sander

Sander Rossel

Yeah, I looked at Toad, but it's not cheap... My company has their own in-house editor of which they're very proud, so there's no way they're going to buy some external editor. I didn't like the in-house one though, so I downloaded the free Oracle SQL Developer[^] which is a step in the right direction :)

Visit my blog at Sander's bits - Writing the code you need. Or read my articles at my CodeProject profile.

Regards, Sander

Vivi Chellappa

But then you will not be stark raving mad! :laugh:

kmoorevs

Sorry, I have no advice but have read some of your articles. :thumbsup: I have no doubt you'll pick it up quickly! Great opportunity to broaden your skillset. Have fun! :)

"Go forth into the source" - Neal Morse

Sander Rossel

Thanks, that's awesome! :D It's pretty fun to see something beside SQL Server indeed. And Oracle will spice up the ol' resume :D

Visit my blog at Sander's bits - Writing the code you need. Or read my articles at my CodeProject profile.

Regards, Sander

Thornik

It's strange you worry about T-SQL/PL-SQL at all! It's atavism from 70-th. Nowadays application server does it much better, so on database side you leave just tables and SQL requests - they are "almost compatible" across all databases.

Sander Rossel

Yeah, but how to make the tables, procedures, etc. It's quite a difference. Oracle has procedures which can't return a result, only output parameters, while in SQL Server a procedure is like Oracle's procedure and function in one and SQL Servers function is quite different from the Oracle function... etc. etc. :) And I just found out Oracle doesn't know the bit/boolean type... :wtf: And while an application server might do it better a database will generally do it faster ;)

Visit my blog at Sander's bits - Writing the code you need. Or read my articles at my CodeProject profile.

Regards, Sander