254 reputation
19
bio website
location
age
visits member for 1 year, 8 months
seen Jun 15 at 20:06

Jun
8
comment How to perform same DML statements on two different servers (Oracle and SQL-Server) simultaneously
are you trying to do this from an application your're writing? or from some kind of client (like SSMS) that support both DBMSs?
Apr
2
comment how to correctly return values from a function
the error only happens when no match is found, so if i remove the exception handling, it returns null as value!!!
Apr
2
comment how to correctly return values from a function
how? the variable is already set to 'N', default value. edit: ok makes sense now i'll give it a try thanks
Mar
19
comment Stored Procedure with ROW instead of a list of parameters
thanks That's great, calling it i suppose would e as simple as referencing the rec.field := value ? and passing the rec to the stored proc? is that correct
Mar
18
comment date formatting in Oracle
that's cool, thanks for sharing
Mar
18
comment date formatting in Oracle
@Phil it is actually possible...see my answer below
Jan
29
comment how to change the default date format in oracle
problem's solved.
Jan
29
comment how to change the default date format in oracle
I think i got it, someone had the same issue posted on SOF: stackoverflow.com/questions/8134493/… Now what i would like to know if possible is how to drop tables whose names follow a certain pattern, let's say i have 100 tables with names using TT_TableName... i would like to find a command that will drop all of those table so i can start fresh, thanks
Nov
17
comment How to model entities in an entity relationship diagram?
Thank you sir for your time, and the explanations...thanks for your help, this is so far one of the most complete answers i've ever had on a forum/webiste !!!!!
Nov
16
comment Are there any tools to go from ERD to DB design and vice versa?
cool, what i'm looking for is a designer GUI style, like Visual Studio's in which you can add entities...