Haypp Christmas,

From job perspective it is probably a benefit knowing more than 1 database. SQL Server is easier to administer as it comes with various tools to do so (and...

Good point. Virtualization has many benefits: easy migration, lab testing, flexible in hardware resource, not so dependent on hardware-age

My mayor gripe with virtualization is the licensing model some software vendors...

Thanks for sharing the workaround

I've found an older reference of the problem. You might check the creation script on mixed case.

reference

Otherwise try to setup a trace on the oracleside to see what sql server...

I'm not familiar with crossdatabaseplatform replication. What ora-... error do you get?

Surely there is the need for some thinking time. Many hours of sleep lost when the brain decides to rehearse a memorable problem instead of snoozing.

Could you use code tags?

AND"+

"z.usernameman

concatenates to andz.usernameman which is invalid

Trying to generate dynamic sql?

Also have a look at Quest for SSC alike oracle forums

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...

Also the oracleversion of the backend is important as msdaora is discontinued, you better use the oracle-driver from oracle (from oracle 10 on)

impdp/expdp doesn't exist in oracle 9? Imp/exp does

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...

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...

1. Instead of saving to ms acces, have msaccess link your tables

2. Have a look at replication (some tables)/mirroring (whole database)

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....