RE: How to prevent oracle from committing a transaction?
set autocommit off (in sqlplus) and i'm not sure but cant you set this to be the default to happen in some glogin.sql file ? -Original Message- Sent: 05 June 2001 08:30 To: Multiple recipients of list ORACLE-L Dear DBA Gurus, Can you tell me how to prevent oracle from committing a transaction unless I explicitly commit it. I have observed that when I insert a record into a table and type exit from the sql prompt without commiting the transaction and again open a new sqlplus session and select from that particular table the record is inserted. How do I prevent oracle from inserting into a table unless I explicitly specify commit? Please note that I have set my sqlplus session as autocommit off. I tried with alter table tablename nologging but it didn't do what I wanted. Can anybody help me in this regard? TIA and Regards, Ranganath -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 also send the HELP command for other information (like subscribing). _ This message has been checked for all known viruses by Star Internet delivered through the MessageLabs Virus Scanning Service. For further information visit http://www.star.net.uk/stats.asp or alternatively call 01285 884400. This message is intended only for the use of the person(s) (the intended recipient (s)) to whom it is addressed. It may contain information which is privileged and confidential. If you are not the intended recipient, please contact the sender as soon as possible. The views expressed in this communication may not necessarily be the views of InterX plc. Any copyright in this message shall remain vested in InterX plc © and the intended recipient may only copy the same for internal business purposes or as otherwise stated in this message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vipul Lakhani INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 also send the HELP command for other information (like subscribing).
RE: Working with a BLOB
just a guess but try
select dbms_lob.instr(blob_col, '.com')
from atable
where dbms_lob.instr(blob_col, '.com') between 0 an 75
-Original Message-
Sent: 30 May 2001 23:30
To: Multiple recipients of list ORACLE-L
I've been through the documentation on LOBs but am
still stuck trying to figure out how to interrogate
the contents of a BLOB.
We have a table with a BLOB column in it. All it
contains in text data (i.e. memo notes). Why it was
created as a BLOB and not a CLOB is unknown to me and
done before I was hired. All I need to do is determine
if a particular string ('.com') pattern exists in the
column, within the first 75 bytes, and return its
starting position.
Would someone help me out? Thanks!
-w
__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Walter K
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
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
also send the HELP command for other information (like subscribing).
_
This message has been checked for all known viruses by Star Internet
delivered through the MessageLabs Virus Scanning Service. For further
information visit http://www.star.net.uk/stats.asp or alternatively call
01285 884400.
This message is intended only for the use of the person(s) (the intended recipient
(s)) to whom it is addressed.
It may contain information which is privileged and confidential.
If you are not the intended recipient, please contact the sender as soon as possible.
The views expressed in this communication may not necessarily be the views of InterX
plc.
Any copyright in this message shall remain vested in InterX plc © and the intended
recipient may only copy the same for internal business purposes or as otherwise stated
in this message.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Vipul Lakhani
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
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
also send the HELP command for other information (like subscribing).
RE: Pls how to install SQL LOADER
when you installed forms and reports you have the option to install oracle client database utilities ... they are installed with that option -Original Message- Sent: 31 May 2001 09:10 To: Multiple recipients of list ORACLE-L Hi, i'm having forms4.5 and repots2.5, i need to install SQL loader, pls give some idea for this -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Senthil Ganapathi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 also send the HELP command for other information (like subscribing). _ This message has been checked for all known viruses by Star Internet delivered through the MessageLabs Virus Scanning Service. For further information visit http://www.star.net.uk/stats.asp or alternatively call 01285 884400. This message is intended only for the use of the person(s) (the intended recipient (s)) to whom it is addressed. It may contain information which is privileged and confidential. If you are not the intended recipient, please contact the sender as soon as possible. The views expressed in this communication may not necessarily be the views of InterX plc. Any copyright in this message shall remain vested in InterX plc © and the intended recipient may only copy the same for internal business purposes or as otherwise stated in this message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vipul Lakhani INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 also send the HELP command for other information (like subscribing).
