again? how many times are you planning to post the same question in different sections?

You have to use BEGIN DISTRIBUTED TRANSACTION - check BOL for details.

Define rules in a table, PK will be like (product, sequence) - you can include a row for "total" then enforce/implement via instead of triggers.

May be this is a job for INSTEAD OF TRIGGER, init?

Please do not cross post ... use "BEGIN DISTRIBUTED TRANSACTION" and check BOL for further details.

This is a distributed transaction so you have to initiate it by issuing "BEGIN DISTRIBUTED TRANSACTION" ... check BOL for details 😉

I've seen pretty similar business specifications.

Somebody asked to implement some "flexible field" alike functionality - "flexible fields" are an Oracle Applications feature.

Here is how it works.

You design your database in...

1- Create a temp table with columns matching the output of the desired storedproc.

2- insert into #YourTempTable exec sp_YourStoredProc

3- select from #YourTempTable as it fits you.

That would be ... your brain or better saying a properly trained brain 😉

:w00t: If you are...

Oracle to Oracle?

Why would you want to add overhead?

Use Oracle! 😉

Yes I did indeed. I also worked with 4.2 which was a source copy of Sybase.

I would say 6.0 was the first version with a Microsoft flavor on it.

No.

No.

Yes.

Having said that...

sjsubscribe (1/20/2010)

---

Certainly the current practice is mixed at best or else no DBMS would allow null values as valid entries in a field. That's what the relational theory purists wants....

Not totally sure if I got your question right but statement below will certainly point you in the right direction, log into sqlplus and execute...

select to_char(sysdate, 'mm/dd/yyyy hh24:mi:ss') from dual;

It all depends on...

David Portas (1/20/2010)Of course I agree. However in a scenario where the domain model does call for a 1-1 relationship then you cannot automatically assume that the "best" implementation is...