124 reputation
3
bio website
location Prague, Czech Republic
age 34
visits member for 3 years, 5 months
seen Dec 10 '13 at 17:34

Mar
2
comment Database Design - different objects with shared tagging
It looks like you don't have the most important question answered - How will be data accessed? - For which queries/statements do you want to "tune" your model? - How do you plan to expand the functionality? I think that there is no general best practice - solution deppends on answers of these questions. And it starts to matter even in the simple models like this one. Or you may end up with model that follows some higher principles but really sucks in the most important scenarios - those seen by users of the system.
Feb
23
answered Table Statistics Affect Index Only Query?
Feb
23
comment Understanding the time difference between data grid initial display and export/full display using Toad for Oracle
Looks like the execution plan of your query is not quite optimal. Please provide more info. Run this first: explain plan for <your query>; select * from table(dbms_xplan.display); And paste results here.
May
14
comment Alternatives to concatenating strings or going procedural to prevent SQL query code repetition?
Instead of SELECT rownum MyRow FROM test_attribs where rownum<=5 use select level MyRow from dual connect by level <= 5. You do not want all those logical gets just for creating 5 rows.
Apr
21
answered Can Oracle row-level security work with user session credentials?
Apr
16
comment How to connect to a remote Oracle server from Windows machine using PL/SQL Developer?
@Marek: There is standalone client installation. Oracle Database 11g Release 2 Client (11.2.0.1.0) for Microsoft Windows (32-bit) - otn.oracle.com. During "Seclect Installation Type" choose "Administrator" and that's it. You can download/install/try anything from OTN, just make sure that you have correct license when go production.
Apr
7
awarded  Supporter
Mar
23
awarded  Teacher
Mar
23
answered Resources for SQL Server developer migrating to Oracle
Feb
18
awarded  Editor
Feb
18
comment Eliminate duplicates in ListAgg (Oracle)
Sorry for that, I have pasted some older and incorrect version.
Feb
18
revised Eliminate duplicates in ListAgg (Oracle)
added 7 characters in body
Feb
9
answered Eliminate duplicates in ListAgg (Oracle)
Feb
7
answered How can I import the contents of an Oracle database into Visio to create an Entity Relationship Diagram?