1,842 reputation
730
bio website
location Ottawa.Ontario, Canada
age 55
visits member for 3 years, 2 months
seen 7 hours ago

Oracle DBA and programmer with 10 years experience maintaining mission-critical applications. Lots of PL/SQL, C# and the usual glue, vbscript, DOS


Sep
13
comment Can this business logic be enforced by a conditional database constraint?
Thank you, a great answer that I will be able to use for other "rules", just not this one.
Sep
13
comment Can this business logic be enforced by a conditional database constraint?
Unfortunately not. A case stage can have one or more recommendations at multiple stages. There can be zero to many stages with CASE_STAGE.STAGE_ID=1646
Sep
13
revised Can this business logic be enforced by a conditional database constraint?
added for clarity
Sep
13
asked Can this business logic be enforced by a conditional database constraint?
Sep
13
answered How can I ensure that only one copy of a procedure is running in Oracle?
Sep
13
answered How do I use the IF…ELSE condition in a WHERE clause?
Sep
12
revised How to I interleave logs from two different Oracle tables?
updated after a helpful comment
Sep
11
revised How to I interleave logs from two different Oracle tables?
added 459 characters in body
Sep
11
revised How to I interleave logs from two different Oracle tables?
added 4 characters in body
Sep
11
answered How to I interleave logs from two different Oracle tables?
Jul
24
answered Oracle database link to MySQL database on RedHat Linux
Jul
24
comment ORA-00379 no free buffers
You could tell us what version of Oracle you are using and what DB_BLOCK_BUFFERS is set to. That would help.
Jul
16
revised Ora - 00088 error: command cannot be executed by shared server
added 81 characters in body
Jul
16
answered Ora - 00088 error: command cannot be executed by shared server
Jul
16
answered Unable to restore database in Oracle 10g
Jul
16
awarded  Yearling
Jul
12
answered How to take oracle 10g backup?
Jul
10
awarded  Excavator
Jul
10
revised Oracle 11g setup closes without errors on pre-requisite check
spelling of pre requisite
Jul
10
suggested suggested edit on Oracle 11g setup closes without errors on pre-requisite check