I run redhat linux 7 on the same machine and I know which one I prefer and
it ain't Windows. The only problems I have had with linux is me! Being new
to the whole unix/linux setup, adminny type role, I've had to take it slowly
and try to learn about everything from setting up printers to securing
Thankyou Jared.
-Original Message-
Sent: Monday, August 20, 2001 9:55 AM
To: [EMAIL PROTECTED]; Amar Kumar Padhi
On Sunday 19 August 2001 21:50, Amar Kumar Padhi wrote:
> Hi,
> The need is to remove all spaces from a provided string, but if a space
> exists between two numbers, then it
Thankyou Jared.
-Original Message-
Sent: Monday, August 20, 2001 10:57 AM
To: Multiple recipients of list ORACLE-L
On Sunday 19 August 2001 21:50, Amar Kumar Padhi wrote:
> Hi,
> The need is to remove all spaces from a provided string, but if a space
> exists between two numbers, then
On Sunday 19 August 2001 21:50, Amar Kumar Padhi wrote:
> Hi,
> The need is to remove all spaces from a provided string, but if a space
> exists between two numbers, then it should not be removed. Look at the
> following examples.
>
>original string output required
> XT GB 100 XF 100
Perl, definitely.
The ActiveState build of Perl comes with a number of Win32 modules,
and in addition, Dave Roth has written some add't Win32 modules that
you can't live without on Win32.
www.activestate.com
www.roth.net
Jared
On Sunday 19 August 2001 14:15, Koivu, Lisa wrote:
> Bonjour,
>
>
Hi List,
I need an help on sql query, have a table with the following data
OID INTEREST
-- --
100 1
100 2
100 3
100 4
I want the output to be displayed as
OID INTEREST
1001,2,3,
Hi,
The need is to remove all spaces from a provided string, but if a space
exists between two numbers, then it should not be removed. Look at the
following examples.
original string output required
XT GB 100 XF 100 XTGB100XF100
XT GB 123 X F 123 XTGB123XF123
Hi all,
Can I install Oracle into my PC (no LAN but Internet)
withAMD CPU 1.x GHz
512 MB RAM
with Solaris 8 or
FreeBSD or
Linux or
W2K or Win ME (I prefer the above 3)
What is your recomendation ?
Thank you
Best Regards
Sinardy
--
Please see the official OR
Hello,
The sql_text that is there in v$sqltext is only 1000 chars wide, where as the text
field in dba_source is 4000 chars. long. How do I get the text from dba_source, as I
am not able to join that table with any other suitable table.
Any help/comments?
rgds,
raja
--
On Sun, 19 Aug 2001 1
To find currently running sql, run the following query:
SELECT a.username AS username
, a.sid AS sid
, a.serial# AS ser#
, b.sql_text AS statement
FROM v$session a
, v$sqltext b
WHERE a.username IS NOT NULL
AND a.status = 'ACTIVE'
AND a.sql_address =
The link didn't past as it should have.
www.vampired.net/lotr.html
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 8/19/01 5:40 PM
I had to look! Some kick ass scenary, this should be a delightful
flick.
Don't go to link unless you don't mind being teased.
--
Plea
Hi, all
How to find the currently running transaction,
including user, sql_text, etc?
Do you have any scripts for monitoring, tuning
transactions?
Thank you!
Janet
__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo
> "Koivu, Lisa" wrote:
>
> Bonjour,
>
> I've been digging around for scripting documentation on w2k.
> Microsoft's website talks about Jscript and vbscript and xml - none of
> which are my strengths and all look like they are much more
> complicated than I need. I need to find a scripting langu
Christopher Spence wrote:
>
> Ebay uses windows for everything now.
>
> They used to have Sun with Oracle and NT front end.
> Now they are completely 2000.
>
> Hmm, no outages lately on ebay, yet there were many outages while running
> Sun. I KNOW Sun is more stable, perhaps it is other reaso
I had to look! Some kick ass scenary, this should be a delightful flick.
Don't go to link unless you don't mind being teased.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Christopher Spence
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051
Title: w2k scripting
Bonjour,
I've been digging around for scripting documentation on w2k. Microsoft's website talks about Jscript and vbscript and xml - none of which are my strengths and all look like they are much more complicated than I need. I need to find a scripting language that wi
Ebay uses windows for everything now.
They used to have Sun with Oracle and NT front end.
Now they are completely 2000.
Hmm, no outages lately on ebay, yet there were many outages while running
Sun. I KNOW Sun is more stable, perhaps it is other reasons? No way!
Micheal, I have many many NT
Thanks. I rebuilt the tablespaces with larger extents sizes last night. Took
some time to drop though...
- Paul
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 8/19/01 10:25 AM
lots of extents on the table, and a "drop storage" on the truncate will
cause the trunca
Number of extents on this table is one of the reasons
MOHAMMAD RAFIQ
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Sat, 18 Aug 2001 21:45:25 -0800
I have a 12.5 million row table for which a truncate has been running for
>2hrs. What can cause
lots of extents on the table, and a "drop storage" on the truncate will
cause the truncate to run very long -- Oracle needs to release the extents
to the FET$ -- which means taking each extent OFF the UET$ and adding it to
FET$ -- lots of recursive SQL
>From: "Troiano, Paul (CAP, GEFA)" <[EMA
20 matches
Mail list logo
