Viewing 15 posts - 1,096 through 1,110 (of 3,061 total)
Arthur.Lorenzini (4/29/2011)
Exit message: ...
April 29, 2011 at 1:55 pm
green8814 (3/4/2011)
2) Make sure the tnsnames.ora file is configured properly on the server that needs to connect to Oracle.
Actually, if you are tnspinging from a client you have to make...
April 29, 2011 at 1:46 pm
sherwincurt (4/18/2011)
We have Oracle installed on Server.
There are 2 OS running in the 2 network lines namely XP,and Linux.
Is it possible to access Oracle form both the OS ?...
April 29, 2011 at 1:27 pm
Welsh Corgi (4/28/2011)A Procedure would In include DECLARE PROCEDURE MyProc
I'm sure you mean "create or replace procedure MyProc as..."
Having said that, script I shared earlier runs in sqlplus as...
April 29, 2011 at 10:59 am
Building on Welsh's post, block on sqlplus should look like..
set serverout on
declare mydate date;
begin
select max(CreateDate) into mydate from tbl1;
-- do whateve you have to do with variable mydate --
end;
/
Please note,...
April 28, 2011 at 2:26 pm
Welcome to the wonderful world of data modeling.
The short answer is: there is not silver bullet, it all depends on your business requirements and the way you decide to implement...
April 26, 2011 at 4:40 pm
RonKyle (4/19/2011)
* leave them NULL (could cause issues in reports)
I don't recommend this. All dimension keys should have some value. Implement the third suggestion in the above post....
April 26, 2011 at 1:46 pm
David Portas (4/26/2011)
Welsh Corgi (4/23/2011)
The definition of the following terms are as follows:
Data Warehouse: They use a Dimensial Data Model...
April 26, 2011 at 1:26 pm
Most likelly a privileges issue.
Log as "sa" and re-run query, if it returns what you expect the concentrate on assigned and missing privileges.
April 26, 2011 at 8:24 am
Well... post title appears to have no relationship with actual issue - is that correct?
Usually the devil is in the details, in this case appears to be in the filtering...
April 24, 2011 at 3:57 pm
SethT3 (3/11/2010)
The database was an Oracle database converted to SQL Server
It appears to be the case of a half-cooked conversion - nothing more, nothing less.
April 24, 2011 at 3:36 pm
Satnam Singh (4/24/2011)
Also what are the pre-requisites for the same, i believe seperate...
April 24, 2011 at 1:37 pm
sherwincurt (4/21/2011)
Hello can any one tell me waht is mean by Dataware House, Data mining and OLAP?
Fully answering this question may require not least than the full content of four...
April 23, 2011 at 5:24 pm
Welsh Corgi (4/23/2011)
As far as I know two Phase locking does not exist in SQL Server but it does exist in Oracle.
2PL is actually just a conceptual description of the...
April 23, 2011 at 5:09 pm
nirav.gandhi 50053 (4/23/2011)
Which Conditions File And FileGroup are Useful for Our database Optimizations?
It would also be nice to know what "optimizations" means in this particular scenario - assuming poster wants...
April 23, 2011 at 4:54 pm
Viewing 15 posts - 1,096 through 1,110 (of 3,061 total)