144 reputation
6
bio website
location
age
visits member for 1 year, 5 months
seen yesterday

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
Mar
18
awarded  Self-Learner
Mar
18
awarded  Teacher
Mar
18
comment date formatting in Oracle
@Phil it is actually possible...see my answer below
Mar
18
answered date formatting in Oracle
Mar
18
asked date formatting in Oracle
Jan
29
comment how to change the default date format in oracle
problem's solved.
Jan
29
accepted how to change the default date format in oracle