he official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Michael Netrusov
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
-
XACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq
rminal Server and Standard Edition.
Has anyone else seen this ? I am so irked I could scream. (But it could be
the hormones).
Lisa Koivu
Oracle Database Monkey.
Fairfield Resorts, Inc.
954-935-4117
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Autho
gt; the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Michael Net
Title: create sequence in PL/SQL anonymous block - needs to be in separate block?
well,
declare
i pls_integer;
begin
execute immediate 'create
sequence temporary_sequence_s';
for i in 1..1000 loop
execute
immediate 'insert into t( n ) values( tempo
st, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other informat
E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribin
use dbms_lob.substr( clob_column, amount, offset )
to see it's portion.
- Original Message -
From:
Apps Sol
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, September 04, 2001
09:12
Subject: Clob and TOAD
Is there any way to see CLOB data in
TO
ved from). You may
> also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Michael Netrusov
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California
--
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
&
Helmut,
check: Doc ID: Note:124140.1
Type: BULLETIN
Status: PUBLISHED
on Metalink.
HTH,
Michael Netrusov
www.atelo.com
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, May 09, 2001 13:35
> Hi ther
: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Michael Netrusov
INET: [EMAIL P
let me know if you've had any success with what I'm
> describing here. Am I aiming for the impossible? Surely not!
>
I am sorry to admit, but you are :-)
So far at 8.1.7 we have only the "graceful switchover", awfully well described in
Lawrence To's article.
HTH
hanges to the doctor table.
> All the old code (encapsulated or not) still works the way it used to. If I
> overlook something, it may not have the added functionality, but it will not
> break.
>
> PS: I think this discussion would best be continued with copious amounts of
> alcoho
t; As Steve pointed out, it's just a matter of preference. A few
> > years ago I prefered multiple similar tables vs one master lookup..
> > Now I implemented the opposite approach and I am happy with
> > it. Less code ( packages consuming memory ), less database objec
's just a matter of preference. A few years ago I prefered
multiple similar tables vs one master lookup..
Now I implemented the opposite approach and I am happy with it. Less code ( packages
consuming memory ), less database objects to
administer.
Regards,
Michael Netrusov
www.atelo.com
-
n partitioned?
> Do Oracle ERP or SAP ERP apps do this?
> Curious.
They do not. But I do not consider them a good example of desing and programming.
Regards,
Michael
> -Original Message-
> Ghosalkar
> Sent: Thursday, March 22, 2001 3:01 PM
> To: Multiple recipient
hveloper might consider it's fun to write 10 packages which differ only by
name and a couple attributes.
Later he might claim that he wrote 10K lines of code ( instead of 1K ) and worked
hard. :-)
Regards,
Michael Netrusov
www.atelo.com
--
Please see the official ORACLE-L FAQ: http://w
ranular control over the individual code table
still present with the lookup_type column.
So now for the DBA side: do you prefer to have multiple numerous small tables or one
large? :-)
Regards,
Michael Netrusov,
www.atelo.com
- Original Message -
To: "Multiple recipients of li
gt; >
> > Do developers design ER models in your shop? It should be you
> > or a DA. :-)
> >
> > > Duhveloper combat is so much fun! :-) Unfortunately they
> > usually outnumber
> > > us DBA's so we have to be particularly nimble. ;-)
> >
>
uhveloper combat is so much fun! :-) Unfortunately they usually outnumber
> us DBA's so we have to be particularly nimble. ;-)
In my current shop I am a pl/sql developer :-) ... as well as a DA and a DBA. This
saves me a LOT time and nerves.
Regards,
Michael Netrusov.
>
>
t with the lookup_type column.
So now for the DBA side: do you prefer to have multiple numerous small tables or one
large? :-)
Regards,
Michael Netrusov,
www.atelo.com
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: T
mably waiting for
the ITL slot...
HTH,
Michael Netrusov,
www.atelo.com
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, March 21, 2001 01:40
> Michael,
>
> thanks for your response.
> I meant the following si
Yosi,
Hot standby db protects you from the data corruption. Any kind of mirroring does not -
it's just a copy.
HTH,
Michael Netrusov,
www.atelo.com
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, March
, you either wait or receive
an error if "no wait" was specified.
Behaviour of the 2nd transaction is trying to place an exclusive lock on the 1st
transaction' row is just the same.
If both transactions wait, it's a deadlock situation and should be resolved by Oracle
itsel
companies have time / money
to redesign / rewrite their products? Yes. Do they do it? No. It's all
about the enormous amount of money they make on customization /
support. The DA's and developers can be well-meaning though and never be
aware of the whole plan :-)).
Regard
The only problem is to sell the whole
stuff - but it's only a matter of the sales department' qualification.
Just IMHO,
Michael Netrusov,
www.atelo.com
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Saturday, March 17,
Does anyone know - will I still have access to Metalink if I will not pay for the
support?
TIA,
Michael Netrusov,
www.atelo.com
(202) 262 8469
(877) 528 0090
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, Febr
Title: MS KB Article
it's an old joke :-)
http://www.TYPE_ANYTHING_YOU_WANT.com&[EMAIL PROTECTED]/pub/mskb/Q209354.asp
- Original Message -
From:
Mohan,
Ross
To: Multiple recipients of list ORACLE-L
Sent: Friday, February 23, 2001
10:30
Subject: MS KB Article
plus variables( though it's not a good idea to use them ), constants, types, cursors,
etc
HTH,
Michael Netrusov,
www.atelo.com
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, February 19, 2001 10:31
> Use
30 matches
Mail list logo
