Title: CURSOR_SHARING = FORCE ques.
9i has come up with cursor_sharing =
similar,
which was missing till 8i. We had FORCE and
EXACT. FORCE was not what most of the DBA's were willing to use. and hence
used EXACT. But similar will do most of the job (Assumed) that we were
looking with
rename old_name to new_name;
Duy B
ngo_duy@fmail
ya i checked this too.. it's not working.
Saurabh Sharma
[EMAIL PROTECTED]
http://www.geocities.com/saurabh00pc/stride.html
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 03, 2001 7:00 PM
sorry. I checked it and turned out that
Hi lists
Any one can help me aboutdbms_alert(package)/how can i use in data
base triggers
Actually, this came in yesterday:
http://www.cert.org/advisories/CA-2001-16.html
g
-Original Message-
Sent: Tuesday, July 03, 2001 4:46 PM
To: Multiple recipients of list ORACLE-L
Most likely because no-one (at least, I hope not) connects their Oracle
server directly to the
Hi Gurus,
I am trying to used UTL_SMTP to send an e-mail form my oracle machine. I
tried the sample code from oracle documentation.
PROCEDURE
send_mail (sender IN VARCHAR2,
recipient IN VARCHAR2,
message IN VARCHAR2)
as
mailhost VARCHAR2(30) := 'mail.somewhere.com';
mail_conn
For
the UNIX people out there
Unix csh/sh commands:
% cat "food in cans"cat: can't open food in
cans
% nice man womanNo manual entry for
woman.
% rm Godrm: God nonexistent
% ar t Godar: God does not exist
% ar r Godar: creating God
% "How would you rate Quayle's
incompetence?Unmatched ".
%
Raymond Lee Meng Hong wrote:
Hello , Is there anyone use Oracle Intermedia Text .
What is the usage of this product ? As a banking solution ,we only use
Report, Form ,Database for our customer , what kind of other oracle product
can we integrate into our solution ?
Raymond Lee
Try this one:
create or replace PROCEDURE send2
(sender IN VARCHAR2,
recipient IN VARCHAR2,
subj IN VARCHAR2,
body IN VARCHAR2)
crlf VARCHAR2(2):= CHR( 13 ) || CHR( 10 );
mesg VARCHAR2(4000);
mail_conn UTL_SMTP.CONNECTION;
cc_recipient VARCHAR2(50) default '[EMAIL PROTECTED]';
bcc_recipient
If I understand the question, he wants the time to always be
one-minute-to-midnight, and just insert dates. This can be done with a
trigger.
g
-Original Message-
Sent: Tuesday, July 03, 2001 10:56 PM
To: Multiple recipients of list ORACLE-L
Harvinder,
If you want time in a date
Thanks Ian, for making me RTFM on 'kill session'.
I wasn't aware of the 'immediate' clause.
Jared
On Tuesday 03 July 2001 22:35, MacGregor, Ian A. wrote:
alter system kill session 'sid, serial#' immediate; almost always
works. The immediate argument must be include don the first attempt.
Hello,
In the registry HKLM - SOFTWARE - ORACLE
there should be an entry for PFILE_SID (at least on 7.3.4.5).
HTH
--
Chris J. Guidry P.Eng.
ATCO Electric, Metering Services
Phone: (780) 420-4142
Fax: (780) 420-3854
Email: [EMAIL PROTECTED]
-Original Message-
From: Shahid Nasir
Arno,
It works.
thanks,
Herman
Quoting Disser, Arno [EMAIL PROTECTED]:
Try this one:
create or replace PROCEDURE send2
(sender IN VARCHAR2,
recipient IN VARCHAR2,
subj IN VARCHAR2,
body IN VARCHAR2)
crlf VARCHAR2(2):= CHR( 13 ) || CHR( 10 );
mesg VARCHAR2(4000);
mail_conn
Hello guru's,
I am using one database in nonarchive log mode, I want to change it to
archive log mode.
Platform Windows nt 4.0
Oracle 7.3.0
database size 10GB.
Can any body give me the script which will automatically take online backup
of my database?
BFN,
Breakdown and read the admin guide,
HINT: look at alter tablespace begin backup.
learning is a wonderful thing.
joe
jaimin wrote:
Hello guru's,
I am using one database in nonarchive log mode, I want to change it to
archive log mode.
Platform Windows nt 4.0
Here are two files, a NT cmd and a sql script that do hot backup of archivelog
databases.
Remember to configure the scripts and ajust to your enviroment
jaimin wrote:
Hello guru's,
I am using one database in nonarchive log mode, I want to change it to
archive log mode.
Read the F--- manual.
-Original Message-
Sent: Wednesday, July 04, 2001 3:10 PM
To: Multiple recipients of list ORACLE-L
Breakdown and read the admin guide,
HINT: look at alter tablespace begin backup.
learning is a wonderful thing.
joe
jaimin wrote:
Hello guru's,
HI GURUS,
If I have a table that has a field with long data type and I want to get the
first 250 characters out of it how can I do it. I tried using SUBSTR(long
data type field, 1, 250) but it complained about ORA-00932: inconsistent
datatypes. I then tried TO_CHAR(SUBSTR(long data type field,
Title: RE: Online backup script..
My, my...were you afraid he wouldn't understand the 1st reply?
In the vein of 'if you were the last man on earth...' you can delete my mails in the future, because you can be sure I will be deleting yours.
Have a good day anyway!!
Laura
Read the F--- manual.
You have one too many dashes. If you're going to offer advice, please try
to be accurate. ;-)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Greg Moore
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858)
Mark Liggayu wrote:
HI GURUS,
If I have a table that has a field with long data type and I want to get the
first 250 characters out of it how can I do it. I tried using SUBSTR(long
data type field, 1, 250) but it complained about ORA-00932: inconsistent
datatypes. I then tried
Ask me if I care
-Original Message-
Sent: Wednesday, July 04, 2001 5:35 PM
To: Multiple recipients of list ORACLE-L
My, my...were you afraid he wouldn't understand the 1st reply?
In the vein of 'if you were the last man on earth...' you can delete my
mails in the future, because
Sorry... Greg... I am sick of lazy people expecting stuff without doing
their homework.
-Original Message-
Sent: Wednesday, July 04, 2001 6:20 PM
To: Multiple recipients of list ORACLE-L
Read the F--- manual.
You have one too many dashes. If you're going to offer advice, please
Isn't this a little harsh?
I've certainly felt that way at times myself, but
articulating it is considered rude.
Many folks find the acronym RTFM to be sufficient, as
it can also mean 'Read The Fine Manual'
Jared
On Wednesday 04 July 2001 14:05, Hutchins, Robert wrote:
Read the F---
Ok, that's a time-out for both of you. Go to your room and come back
in five minutes. If you still can't play nice, you'll be subjected to
Ross' bad jokes :)
Cheers,
GC
On July 4, 2001 07:55 pm, Hutchins, Robert wrote:
Ask me if I care
-Original Message-
Sent: Wednesday,
Robert,
After going through the archives I find that in the past
year you have posted 14 times to this list, and once
you had something to say about Oracle.
The rest were rude replies that were completely unnecessary.
I've reached the level of my tolerance with your acrimony.
This list is
Hello all,
Could you please tell me where and how I can browze thru archives of this list? I
came to know about the archives from Jared's reply to Rob's email
rgds,
raja
Get 250 color business cards for FREE!
http://businesscards.lycos.com/vp/fastpath/
--
Please see the official
hi all
i have one table in which the note column have following entries
ID NOTE
-
31177340 400A
31177374 FITZGERALD FENCE
31177394 FASHION BUG
31177454 PRECISION LITHOGRAVING
31177472 TOBIN BROS - VACANT
31177497
Hello Guru.
I plan to compare IBM DB2 Db with Oracle 8i, anyone of you know did they
actually give out their database on the web for us to download ? any site
can refer ?
Raymond Lee
Infopro Sdn Bhd
Block B3 Level 8, Leisure Commerce Square
No. 9, Jalan PJS 8/9 46150 Petaling Jaya
Try this
for leading spaces :
select name,length(name),rtrim(name)
fromora_test
where length(rtrim(ltrim(name))) != length(rtrim(name));
for lagging spaces :
select name,length(name),ltrim(name)
fromora_test
where length(ltrim(rtrim(name))) != length(ltrim(name));
30 matches
Mail list logo