IWETHEY v. 0.3.0
|
TODO
1,095 registered users | 0
active users
| 0 LpH |
Statistics
Login
|
Create New User
Welcome to IWETHEY!
IWETHEY Home
/
IWETHEY Board
/
Databases Forum
Now viewing page 10 of 25
[
Prev
]
1
...
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
...
25
[
Next
]
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
Now viewing page 10 of 25
[
Prev
]
1
...
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
...
25
[
Next
]
i
we
they
.org
...and the President was unfortunately subjected to public opinion.
505 ms