@Dagon:
you don't need a co-worker?
I hope your at least overpayed when underused!
btw: Your last suggestion is what i was looking for. Gonna implement it now and re-write the other PL/SQL blocks i did wrong...
Until then: thank you Dagon and Hoinz! This Problem is solved.
Maybe i come back...
@Dagon:
Ohh, you were was faster then me!
;-(
I will take a look at your suggestion and then reply later.
so much to do besides programming in this (nearly-)one-man-it-department, that an answer lasts half an hour to write/submit
;-)
cu
Hello dagon, hello hoinz,
thank you for your fast reply!
I think you convinced me of the trunc function. But i don't get the right effect.
when i use
TRUNC(TO_DATE(:P18_TERMVON, 'DD/MM/YYYY HH24:MI'))
i get
25.09.2006
but when i combine this truncated date with a substr of a varchar...
Hello and good morning all together!
We are running an oracle 10g DB with Application Express (APEX, formerly HTMLdb).
I'm trying to create a little PL/SQL block that writes a sequence of dates into a table.
In this PL/SQL block i have an user variable :P18_TERMVON
the input for this variable...
Hi Solo,
if i did get you right, this could be what you're looking for:
SELECT JCJOBCAT.JCAT_PHS_CODE,
JCJOBHPHS.JHP_NAME,
sum(jc_o.jcdt_amt) o_sum,
sum(jc_c.jcdt_amt) c_sum,
SUM(DISTINCT JCJOBCAT.JCAT_BUDG_AMT) AS EXPR1,
SUM(JCDETAIL.JCDT_AMT) AS EXPR2
FROM...
Thank you all...
Installed SP2,
installed correct drivers,
uninstalled card,
reinstalled card,
--> The machines run like hell....
Yeah
Greetz from Germany, till next time....
Hi Jennifer
Nope. Installed W2K pro and after that i installed SP3!
But thx for that suggestion, will try it!
SatanClaus
(also 1/2 of the IT Staff ;-))
Hi wolluf,
I will look into the event viewer, and yes uninstalled the display adapter and let it reinstall by windows.
Another hint: i put a pci display adapter in, and it worked. But this can´t be the solution: To replace a proper working display adapter with a proper working display adapter...
@rathcoffey: Have the latest drivers installed (hope so)!
@wolluff: yeah, i open display properties, and the moment i click the setting tab, the system crashes. Not earlier, not later! And that´s with three machines!
So, anyone knows?
thx,
SatanClaus
P.S.: I´m sorry about my disguisting english.
We are installing W2K on all PCs in our company. (About 40 machines).
Now we have huge problems with some machines (all nearly the same conf.):
Celeron 333 up to P2 400,
all ATI Rage Pro onboard,
64 up to 128 MB RAM
Prob:
After install(W2k/SP3/Novell Client/NovellSP and so on, all configured...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.