Hi
I am also not aware of HP but on solaris u can find using prtdiag
command
U can find this command in /usr/platform/sun4u/sbin
Regards
Pawan Dalmia
Database Administrator
Orange-9820018753
Extn -5064
-Original Message-
Sent: Thursday, October 16, 2003 12:24 PM
To: Multiple
Does this work?
echo selclass qualifier cpu;info;wait;infolog|cstm
(Got it from Google and don't have a HP-UX now. So may or may not work)
KG
--- Pawan Dalmia [EMAIL PROTECTED] wrote:
Hi
I am also not aware of HP but on solaris u can find using prtdiag
command
U can find this command in
Hi,
It is very simple in Solaris. Just try psrinfo or psrinfo -v. You will
get the CPU details. Not sure abt HP though :(
KG
--- Daiminger, Helmut [EMAIL PROTECTED] wrote:
Hi!
I'm new to HP-UX and need to find out how many processors are in a
mchine
and at what clock speed they operate.
Hi!
I'm new to HP-UX and need to find out how many processors are in a mchine
and at what clock speed they operate. I can get the number of CPUs through
glance or top, but I have no idea about the clock speed. How would I get
that information?
I would know how to do it on Solaris though... ;)
Paul,
I've used PL/SQL Developer by Allround Automations to develop PL/SQL procs,
packages and it's fine including a well featured de-bugger. I believe that a
site licence costs $3,000. As to it being a DBA tool I'd have to say it's
not in the same league as TOAD Xpert with DBA module.
Chris
select bytes
from dba_segments
where segment_name = 'your_table';
divide the result by 1024*1024*1024 and you'll get
the size in GB
- Original Message -
From:
Pillai, Rajesh
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, October 15, 2003 9:24
PM
Hi ,
For me it took approximately 2 hrs to run catpatch.sql and don't have
any probs yet
Thanks to kirti and brad for the info ...
Shibu
-Original Message-
From: Kirtikumar Deshpande [mailto:[EMAIL PROTECTED]
Sent: Wed 10/15/2003 7:54 PM
Hi,
I'll second Chris' statement. I found PL/SQL Developer to be a great and
inexpensive PL/SQL development tool. Its debugger is especially good. In
fact from a development perspective I found it to be far superior to TOAD.
Have no idea about support and consideration of user suggestions as I
Thomas,
All that this does is report the number of rows. It does not deal with any
columns within the table. If I had two tables with the exact number of
rows, but one table had 10 2K columns fully populated, and the other table
had 10 1-char columns fully populated, this query would return the
Hi!
I got the answer from an Unix Admin...
There are three ways:
1) If you can reboot the machine you can see it on startup.
2) If not, use SAM (type sam at # prompt) and go to performance monitors,
system properties.
3) echo 'itick_per_usec/D' | adb /stand/vmunix /dev/mem
echo
stupid question
is the library in $OH/lib?
/stupid question
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion
Hallo,
Anyone whom could gíve me some good help on this.
I have a table with one field, called Company_id
Like this
Company_id
16
45
50
In table 2 I have this field and values:
Company_id Lev_idVare_id
16 45 56
34
Hi List
I have 1000 lines in my data file. I want to add
'(comma) at the begining and end of each line.
For example,
abf
jd
djkhk
jd3
Shold be convrted to
'abf',
'jd',
'djkhk',
'jd3',
Any help will be really appreciated.
Thanks
Sami
__
Do you Yahoo!?
The New
On Wed, 2003-10-15 at 18:04, M Rafiq
wrote: Jared,Those tables are transit
type of tables and depending on your volume of data, there are lot
of deletes and inserts all the time resuling index
fragmentation(holes due to deletes) and space usage.
The rebuilding not only release
How about:
insert into table3(company_id,lev_id,vare_id)
(select table2.company_id,lev_id,vare_id
from table1, table2
where table1.company_id = table2.company_id);
Scott Canaan ([EMAIL PROTECTED])
(585) 475-7886
Life is like a sewer, what you get out of it depends on what you
$ cat data.txt
abf
jd
djkhk
jd3
$ awk {print \'\ \$0 \',\;} data.txt
'abf',
'jd',
'djkhk',
'jd3',
$
OD Hi List
OD I have 1000 lines in my data file. I want to add
OD '(comma) at the begining and end of each line.
OD For example,
OD abf
OD jd
OD djkhk
OD jd3
OD Shold be convrted to
OD 'abf',
Does any one know if 10g still supports LONG data type?
_
Never get a busy signal because you are always connected with high-speed
Internet access. Click here to comparison-shop providers.
https://broadband.msn.com
--
Please see
insert into table3(company_id,lev_id,vare_id)
select company_id,lev_id,vare_id from table2 where vare_id = 56
AND exists (select 1 from table1 where table1.company_id =
table2.company_id)
On Thu, 2003-10-16 at 10:20, [EMAIL PROTECTED] wrote:
Hallo,
Anyone whom could gve me some good
Thanks
for your comments. You are correct that AIF_OUTBOUND_IX01 is more
selective than AIF_OUTBOUND_IX03.
From
what I am seeing, degree is affecting the plan. If I delete stats, alter
index parallel 10, analyze table estimate stats - the bitmap conversion plan is
used.
If I
delete
small C, java, Perl, etc program can get it done quickly.
-Original Message-
Sent: Thursday, October 16, 2003 10:20 AM
To: Multiple recipients of list ORACLE-L
Either Unix or Windows
Hi List
I have 1000 lines in my data file. I want to add
'(comma) at the begining and end of each line.
SQL select * from test1;
COMPANY_ID
--
16
45
50
SQL select * from test2
2 ;
COMPANY_ID LEV_IDVARE_ID
-- -- --
16 45 56
34 10 20
67 10 20
45
The magic of Sed.
vi file
:1,$ s/^/'/g
:1,$ s/$/',/g
:wq
Thats it.
boss
Hi List
I have 1000 lines in my data file. I want to add
'(comma) at the begining and end of each line.
For example,
abf
jd
djkhk
jd3
Shold be convrted to
'abf',
'jd',
'djkhk',
'jd3',
Any help
to add the comma at the beginning of the line...
in vi
escape
:
%s/^/,/g
to add the comma the end of the line ...
escape
:
%s/$/,/g
You of course can use the same syntax to add Apostrophes too.
-Original Message-
Sent: Thursday, October 16, 2003 10:20 AM
To: Multiple recipients of list
I was at the Wash DC Oracle conference yesterday and the key note address was about
the future direction of Oracle. It was pretty positive about Grid technology and blade
servers. Anyone out there have any opinions?
It seems like this technology is probably several years away from being used
oracle would have to take long out of the data dictionary if it doesnt. long is still
in the utlexplan.sql script.
From: Nancy Hu [EMAIL PROTECTED]
Date: 2003/10/16 Thu AM 10:44:26 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: LONG data type in 10g
Does any one
Ahh maybe I read it a little wrong then... ;D
-Original Message-
Quintin, Richard
Sent: 16 October 2003 15:49
To: Multiple recipients of list ORACLE-L
insert into table3(company_id,lev_id,vare_id)
select company_id,lev_id,vare_id from table2 where vare_id = 56
AND exists
Thursday, October 16, 2003, 10:44:26 AM, you wrote:
NH Does any one know if 10g still supports LONG data type?
I just tried creating a table with a LONG column in Beta 2,
and that worked, so I'd say the answer is yes.
Best regards,
Jonathan Gennick --- Brighten the corner where you are
perl -i.orig -p -e s/^/'/ ; s/$/',/ filename
The original version of the file will be retained as filename.orig.
-Original Message-
Sent: Thursday, October 16, 2003 9:20 AM
To: Multiple recipients of list ORACLE-L
Either Unix or Windows
Hi List
I have 1000 lines in my data file. I
YES.
--- Nancy Hu [EMAIL PROTECTED] wrote:
Does any one know if 10g still supports LONG data type?
=
Have a nice day !!
Best Regards,
K Gopalakrishnan,
Bangalore, INDIA.
--
Please see the official ORACLE-L FAQ:
Oh, and I almost forgot a ksh example
(Perl? What's Perl?)
cat your_file | while read LINE; do echo '$LINE'; done
Or
while read LINE; do echo '$LINE'; done your_file
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City
We are being told that we are going to be required to upgrade to 9.2. I
have read the other thread about 8i being contrasted against 9.2 with
9.2 being found wanting in the stability area, so, is 9.2 not a engine
to upgrade to?
v/r
Stephen S. Wolfe, GS-11, DAFC
Data Services Manager
[EMAIL
Since there has been an AWK reply, there should be a SED reply too.
(Perl? What's Perl?)
sed s/^/'/; s/\$/'/ your_file
sed 's/^/'\''/; s/$/'\''/' your_file
-Original Message-
Hi List
I have 1000 lines in my data file. I want to add
'(comma) at the begining and end of each
All of that is fair enough but the number of rows and the values you've
chosen fit the point you wished to prove. The value 5 conveniently fits
the range for an existing leaf block with empty space.
The facts as I understand them are this :
Index space freed by deleted entries can be reused (
Hmmm - we call that symbol a 'quote' (and I have used quotes to quote quote,
if you follow... G)
Various ways - if your data is in a text file - use an edit macro
If it is a field in an Oracle table which you are extracting to a file - try
this:
select * (other fields) ,
Or text editor that can work with columns
Or MSExcel
-Original Message-
From: Khedr, Waleed [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 16, 2003 5:55 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: How to add ' (comma) at the begining and end of each
line? Ei
Title: Effect on Oracle of changing server time from EST to GMT
To support internationalization, we may need to change our server time zone from US EST to GMT. What effect, if any, will this have on the Oracle databases?
Best regards,
David B. Wagoner
Database Administrator
Arsenal
At 01:34 PM 14-10-03 -0800, you wrote:
Hemant,
John,
My apologies for the delay. I hadn't logged on to my email last night.
Here's the output from my site
11.0.3
Purge Obsolete Workflow Runtime Data set to AGE=90 days [ITEM_TYPE and
ITEM_KEY null in parameters]
SQL set time on
14:57:42 SQL
Here is a very complex program that will do the same thing:
#!/usr/bin/perl -w
use strict;
open SYSLOG,/var/log/syslog ||
die Cannot open syslog:$!;
while (SYSLOG) {
if (/HZ/i) {
print ;
exit;
}
}
And here is the result:
[EMAIL PROTECTED] tmp]# ./clock.pl
Oct 9 01:27:18
Much more menacing question:
Are the columns DBA_VIEWS.TEXT and DBA_TRIGGERS.TRIGGER_BODY still of
the type long?
Are
On 10/16/2003 10:59:59 AM, K Gopalakrishnan wrote:
YES.
--- Nancy Hu [EMAIL PROTECTED] wrote:
Does any one know if 10g still supports LONG data type?
=
Have a nice day !!
I'll refrain from answering. My non-rtfm answer would neither be sed
nor awk. If I responded , my response would be something like:
#!/usr/bin/perl -w
while () {
s/^/'/;
s/$/'/;
print;
}
On 10/16/2003 11:04:40 AM, Stephen Lee wrote:
Since there has been an AWK reply, there should be a
I have 2 tables, Rqmt and Resource, same structure.
I need to take all almost-one-million records from Rqmt and
insert them to Resource. So far this worked ok:
DECLARE
RowCount NUMBER:= 0;
BEGIN
SELECT Count(*)
INTO RowCount
FROM RQMT;
IF RowCount 0 THEN
It was the LD_LIBRARY_PATH - and it burned me bad!
-Original Message-
Sent: Thursday, October 16, 2003 10:20 AM
To: Multiple recipients of list ORACLE-L
stupid question
is the library in $OH/lib?
/stupid question
Raj
Title: Effect on Oracle of changing server time from EST to GMT
Only
if the application is using sysdate ,otherwise I dont see any problems with
databases.
Hope
this helps.
Regards
Pawan
-Original Message-From: David Wagoner
[mailto:[EMAIL PROTECTED]Sent: Thursday, October
Thanks Jared,
Would
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32:$LD_LIBRARY_PATH:
export LD_LIBRARY_PATH_64=$ORACLE_HOME/lib
also be correct?
-Original Message-
Sent: Thursday, October 16, 2003 1:59 AM
To: Multiple recipients of list ORACLE-L
This one is incorrect:
Ah, my mistake.
Last night I missed the fact that the first one *does*
have LD_LIBRARY_PATH in it.
Having both the 32 and 64 bit libs in the path could
have been your problem.
Jared
On Wed, 2003-10-15 at 22:59, Jared Still wrote:
This one is incorrect:
export
Thanks for trying it out, Jonathan. Also I really appreciate all replies.
From: Jonathan Gennick [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: LONG data type in 10g
Date: Thu, 16 Oct 2003 07:09:26 -0800
Thursday, October
Here's a recently curmudgeonly reply to a friend that
asked the same question.
-
As for 10g itself: the 'g' stands for 'grid' as you probably know.
The 'grid' is really the infrastructure for 'utility computing',
the latest plot to make IT folks obsolete. Personally I see it
Open the file in vi, run the following command:
%s/^\(.*\)$/\'\1\',/
On Thu, 2003-10-16 at 07:54, Khedr, Waleed wrote:
small C, java, Perl, etc program can get it done quickly.
-Original Message-
Sent: Thursday, October 16, 2003 10:20 AM
To: Multiple recipients of list ORACLE-L
HI ALL
What is difference between "SYSDATE"and
"SYSDATE@!"
??
Waleed Haggagy
I thought that they might ask for billions to help neutralize
Microsoft's weapons of mass deception. Such is the reputation
of the place, I guess.
On 10/16/2003 11:04:25 AM, [EMAIL PROTECTED] wrote:
I was at the Wash DC Oracle conference yesterday and the key note
address was about the future
Title: Deleting from Global temporary Tables
Raj,
Global temporary tables are session-specific.
They have global definition, but each session deals with its
own incarnation of the table.
So, the question is: why would you DELETE
FROM TEMP_SCHEDULE WHERE session_id =
Looks like Tanel Podar is hiding some where or
restraining fromanswering ? Missing his highly sophisticated answers
;)
-ak
What are blade servers? Could the listers please shed some light on it
thanks,
Murali.
|-+
| | [EMAIL PROTECTED]|
| | |
| | Sent by: |
| | [EMAIL PROTECTED]|
SQL*Plus: Release 10.1.0.0.0 - Beta on Thu Oct 16 20:35:19 2003
Copyright (c) 1982, 2003, Oracle Corporation. All rights reserved.
Connected to an idle instance.
SQL startup;
ORACLE instance started.
Total System Global Area 170990484 bytes
Fixed Size 760724 bytes
Variable
If you want a safe way and you are using ksh, you can always use
${LD_LIBRARY_PATH:-/usr/lib}
in the list following the = sign.
That way, you always have something defined
And when nothing is defined, /usr/lib is the default, so you really haven't
changed anything by putting it in.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Juan Miranda
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
Hi all,
how do I find out the exact version of oracle installed (including the service
pack). The server machine has Linux on it. Would like to do this programatically
(using a shell script or C code).
Thanks in advance.
ShivaM
DISCLAIMER: This e-mail contains proprietary information some
Oracle recommends others to use LOB instead of LONG. However they are lazy
to change their own.
From: K Gopalakrishnan [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: LONG data type in 10g
Date: Thu, 16 Oct 2003 08:24:39
http://searchnetworking.techtarget.com/gDefinition/0,294236,sid7_gci770169,0
0.html
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
[mailto:Murali_Pavuloori/[EMAIL PROTECTED]
Sent: Thursday, October 16, 2003 11:20 AM
To: Multiple recipients of list ORACLE-L
Blade servers are computers designed to hunt vampires.
-Original Message-
[mailto:Murali_Pavuloori/[EMAIL PROTECTED]
Sent: Thursday, October 16, 2003 11:20 AM
To: Multiple recipients of list ORACLE-L
What are blade servers? Could the listers please shed some light on it
thanks,
I found this quote in Sillicon Valley News:
Q U O T E D
I'd just like to say for the record, 'Commando' is one of my favorite
movies.
-- Oracle Chairman and Chief Executive Larry Ellison offers some thoughts on
Arnold Schwarzenegger, California's governor-elect.
(ref.
Apparently was but my understanding of paths is that it goes from first directory
listed ...down and so it should have picked up the 64 bit
-Original Message-
Sent: Thursday, October 16, 2003 12:10 PM
To: Multiple recipients of list ORACLE-L
Ah, my mistake.
Last night I missed the
Patrice
If I was the new governor, given the recent scandal between the State and
Oracle, I'd keep Oracle at arms-length until I got settled in and the
taxpayers got used to me.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, October 16, 2003
Correction. Paragraph 4 should begin, I agree though that index rebuilds
are often unnecessary.
Mike
-Original Message-
Sent: 16 October 2003 15:20
To: '[EMAIL PROTECTED]'
All of that is fair enough but the number of rows and the values you've
chosen fit the point you wished to prove.
Hi All,
Client would like me to propose a solution for managing
schemas and code in their databases. There are several
developers, each making changes to their own schema, and
then there's test, qa, and production.
There are both schema changes and code changes. Mostly
schema changes though.
1 or 2 CPU's on a card with a hard drive and an ethernet port or two
connected to a very high speed backplane. They hot-plug into a card
cage, or chassis if you prefer. They put a lot of cpu's into a
relatively small space.
Allan
-Original Message-
[mailto:Murali_Pavuloori/[EMAIL
im not 100% certain. I believe has to do with using 'of the shelf parts' to slap
together your own servers instead of paying for expensive ones. You set them up as a
'grid' like structure, so if one CPU fails you can failover to others.
I think thats what it is...
From:
Jared,
Unfortunately at this stage I cannot quantify in numbers as I have left that
job 5 months back. But dealing with Oracle Financials 10.7 with version
7.3.4, I observed it practically that this table and it is indexes (i think
4 or 5 indexes) require special attention for performance
Sure, I've got an accurate rumour. Of course, I'd have to kill you if I
told you. Do you really want to know that much? :)
Pete
Controlling developers is like herding cats.
Kevin Loney, Oracle DBA Handbook
Oh no, it's not. It's much harder than that!
Bruce Pihlamae, long-term Oracle DBA
I am missing his presence too? It looks he became angry because of some
personal remarks by our some fellow listers.
Tanel, where are you? We already lost active participation of Steve Adam
too.
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL
Let's not forget about ed
ed your_file EOF
,s!^!'!g
,s!\$!',!g
w
q
EOF
if memory serves correctly.
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new system uncovers a new class of bugs. -- Kernighan
or wait for one of the beta testers to put it up on Ebay.
From: Pete Sharman [EMAIL PROTECTED]
Date: 2003/10/16 Thu PM 01:49:40 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Where can I download 10g ?
Sure, I've got an accurate rumour. Of course, I'd have
Best plan at the moment is :
1) Wait patiently for between 3 and 10 months (anyone got an accurate rumour
for a release date?).
2) Download from Technet.
Regards,
Mike Hately
-Original Message-
Sent: 16 October 2003 16:49
To: Multiple recipients of list ORACLE-L
--
Please see the
yeah dont commit every 1000 records and do it in one shot. this is going to be much
slower.
why do you want to do it this way? Ive done 100m inserts with just an insert select
and one commit.
From: Maryann Atkinson [EMAIL PROTECTED]
Date: 2003/10/16 Thu AM 11:54:33 EDT
To: Multiple
I believe that this would be the best solution:
DECLARE
RowCount NUMBER:= 0;
BEGIN
/* This will work if the RESOURCE table has the parallel
attribute set. In 8i, table needs to be partitioned as well */
EXECUTE IMMMEDIATE 'ALTER SESSION ENABLE PARALLEL DML';
How, in the world, did a man with such a poor taste in movies
build such a huge company like Oracle Corp? No wonder that Arnie
has become a guvernator of CA. BTW, has anyone here seen the
Demolition Man? It's not an Arnie movie, but the scene with the
Schwartzenegger presidential library got
I run the following script, and the -S option solved the problem I had (I even had the line # out in the script and re-invoked it).
If the username/pw is on a separate line as shown below, the ps command does not display the userid/pw info.
# Set environment variables#!/bin/ksh
# Set local
Ain't necessarily so. We already have some customers using grid technology
with 9iR2 and 9iAS, along with the toolkit that's available on OTN (whose
name escapes me at the moment). These are very high end business clients
(not government or academia) that the Advanced Technology Solutions group
I think it's more than that. I've got a meeting with the Oracle folks
tomorrow for an overview of other stuff, but he did mention that grid
computing is not like Oracle Failover.
It's more like you have a group of servers at your disposal. Oracle has
*not* been installed on these machines.
There is a company called Merant (www.merant.com) which is a
maker of change management tool called PVCS. They have module
for Oracle, which can compare schemas as well as store fmb files.
As fo the methodology, company documentation is marked with company
confidential, which means that I'm not
List, anyone finished the exercises in cary's book ? or at least chapter 5 ?
. I tried www.oreilly.com/catalog/optoraclep.
Hey maybe I can get you guys to write my term paper too :) Professor Milsap
is a real stickler for assignments and will probably flunk me for copying.
But seriously,
Cary
OT list please
Mladen Gogala [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/16/2003 10:34 AM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: OT California
How, in the world, did a man with such a poor
That will work, slowly.
You might like to try something like this
insert into resource
nologging
select * from rqmt
append;
Read up on the 'append' and 'nologging' first.
Jared
Maryann Atkinson [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/16/2003 08:54 AM
Please respond to
I usually do
echo passwd | sqlplus -s [EMAIL PROTECTED]
Raj
Rajendra dot Jamadagni at nospamespn dot
com All Views expressed in this email
are strictly personal. QOTD: Any clod
can have facts, having an opinion
We had Sun's N1 architect here a few months ago to brief us on N1. ( grid)
In a nutshell, all of your servers go in a pool, the administrative software
doles out the resources as needed, simple as that.
Of course, it is not that simple. Very interesting stuff, though I think the current
buzz
I'm as much a Perl bigot as anyone Mladen, but really,
what's the point of rewriting grep?
grep -i HZ /var/log/syslog | head -1
Jared
Mladen Gogala [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/16/2003 07:59 AM
Please respond to ORACLE-L
To:Multiple recipients of list
Check your Latin...that's Gubernator...
|How, in the world, did a man with such a poor taste in movies
|build such a huge company like Oracle Corp? No wonder that Arnie
|has become a guvernator of CA. BTW, has anyone here seen the
|Demolition Man? It's not an Arnie movie, but the scene with the
Current issue of ComputerWorld has an article on Grid, but I enjoyed the fantastic
cartoon :)
- Kirti
--- Jared Still [EMAIL PROTECTED] wrote:
Here's a recently curmudgeonly reply to a friend that
asked the same question.
-
As for 10g itself: the 'g' stands for
Title: RE: db version control - schemas, code
there was an excellent presentation by Mark Stock at
SEOUC 2002 called
Tag! Whose Code is it?
about embedding versioning inside of Oracle objects.
I'm reluctant to send it without getting approval from
the copyright holder, but the authors
There is a toll schema manager by quest . Have a look at that as well. I
haven't used it though.
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, October 16, 2003 10:24 AM
Hi All,
Client would like me to propose a solution for
I know this should really be on the OT list, but, I couldn't help
laughing at the below.
And all along, I thought Mladen's original comment was actually just a
clever amalgamation of governor and terminator.
Whatever the original intent, it's still funny. :-)
-Original Message-
[EMAIL
I just passed the Net8 Administration OCP exam. This was my last exam, so I
suppose I am now an OCP for Oracle8i.
Thanks to everyone for their helpful tips. Some people said (or implied)
that this is a very easy exam. I would dispute that. I found it just like
the other exams, in that if you
Title: Message
We do
something similar here.
Developers gets Golden (from Benthic). Which has a nice little PL/SQL
Editor and SQL spreadsheet.
DBAs
get TOAD.
Babette
Turner-Underwood work: [EMAIL PROTECTED] home: [EMAIL PROTECTED]
954-3752 (Mon - Fri 7am -
3pm)
-Original
Congrats! Now... What will you do with your sig line
-Original Message-
Sent: Thursday, October 16, 2003 3:24 PM
To: Multiple recipients of list ORACLE-L
I just passed the Net8 Administration OCP exam. This was my last exam, so I
suppose I am now an OCP for Oracle8i.
Thanks to
Congratulations Dennis!
On 10/16/2003 03:24:26 PM, DENNIS WILLIAMS wrote:
I just passed the Net8 Administration OCP exam. This was my last
exam,
so I
suppose I am now an OCP for Oracle8i.
Thanks to everyone for their helpful tips. Some people said (or
implied)
that this is a very easy exam.
Of course, you all do realize that Arnold can't be president... right?
I've actually heard the talking heads talking about it like it's
possible
LOL
Ignoramouses!
RF
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 10/16/2003 1:29 PM
Check your Latin...that's
Hi,
I am trying to remove the duplicate rows from a table with the column data..
I cannot use PK as it's just a sequence number...
I could find all the duplicate rows by grouping the column. but how can i
delete only the duplicate ones and retain the original
Thanks, Melanie! I was already getting frustrated that nobody got the
joke. Though I am slowly melting into a Connecticut Yankee (I even
started cheering for the Yankees), my English is still such that people
usually think that it's just a bad spelling.
On 10/16/2003 02:44:25 PM, Melanie
Title: Message
FYI... Golden is a query tool (and a damn good one)... In my
opinion, it's what SQL Worksheet should be... Simple to use and
fast... The PL/SQL editor from Benthicis separate tool called
PLEdit... It's ok but not great... Like Golden it is quick and
simple... But, if you are
Title: RE: Passed Net8 OCP Exam
WooHoo! Congrats Dennis! So were the questions distributed the same as when I took it, or did they emphasize different areas? Just curious.
-Scott Stefick
-Original Message-
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October
1 - 100 of 172 matches
Mail list logo