Viewing 15 posts - 856 through 870 (of 2,044 total)
A point for keeping the modified always filled in >=created date is that your index search on "created or modified within the last 24 hours" works faster (only checking on...
November 28, 2011 at 11:43 am
Also the oracleversion of the backend is important as msdaora is discontinued, you better use the oracle-driver from oracle (from oracle 10 on)
November 28, 2011 at 11:34 am
impdp/expdp doesn't exist in oracle 9? Imp/exp does
November 26, 2011 at 7:25 pm
I've converted the right-join in a left join (as they are rewritable),didn't feel like reordening my whole query.
Easiest is to remember (+) means: if not found add a null...
November 18, 2011 at 5:40 am
Try
X.abc=Y.abc(+) (side with nulls) => X LEFT JOIN Y ON X.ABC=Y.ABC
X.abc(+)=Y.abc => X RIGHT JOIN Y ON X.ABC.Y.ABC
SELECT count(*)
FROM employee_master e
INNER JOIN client_master cl
ON e.rm_code=cl.rm_code
INNER JOIN branch_master b
ON...
November 17, 2011 at 7:25 am
1. Instead of saving to ms acces, have msaccess link your tables
2. Have a look at replication (some tables)/mirroring (whole database)
October 31, 2011 at 3:14 am
Be sure to question the questioner.
I suppose when the game starts, the player sees 4 pictures (giftboxes?). One of the closed boxes contains the mouse, another one the stop-sign....
October 27, 2011 at 7:42 am
SQL2000 SP4 (till the hardware breaks, no DTS), SQL2005 & SQL2008 (not yet R2). All standard or express editions. Next to Oracle 9 and 10.
October 21, 2011 at 5:51 am
I'm back to one screen (1920x1200 19") on my laptop till windows rearranges/remembers the windows when the extra monitor is missing/reattached (perhaps winsplit revolution could help).
With windows 7 you...
October 14, 2011 at 9:14 am
Seems it is a multivalued field relating to more records. Have a look at
where they mention add/saving/removing attachments in vba.
October 5, 2011 at 3:22 am
October 5, 2011 at 3:02 am
Have the default database login for the user changed to their database? Unless they set it in their connection setting.
September 23, 2011 at 12:28 pm
I could be that the oracle 11 client is limited to Oracle 9.
*
Have to find my oracle support login as it is on metalink
September 21, 2011 at 1:48 pm
not sure if there were servicenames in 7.2, it is probably a SID.
What are the results of oracle basic connectivity testing?
in command prompt:
tnsping myoldandtrusty
->shows location of the oracle tnsnames.ora location
->tries...
September 21, 2011 at 1:30 pm
ALZDBA (9/18/2011)
SQLRNNR (9/18/2011)
ALZDBA (9/18/2011)
Lynn Pettis (9/18/2011)
bitbucket-25253 (9/17/2011)
Ninja's_RGR'us (9/17/2011)
Now all I know about...
September 19, 2011 at 4:33 am
Viewing 15 posts - 856 through 870 (of 2,044 total)