Viewing 15 posts - 1,216 through 1,230 (of 3,060 total)
GSquared (1/20/2011)
_____________________________________
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 25, 2011 at 10:47 am
blackwell (1/23/2011)
I'm just getting started using MSS and wanted to know what exactly is the difference between a query and a view?
A view is nothing but a catalogued query 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 23, 2011 at 5:54 pm
single row sub query returns more than one column
mmmhhh... I think message says "more than one row", isn't it?
If that's the case, that's exaclty what it is happening -...
_____________________________________
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, 2011 at 2:56 pm
Resender (1/20/2011)
1)Working Oracle 11g R2 Enterprise on a SUSE Linux 11 SP1
2)Using SSIS to pump data from...
_____________________________________
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, 2011 at 2:52 pm
Gianluca Sartori (1/13/2011)
... SQL*Plus is the only tool to perform lots of tasks. Command line tools???? Come on, we're in 2011!!!
Let me start by saying that every single point 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 13, 2011 at 3:20 pm
varunkum (1/13/2011)
Guyz someone please hep me understand this sql above. I know the decode statement and addr&circ are databases. When i did
select * from addr.pk_dynreport.f_chk_omit
it said sql...
_____________________________________
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 13, 2011 at 3:05 pm
David Portas (1/12/2011)
PaulB-TheOneAndOnly (12/27/2010)
sawantpl@gmail.com (12/27/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 12, 2011 at 3:10 pm
Gianluca Sartori (1/10/2011)
Lynn Pettis (1/8/2011)
I am enjoying the opportunity to learn Oracle, but the more I work with it the more I'd like to come back to SQL Server.
Agreed. Fortunately...
_____________________________________
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 12, 2011 at 3:01 pm
Lynn Pettis (1/8/2011)
I have found many simularities between the two (SQL Server and Oracle) but also many differences.
This is because of these are two independent, totally different implementations of 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 9, 2011 at 9:53 am
Building on Danilo's answer - please remember SYSDATE() returns the date down to the "second" therefore if you want whole dates you have to truncate the date by including TRUNC()...
_____________________________________
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 9, 2011 at 9:47 am
veena.jokhakar (1/8/2011)
_____________________________________
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 8, 2011 at 7:08 pm
Resender (1/7/2011)
_____________________________________
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 8, 2011 at 12:38 pm
Resender (1/7/2011)
the best answer i can think off atm 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 7, 2011 at 7:48 am
Resender (1/5/2011)
i create one
create savepoint a1;
but if i want to rollback to it i'm getting the ora-01086 saying its not established...
_____________________________________
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 7, 2011 at 6:39 am
Resender (1/4/2011)
I used the enterprisemanager and created a user based on the oe user (in the hr examplke db) only the tabs are empty under this user
And the question is?
Please...
_____________________________________
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 4, 2011 at 6:48 am
Viewing 15 posts - 1,216 through 1,230 (of 3,060 total)