(new) Databases

OSS alternatives to MS Access - (orion) - (6) - Aug. 12, 2004, 09:37:13 PM EDT

MySQL is a good alternative to M$Access - (ChrisR) - (5) - Aug. 12, 2004, 09:44:39 PM EDT

I'm too lazy to look. - (mmoffitt) - (2) - Aug. 12, 2004, 10:15:23 PM EDT

Yes - (ben_tilly) - (1) - Aug. 12, 2004, 11:10:57 PM EDT

Thanks. -NT - (mmoffitt) - Aug. 13, 2004, 09:36:32 AM EDT

I am hoping to help... - (folkert) - (1) - Aug. 12, 2004, 10:55:13 PM EDT

Prolly not PG8. - (admin) - Aug. 12, 2004, 11:46:29 PM EDT

Display Packages in SQL*Plus? - (tablizer) - (6) - Aug. 11, 2004, 04:12:32 PM EDT

Could probably use some variation of USER_SOURCE view - (ChrisR) - (5) - Aug. 11, 2004, 04:40:19 PM EDT

That's what we do here. -NT - (admin) - Aug. 11, 2004, 05:01:59 PM EDT

Re: Could probably use some variation of USER_SOURCE view - (tablizer) - (3) - Aug. 11, 2004, 07:36:13 PM EDT

how about DBA_SOURCE? - (ChrisR) - (2) - Aug. 11, 2004, 09:37:08 PM EDT

or ALL_SOURCE? -NT - (ChrisR) - (1) - Aug. 11, 2004, 09:39:11 PM EDT

So far the most promising. Thanx -NT - (tablizer) - Aug. 12, 2004, 12:28:04 PM EDT

DB2/400 or DB2/iSeries question. - (mmoffitt) - (4) - Aug. 10, 2004, 11:51:44 AM EDT

Re: DB2/400 or DB2/iSeries question. - (deSitter) - (3) - Aug. 10, 2004, 12:03:59 PM EDT

Aren't GLOBAL TEMPORARY tables viewable to all connections? - (mmoffitt) - (2) - Aug. 10, 2004, 01:00:27 PM EDT

The answer is NO. DB2/400 doesn't scope temp tables to sp's. -NT - (mmoffitt) - (1) - Dec. 21, 2004, 02:07:06 PM EST

Are they session/user scoped? -NT - (ChrisR) - Dec. 21, 2004, 02:09:19 PM EST

risky use of Oracle SYSDATE? - (tablizer) - (11) - Aug. 4, 2004, 07:45:50 PM EDT

Hmm. Order of evaluation - (broomberg) - Aug. 4, 2004, 08:15:43 PM EDT

If only the date matters... - (admin) - (5) - Aug. 4, 2004, 09:31:53 PM EDT

Still could cross over -NT - (broomberg) - (4) - Aug. 4, 2004, 10:27:10 PM EDT

Unless you change the logic - (admin) - (3) - Aug. 4, 2004, 11:10:14 PM EDT

sysdate wrapper - nice touch - (broomberg) - (1) - Aug. 5, 2004, 12:03:50 AM EDT

Guideline doc for DML wrappers: - (admin) - Aug. 5, 2004, 12:06:53 AM EDT

Re: Unless you change the logic - (tablizer) - Aug. 7, 2004, 05:14:31 AM EDT

Another thought - (admin) - Aug. 4, 2004, 11:25:22 PM EDT

It would surprise me if the SYSDATE wasn't in a closure - (ChrisR) - (2) - Aug. 4, 2004, 11:39:40 PM EDT

Brief testing says this might be correct. - (admin) - (1) - Aug. 5, 2004, 12:01:23 AM EDT

FWIW - (ChrisR) - Aug. 5, 2004, 12:35:23 AM EDT

OpenLdap tuning - (bluke) - July 28, 2004, 09:11:40 AM EDT

Favorite Oracle profiling/SQL tuning tools? - (admin) - (4) - June 24, 2004, 02:51:46 PM EDT

Our favourite technique - (Meerkat) - June 24, 2004, 05:53:53 PM EDT

