Reputation
4,635
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
9 42 90
Impact
~530k people reached

  • 0 posts edited
  • 6 helpful flags
  • 841 votes cast
Jan
9
comment How does the Oracle DUAL table work?
We once even succeeded in creating our own DUAL table shading the oracles DUAL table and were able to insert and fetch more than one row from it.
Jan
9
comment What is the significance of a semicolon at the end of SQL*Plus commands?
+1 To make things more confusing, you can use / on the following line instead of the ; in some cases.
Jan
8
comment Performance implications of MySQL VARCHAR sizes
+1 this question applies similar to all DBMS. My observation many varchar sizes tend to grow.
Jan
7
comment What can I do to find out since which release a given DBMS supports a feature, function, etc?
Thanks. That's the kind of presentation I'm looking for. Only my focus is SQL-Server and Oracle.
Jan
7
comment What can I do to find out since which release a given DBMS supports a feature, function, etc?
Thanks. I just tried it successful on some SQL-Server functions.
Jan
6
comment Can I change the SID of an Oracle database?
No I work as DBA for the develop and some test Oracle databases.
Jan
5
comment Feature comparison: Oracle Database and Microsoft SQL Server
Best we can collect some or many links to such comparisons.
Jan
4
comment What is an effective way of labeling columns in a database?
@joe never noticed that Oracle is different. Can you give a link?