Viewing 15 posts - 16 through 30 (of 63 total)
I'd like to add my favourite SQL Server vs Oracle link.
Gints Plivna
http://www.gplivna.eu
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...
Gints Plivna
http://www.gplivna.eu
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...
Gints Plivna
http://www.gplivna.eu
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...
Gints Plivna
http://www.gplivna.eu
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...
Gints Plivna
http://www.gplivna.eu
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...
Gints Plivna
http://www.gplivna.eu
February 5, 2009 at 2:59 pm
Gift Peddie (2/5/2009)
Gints Plivna
http://www.gplivna.eu
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...
Gints Plivna
http://www.gplivna.eu
January 28, 2009 at 3:22 pm
Informix is dead, err I mean bought by IBM on 2001 😉
Gints Plivna
http://www.gplivna.eu
January 17, 2009 at 3:04 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 😉
Gints Plivna
http://www.gplivna.eu
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...
Gints Plivna
http://www.gplivna.eu
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...
Gints Plivna
http://www.gplivna.eu
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.
Gints Plivna
http://www.gplivna.eu
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...
Gints Plivna
http://www.gplivna.eu
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,...
Gints Plivna
http://www.gplivna.eu
November 4, 2008 at 9:32 am
Viewing 15 posts - 16 through 30 (of 63 total)