Ribbit! - (CRConrad) - (2) - July 12, 2004, 09:09:37 AM EDT

no longer free -NT - (boxley) - (1) - July 12, 2004, 09:18:32 AM EDT

Not a problem, he said. -NT - (CRConrad) - July 13, 2004, 02:20:22 AM EDT

Anyone used object views in Oracle? -NT - (admin) - (1) - June 22, 2004, 06:13:19 PM EDT

Not I, sorry. -NT - (Meerkat) - June 22, 2004, 10:10:58 PM EDT

Why would a database insert take >40 seconds? - (drewk) - (7) - June 19, 2004, 03:14:14 AM EDT

No idea, just a wild guess - (Meerkat) - (1) - June 19, 2004, 11:44:39 AM EDT

Full table scan is faster - (drewk) - June 19, 2004, 01:59:38 PM EDT

Are there indexes on other columns? - (ben_tilly) - (4) - June 19, 2004, 03:39:54 PM EDT

Here's the table - (drewk) - (3) - June 21, 2004, 10:10:54 AM EDT

What are the indexes though? -NT - (admin) - (2) - June 21, 2004, 10:20:35 AM EDT

Called KEY in mysql - (drewk) - (1) - June 21, 2004, 10:41:58 AM EDT

Oh, heh. Never mind. - (admin) - June 21, 2004, 11:00:21 AM EDT

Oracle: An inverse of the TRANSLATE function? - (Meerkat) - (10) - May 6, 2004, 01:14:17 AM EDT

No, seems to be exactly what Oracle recommends for that task - (CRConrad) - (2) - May 6, 2004, 07:38:17 AM EDT

Wrong attitude - (ben_tilly) - (1) - May 6, 2004, 11:34:59 AM EDT

Trouble is, the process doesn't crash, - (Meerkat) - May 6, 2004, 05:02:49 PM EDT

OK, here's the "foolproof-but-fugly" solution: - (CRConrad) - (2) - May 7, 2004, 04:14:18 AM EDT

Believe me I came close to writing something similar - (Meerkat) - May 7, 2004, 04:16:30 AM EDT

*shudder* -NT - (folkert) - May 7, 2004, 11:17:18 AM EDT

What version of Oracle? - (broomberg) - (3) - May 20, 2004, 01:35:58 PM EDT

That's cool - (ben_tilly) - May 20, 2004, 08:03:02 PM EDT

Gah. - (admin) - May 20, 2004, 08:04:48 PM EDT

Well spotted! - (Meerkat) - May 21, 2004, 03:01:36 AM EDT

T-SQL to T-SQL Conversion - (ChrisR) - (13) - May 2, 2004, 03:17:27 PM EDT

Guesses on #1 - (FuManChu) - (3) - May 2, 2004, 03:47:32 PM EDT

Sorry, I should have put in the aliasing for you: - (FuManChu) - (2) - May 2, 2004, 03:51:03 PM EDT

The subquery will work - (ChrisR) - (1) - May 2, 2004, 10:35:50 PM EDT

futzing around some more - (ChrisR) - May 2, 2004, 11:33:09 PM EDT

OT and completely beyond the scope - (drewk) - (7) - May 2, 2004, 04:05:46 PM EDT

Scott's the one that pointed me in the Sybase direction - (ChrisR) - (6) - May 2, 2004, 10:39:53 PM EDT

Cool, and a question - (drewk) - (1) - May 3, 2004, 07:30:11 AM EDT

Spelling impaired - (ChrisR) - May 3, 2004, 10:36:09 AM EDT

Parent/child IDs - (admin) - (3) - May 3, 2004, 08:34:43 AM EDT

When would that be? - (drewk) - (2) - May 3, 2004, 08:53:29 AM EDT

That's a big one. - (admin) - (1) - May 3, 2004, 09:08:24 AM EDT

OK, but why not ... - (drewk) - May 3, 2004, 09:12:48 AM EDT

Answer on the Sybase equivalent of REPLACE - (ChrisR) - June 11, 2004, 01:21:07 AM EDT

Welcome to IWETHEY!