Viewing 15 posts - 1,381 through 1,395 (of 3,060 total)
Lynn Pettis (10/20/2010)
For those watching this forum for Oracle questions, I have one here.
Please check original thread
_____________________________________
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.October 20, 2010 at 12:48 pm
Lynn Pettis (10/20/2010)
In stepping through the stored proc we were unable to get the procedure to create a...
_____________________________________
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.October 20, 2010 at 12:48 pm
Simon D (10/20/2010)
It adds a bit of complexity, but it's also a layer of insulation against accidental deletes with cascading effects.
Thanks very much for your input -...
_____________________________________
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.October 20, 2010 at 8:28 am
Simon D (10/20/2010)
A workaround would be to "disable" instead of "delete" WebAccountID
I'm very intrigued by this option. How would I disable the WebAccountID in the WebLogin table? Can you provide...
_____________________________________
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.October 20, 2010 at 8:11 am
gints.plivna (10/20/2010)
TOP also is SQL Server specific construction and not allowed in Oracle.
Good catch.
Poster also wants to replace "dbo" table prefix by whatever schema-name owns the affected tables.
_____________________________________
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.October 20, 2010 at 7:56 am
Simon D (10/20/2010)
I am in the process of building a database for a...
_____________________________________
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.October 20, 2010 at 7:52 am
Jo Pattyn (10/20/2010)
I'm slowly updating my skills from 2000 to sql server 2008, mostly administration. (user, security, backup/restore)Do you have some reading/lecture/course?
The easier way would be to check Microsoft KB...
_____________________________________
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.October 20, 2010 at 7:13 am
LutzM (10/16/2010)
Before going any further I'd like to know the true reason why you don't use the simple DELETE statement.
Well... imagine we are in the year 2030 and Microsoft...
_____________________________________
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.October 19, 2010 at 7:56 pm
A.J. Wilbur (10/19/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.October 19, 2010 at 7:46 pm
SQLTestUser (10/19/2010)
can you please direct me to where i can find an example
Bing: PL/SQL BLOCK INSERT 🙂
_____________________________________
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.October 19, 2010 at 9:24 am
chakrapanishroff (10/19/2010)
,Qty,Profit,DD.dDate, (SELECT TOP 1 ISNULL(S.Qty,0) FROM dbo.Stock S , dbo.DateDimension DD1 WHERE S.DateKeyID = DD1.DateKeyID AND S.ProductKeyID = SF.ProductKeyID AND DD1.dDate <= DD.dDate
ORDER BY...
_____________________________________
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.October 19, 2010 at 8:38 am
SQLTestUser (10/18/2010)
can a simple block do it as well rather than a procedure ?
Yes.
_____________________________________
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.October 19, 2010 at 6:15 am
WayneS (10/16/2010)
Lynn Pettis (10/15/2010)
PaulB-TheOneAndOnly (10/15/2010)
nick.mcdermaid (10/14/2010)
-Variables which 'reflect' existing table meta data
-Custom data types
-Multiple 'methods' within the package...
_____________________________________
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.October 18, 2010 at 5:26 pm
BowieRules! (10/18/2010)
Where is CHAR datatype? 🙂
Okay... this is going too far.
Would you agree RDBMS engine is the one who runs the show?
SQL> create table test(col1 char(10) not null);
Table created.
SQL> insert...
_____________________________________
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.October 18, 2010 at 12:42 pm
SQL>
SQL> set serveroutput on
SQL> declare
2 XXX varchar2(10);
3 MSG varchar2(50);
4 begin
5 XXX := '';
6 select decode(XXX,NULL,'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.October 18, 2010 at 12:01 pm
Viewing 15 posts - 1,381 through 1,395 (of 3,060 total)