Viewing 15 posts - 16 through 30 (of 63 total)
I'd like to add my favourite SQL Server vs Oracle link.
February 11, 2009 at 12:42 pm
GSquared (2/10/2009)
If I were interviewing and found that the prospective employer expected me to use a command-line interface to the server as my only tool, I'd tell them the interview...
February 10, 2009 at 3:09 pm
I'm using 50:50 PL/SQL Developer and SQL*Plus. Actually I think these funky shmunky GUI tools on the one hand are good if they enhance one's productivity, but bad because usually...
February 10, 2009 at 2:45 pm
Bruce W Cassidy (2/10/2009)
[font="Verdana"]... especially if you factor in the cost of TOAD, which most Oracle shops seem to purchase. shudder[/font]
Hmm never could understand the problem with these tools...
February 10, 2009 at 2:17 pm
Bruce W Cassidy (2/8/2009)
Gift Peddie (2/8/2009)
I am not saying Oracle is better than SQL Server but I know it comes with row level security.
[font="Verdana"]Yeah. One of the features I...
February 8, 2009 at 4:27 pm
Gift Peddie (2/5/2009)
8i was released almost 2000 and 9i was released in 2001 while 10g was 2004/5.
Umm where you got these years?
According to both official history article and...
February 5, 2009 at 2:59 pm
Gift Peddie (2/5/2009)
February 5, 2009 at 1:43 pm
Some comments for various posts:
anyone else tried reading the Oracle documentation
I'm reading it almost every day I produce any code. tahiti.oracle.com then is my starting point and I've personally...
January 28, 2009 at 3:22 pm
If we are extending the subject so much I'd say that most probably everyone of these (List of database management systems) has some strengths 😉
January 16, 2009 at 9:24 am
Define best. For me best is Oracle because I've used it for more than 10 years and just a little bit looked in SQL Server. Oracle for me would most...
January 15, 2009 at 1:28 pm
I'd say that to get performant code one simply needs to understand what each proc does and rewrite it from scracth. Because especially if your SQL Server version was a...
December 26, 2008 at 2:30 pm
See here http://www.jlcomp.demon.co.uk/faq/dblink_commit.html and also discussion here http://www.freelists.org/post/oracle-l/Remote-Select-opening-transaction why even distributed queries start transaction.
December 5, 2008 at 7:11 am
You are quite strangely using "case" here I'd say that something like:
WHERE hist = 2 and (PERSON.DATE is null or PERSON.DATE is not null)
or (hist <> 2 and PERSON.DATE is...
December 4, 2008 at 2:53 pm
mtougui (11/4/2008)
The easiest way to convert rownum(oracle) to Oracle:select col1, col2, ....
from tableX
where
clauses
And rownum = 5
In SQL Server and every other dbms it is equivalent to
select col1, col2,...
November 4, 2008 at 9:32 am
Viewing 15 posts - 16 through 30 (of 63 total)