Viewing 15 posts - 61 through 75 (of 164 total)
Nice to know! Note that you will face the same error again if, for example the value in the field 'qty'is '1234567890'. You need to define the scale and precisoin...
November 8, 2008 at 3:16 am
Question 2.
I need to do what in TSQL we would call an "update from", but with derived tables, joins, etc. Sort of like this ;
Update table1
set col1 = x.colx,...
September 13, 2008 at 7:34 am
In fact what I used is traditional join which is supported in MS SQL Server also while the one provided by Jitendra is ANSI Join which is used in other...
September 8, 2008 at 1:37 pm
Step1: Create Table2 with columns Employeeid, Col1
Step2: insert into Table 2 values (123, 'abc1')
insert into Table 2 values (124, 'abc2')
...
September 8, 2008 at 4:48 am
Same topic is discussed here
http://www.sqlservercentral.com/Forums/Topic533065-1042-1.aspx#bm533104
Regarding Unix, there is no difference in procedures whether the Oracle instance is on Unix or windows. You are dealing with the Oracle database only not...
September 1, 2008 at 5:11 pm
Also check and modufy the 'Collation' property of the new table that you have added.
August 31, 2008 at 6:38 am
This is because your Excel data seems to include Unicode character.
You need to change the DefaultCodePage in your SSIS package DataFlowTask objects properties.
By default, the Code Page will be 1252,...
August 31, 2008 at 6:06 am
Pure BS 😀
Not in that league yet Paul. May be your most junior guy could qualify for it :). By the way, a developer is most akin to the...
August 29, 2008 at 6:48 am
gints.plivna (8/28/2008)
Yeahhh, then probably the problem is in terms. I won't call it backup and I won't call it restore.
PaulB (8/28/2008)
What you are doing with exp/imp is data transfer which...
August 29, 2008 at 3:50 am
Boomer!... how about my 154BC records comming from my twin servers in Nikaia and Antipolis?
It would be interesting to know why it was required to store these prehistoric dates...
August 28, 2008 at 1:04 pm
Yeahhh I'm not true DBA, more developer but even I know that RMAN is the way to go today.
And BTW RMAN is quite old product and has approved itself many...
August 27, 2008 at 5:36 pm
Of course the real problem is in the application. An ORDER_CREATE date cannot have happened 250 years ago! The application should not be allowing these dates but...
In your...
August 27, 2008 at 4:39 pm
Yes you are right. But it is surprising that LAST_UPDATED_DATE is not a Date field.
August 27, 2008 at 6:33 am
Try Microsoft OLEDB Provider for Oracle
August 27, 2008 at 2:46 am
Viewing 15 posts - 61 through 75 (of 164 total)