Viewing 15 posts - 2,206 through 2,220 (of 3,060 total)
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.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.January 22, 2010 at 6:27 am
May be this is a job for INSTEAD OF TRIGGER, init?
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.January 22, 2010 at 6:13 am
Please do not cross post ... use "BEGIN DISTRIBUTED TRANSACTION" and check BOL for further details.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.January 22, 2010 at 5:55 am
This is a distributed transaction so you have to initiate it by issuing "BEGIN DISTRIBUTED TRANSACTION" ... check BOL for details 😉
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.January 22, 2010 at 5:54 am
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...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.January 21, 2010 at 2:29 pm
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.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.January 21, 2010 at 9:44 am
checkitoutcouk (8/25/2009)
What's the best free database designer?
That would be ... your brain or better saying a properly trained brain 😉
checkitoutcouk (8/25/2009)
Is it worth paying for software?
:w00t: If you are...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.January 21, 2010 at 9:38 am
baal32 (3/21/2009)
Oracle to Oracle (10gR2) ETL
Oracle to Oracle?
Why would you want to add overhead?
Use Oracle! 😉
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.January 21, 2010 at 9:21 am
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.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.January 21, 2010 at 7:48 am
Is this a requirement
No.
or just a best practice?
No.
Can a Parent be joined to a Child table on a field that has not been defined as a Foreign Key?
Yes.
Having said that...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.January 21, 2010 at 5:54 am
sjsubscribe (1/20/2010)
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.January 21, 2010 at 5:42 am
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;
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.January 21, 2010 at 5:32 am
dbarr (1/20/2010)
At what point are there performance concerns with really large tables (# of columns) and a good many indexes (to avoid scans on popular criteria fields)?
It all depends on...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.January 20, 2010 at 9:32 am
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...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.January 20, 2010 at 8:10 am
David Portas (1/20/2010)
So your only answer to my question is to tell me that I'm not asking the right question. Right...
No David, it's not the questions, it is the...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.January 20, 2010 at 7:39 am
Viewing 15 posts - 2,206 through 2,220 (of 3,060 total)