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

Jul
9
awarded  Popular Question
Jul
3
awarded  Yearling
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?
Jun
4
awarded  Editor
Jun
4
awarded  Custodian
May
16
answered How to update information of the data of column in the table matching the certain text?
May
1
answered Data Modeling for different roles
Apr
9
answered MySQL vs. Microsoft Access
Apr
3
answered How to handle table design with variable columns
Apr
2
accepted how to correctly return values from a function
Apr
2
awarded  Commentator
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
Apr
2
asked how to correctly return values from a function
Mar
24
answered PL/SQL cursors and records
Mar
21
accepted date formatting in Oracle
Mar
19
accepted Stored Procedure with ROW instead of a list of parameters
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
19
asked Stored Procedure with ROW instead of a list of parameters
Mar
18
comment date formatting in Oracle
that's cool, thanks for sharing