Hi Sam,
What about this,
SQL declare
3 cRow varchar2(18);
4 begin
5 INSERT INTO MEMBER_PLAN_FUND
6 (CLNT,PLAN,MKEY,FUND,TRADATE,ERKEY) VALUES
7 ('0001','1',
'000-3','ER',SYSDATE,Misc.GetDefaultErKey('0001','000-3'))
8
two oracle 8174 databases on one aix 4.3.3 server
database1 = CMS
database2 = HAT
In database2 (HAT)
insert a row into table card_status_log on hat
--The insert is happening directly in database2 from a
--direct sqlplus connect to the hat database.
--no link involved with insert
on the target and see if that helps.
Jack
I've had a little play around with this on 8.1.7.4.1,
and I can't get the INSERT to run in parallel at all -
all I get is a parallel select on the remote database.
Are there any other details you had to set up
to make this work ?
What does
I've had a little play around with this on 8.1.7.4.1,
and I can't get the INSERT to run in parallel at all -
all I get is a parallel select on the remote database.
Are there any other details you had to set up
to make this work ?
What does the full execution plan look like -
run it through
Could you clarify what you mean by 'two sets of slaves' ?
Does this mean you got 24 slaves ? Do you get any clue
about how these may be related by looking at v$px_sesstat ?
This may be related in some way to the fact that
when you do a direct insert on a table, Oracle
still has to do ordinary
mean by 'two sets of slaves' ?
Does this mean you got 24 slaves ? Do you get any clue
about how these may be related by looking at v$px_sesstat ?
This may be related in some way to the fact that
when you do a direct insert on a table, Oracle
still has to do ordinary index maintenance -
so
$px_sesstat ?
This may be related in some way to the fact that
when you do a direct insert on a table, Oracle
still has to do ordinary index maintenance -
so it sorts the incoming data for each index in
turn because this improves the probability of
reducing the UNDO and REDO overhead from
All,
In our 8.1.7.4 warehouse, we are attempting to copy records from a
partitioned table in one domain to a partitioned table in another
domain (via a database link) like so:
alter session enable parallel dml;
insert /*+ append parallel(a,12) */ into tablea a
select /*+ full(b) parallel(b,12
Is it because it was sorting on the partition key to enable each parallel DML
worker take care of a particular partition? when u serialized the
transaction, it didn't have to sort because there was only one particular
worker associated with the insert.
Just a guess.
Regards
Naveen
-Original
message from client
This load varies with number of rows loaded per sec jumping to 600 about
4 days back.
Any ideas would be appriciated.
Thanks,
Sathish.
INSERT INTO
DM_TRANS_PYMT_HIST(PERIOD_KEY,MORTGAGE_LOAN_KEY,TRANSACTION_KEY,
GEOGRAPHY_KEY,ORIGINATION_SOURCE_KEY,TRANCHE_KEY,LOAN_TYPE_KEY
Title: RE: Insert too slow...
How may indexes are on DM_TRANS_PYMT_HIST? If there are a lot, you might want to drop the indexes, except for the primary key or unique constraints, insert the records, rebuild the dropped indexes, and analyze those indexes.
Jerry Whittle
ACIFICS DBA
NCI
PROTECTED] said:
How may indexes are on DM_TRANS_PYMT_HIST? If there are a lot, you might
want to drop the indexes, except for the primary key or unique
constraints, insert the records, rebuild the dropped indexes, and analyze
those indexes.
Jerry Whittle
ACIFICS DBA
NCI Information Systems Inc
Sathish
Given that your high wait times relate not to the actual Oracle insert
process but to communication with the client, the first place I would look
is the connection between Oracle and Informatica. Are you going through
ODBC? There are options in SQL*Net and in the ODBC driver. I would
PK has it's own index... did u drop that too ?
--
From: Gurelei[SMTP:[EMAIL PROTECTED]]
Reply To: [EMAIL PROTECTED]
Sent: Friday, September 20, 2002 1:23 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Why does my insert creates so many logs
Doesn't have any triggers does it?
-Original Message-
Sent: Wednesday, September 18, 2002 8:39 PM
To: Multiple recipients of list ORACLE-L
Hi.
A developer of mine is running a large insert as
select:
insert /* parallel hint */ into table A
nologging
(select * from table b where
None.
--- Nicoll, Iain (Calanais)
[EMAIL PROTECTED] wrote:
Doesn't have any triggers does it?
-Original Message-
Sent: Wednesday, September 18, 2002 8:39 PM
To: Multiple recipients of list ORACLE-L
Hi.
A developer of mine is running a large insert as
select:
insert
A couple of things to try ---
1. Drop the indexes and primary key instead of disabling them. Insert the
data and recreate pk.
2. This could be due to changes in data dictionary, when you insert large
number of rows in the table, new extents may be allocated or high water mark
of the table
of list ORACLE-L
Hi.
A developer of mine is running a large insert as
select:
insert /* parallel hint */ into table A
nologging
(select * from table b where ...);
There are no indices on table A and a PK disabled.
Still that insert generates a large amount of logs.
What could be the reason
the indexes and primary key instead of
disabling them. Insert the
data and recreate pk.
2. This could be due to changes in data dictionary,
when you insert large
number of rows in the table, new extents may be
allocated or high water mark
of the table would be modified. This information
)
from v$sess_io
where (block_changes + consistent_changes) 5000 /* insert a reasonable
value here */
order by 2 desc;
SID (BLOCK_CHANGES+CONSISTENT_CHANGES)
-- --
8 175079
5
Title: RE: Why does my insert creates so many logs?
is the tablespace in hotbackup mode?
-Original Message-
From: Gurelei [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 11:24 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Why does my insert creates so many
Regular table to Object table insert
Greetings,
I'm currentlying prototyping different data model using Object Oriented
facilities provided with 9i and I did hit a wall. I hope one of you guys
can
make that wall crumble.
I have a data model which is exactly mapped to the Object Model
Hi.
A developer of mine is running a large insert as
select:
insert /* parallel hint */ into table A
nologging
(select * from table b where ...);
There are no indices on table A and a PK disabled.
Still that insert generates a large amount of logs.
What could be the reason for that? Any
Does you table have many small extents ?
On Wednesday 18 September 2002 21:39, you wrote:
Hi.
A developer of mine is running a large insert as
select:
insert /* parallel hint */ into table A
nologging
(select * from table b where ...);
There are no indices on table A and a PK disabled
Operations that are performed as nologging will still generate redo for the
following:
Space management (updates to the data dictionary)
Undo/rollback (each insert generates an undo entry which generates a redo
entry)
-Original Message-
Sent: Wednesday, September 18, 2002 1:39 PM
No. It only has 12 extents
--- Anjo Kolk [EMAIL PROTECTED] wrote:
Does you table have many small extents ?
On Wednesday 18 September 2002 21:39, you wrote:
Hi.
A developer of mine is running a large insert as
select:
insert /* parallel hint */ into table A
nologging
Hi,
I just wanted to create a directory alias on SuSe Linux7.3 in order to insert an external PDF file into BFILE column. Anyone please show me how to do so.
On Window:
CREATE or REPLACE DIRECTORY TEST as 'c:\images' ;
On Linux: I issues this below command
CREATE or REPLACE DIRECTORY TEST
]
.comcc:
Sent by: Subject: generate insert statement ???
[EMAIL
Hi all,
I need to generate insert statements for a given
table. For example ACCOUNTING_TRANSACTION_TYPE table
has 300 rows, and I need to generate a sql like the
following:
INSERT INTO ACCOUNTING_TRANSACTION_TYPE
(ACCT_TRAN_TYP_CD,
ACCT_TRAN_TYP_NM,
GL_ACCT_TYP_CD
, August 14, 2002 1:19 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: insert nologging parallel/noparallel and archiving
In the second case you are also selecting from sequence which might have
generated the logs. Use logminer and get the details of what was logged.
Naveen
Hi everyone,
I just upgraded out development database from 8.1.7 to 9.2 and I'm
getting an ORA-600
error when trying to do
insert into table1 (select * from table1@dblink)
The error is -
ORA-00600: internal error code, arguments: [qerrmOFBu1], [9100
when trying to do
insert into table1 (select * from table1@dblink)
The error is -
ORA-00600: internal error code, arguments: [qerrmOFBu1], [9100],
[], [], [],
[], [], []
The database on the other end of the dblink is an RDB 7.0.63 database.
I can select * from table1@dblink
16, 2002 9:39 AM
To: Multiple recipients of list ORACLE-L
Hi everyone,
I just upgraded out development database from 8.1.7 to 9.2 and I'm
getting an ORA-600
error when trying to do
insert into table1 (select * from table1@dblink)
The error is -
ORA-00600: internal error
Jack,
I have another twist on this situation. Again I'm
loading the tables in nologging mode with all the
indices dropped. Both transactions are insert into
table nologging (select *). The only difference is
that one select is a select from a single table while
the other - is a select from two
As long as you are doing INSERT INTO ... using CTAS it can make use of
NOLOGGING according to Oracle. I do not know
why the single table does not use it. Perhaps posting relevant portion of
insert stmt may provide some help
Rick,
These are the transactions:
This one does not create any logs (nothing was written
into arch directory);
insert /*+ parallel (egurev1.offr,16) */ into
egurev1.offr
nologging
(select
a.PRDCT_ID ,
a.OFFR_RSPNS_TYP_CDE ,
a.PRTY_TYP_NBR ,
a.PREFR_IND ,
a.OFFR_CNT
,
These are the transactions:
This one does not create any logs (nothing was written
into arch directory);
insert /*+ parallel (egurev1.offr,16) */ into
egurev1.offr
nologging
(select
a.PRDCT_ID ,
a.OFFR_RSPNS_TYP_CDE ,
a.PRTY_TYP_NBR ,
a.PREFR_IND ,
a.OFFR_CNT ,
a.PROC_MTH_VAL,
a.TRSFR_RSPNS_CDE
recipients of list ORACLE-L
Subject: RE: insert nologging parallel/noparallel and archiving
In the second case you are also selecting from sequence which might have
generated the logs. Use logminer and get the details of what was logged.
Naveen
--
Please see the official ORACLE-L FAQ: http
Hi,
I am writing a one-time proc to copy all records from one table to another table
with a commit level of 1 record. I wrote a proc to do this using a cursor and for
loop but was wondering if there was an alternative syntax for the insert using the
current cursor?
Ie. Insert
if there was an alternative
syntax for the insert using the current cursor?
Ie. Insert into table_A (select current record)
Instead of having to use the VALUES syntax (the table has ALOT of
columns)
Pretty much my purpose is to get the the table to re-fire an insert
trigger (trigger needed
Hannah
Maybe you could temporarily change the insert trigger to an update trigger
(create or replace trigger before insert or update on...)
and then simply update the table setting some column to itself. This will
will fire the trigger (and will not change any data in the table).
I didn't
Hannah,
What you are asking is possible only in 9.2. OTOH, you could use SQL to
select from dba_tab_columns to generate INSERT ... script though.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any
Title: RE: INSERT INTO Syntax: Insert a complete record using a cursor
Hi,
The update method is interesting. I need to think the reprocussions through first, but that may save me a lot of hassle
Good idea!
Thanks,
Hannah
-Original Message-
From: [EMAIL PROTECTED
with and you'll have no problem, but you have to double '
so
'where part_no=''1234'' and name=''guest'''
JP
On Wednesday 31 July 2002 06:58, you wrote:
I want to insert the following characters ,
1.) '
2.)
3.)
for example i want to insert the following line as it looks
i presume the statement is a string that u want to insert...
so u can write like this :
select
'where part_no = ''1234'' and name=''guest'''
from dual;
check the quotes out
rgds,
Ams,
www.medicomsoft.com
|-Original Message-
|From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED
Prakash,
Two methods:
SQL alter table test modify (c1 varchar2(100));
Table altered.
SQL insert into test values ('where part_no=''1234'' and name =
''guest''');
1 row created.
SQL select * from test;
C1
--
where
is a string that u want to insert...
so u can write like this :
select
'where part_no = ''1234'' and name=''guest'''
from dual;
check the quotes out
rgds,
Ams,
www.medicomsoft.com
|-Original Message-
|From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of guess who
|Sent: Wednesday
Try this
Chr(39) || 'bla bla' | chr(39)
Chr(39) = '
-Message d'origine-
De: John Thomas [mailto:[EMAIL PROTECTED]]
Date: mercredi 31 juillet 2002 11:48
À: Multiple recipients of list ORACLE-L
Objet: Re: How to insert Special
I want to insert the following characters ,
1.) '
2.)
3.)
for example i want to insert the following line as it looks...
where part_no='1234' and name='guest'
how to do ?
can anyone help ...
Regards,
Prakash.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
Qs How is Select of Data from a Long Datatype Field to INSERT into a Varchar2 Datatype
Field
in another Table possible ?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: VIVEK_SHARMA
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858
PROTECTED]]
Sent: 24 July, 2002 12:12 PM
To: LazyDBA.com Discussion
Subject:RE: Select from Long Datatype Field to INSERT into a
Varchar2 Dat atype Field
No That is Not Possible.. Another reason to move to Clob...
HTH
Best Regards
Just wanted to thank Jack, Connor and Jared for their
help!!
Gene
--- Jack Silvey [EMAIL PROTECTED] wrote:
sorry, meant insert as select, not insert as append
--- Jack Silvey [EMAIL PROTECTED] wrote:
Gene,
This sounds right.
__
Do You
and Jared for
their
help!!
Gene
--- Jack Silvey [EMAIL PROTECTED] wrote:
sorry, meant insert as select, not insert as
append
--- Jack Silvey [EMAIL PROTECTED] wrote:
Gene,
This sounds right.
__
Do You Yahoo!?
Sign up for SBC
Hi all.
I've been trying to copy a 20mil rows table between
two databases via insert as select statement. I
have dropped all the indices and ran in nologging mode
with hints forcing parallel execution of both ISERT
and SELECT. While checking the archive directory I
have noticed
You'll need the APPEND hint to avoid the logging in
serial mode.
hth
connor
--- Gurelei [EMAIL PROTECTED] wrote: Hi all.
I've been trying to copy a 20mil rows table between
two databases via insert as select statement. I
have dropped all the indices and ran in nologging
mode
Gene,
This sounds right.
Standard insert as append does freelist block checking
and generates redo. Parallel DML generates minimial
redo, just for the new temp segments being created,
not for the datablock updates. This is one reason it
is so fast.
Index changes are always logged, even
sorry, meant insert as select, not insert as append
--- Jack Silvey [EMAIL PROTECTED] wrote:
Gene,
This sounds right.
Standard insert as append does freelist block
checking
and generates redo. Parallel DML generates minimial
redo, just for the new temp segments being created
I'm doing this from memory, so you may want to RTFM
to verify this information.
With a non-parallel insert, you will need to use the APPEND
hint to avoid generating redo. Read the fine documentation
as to why this is necessary.
With a parallel INSERT, the data will all be APPENDed
by default
I am in the process of implementing partitioning on some existing tables. I
have been asked by management to evaluate the performance impacts of the
changes. I am aware of many of the performance advantages of partitioning:
partition pruning, partition-wise joins and parallel data loads. What I
My last set of test results is a little out of date,
but here's an idea to check.
Inserting single rows:
partitioned key insert HAD ca. 50% overhead
Array Inserts sorted by partition key to get lots
of adjacent rows in the same partition
virtually no overhead
Array inserts randomised
Way back in the days of Oracle 8.0.5 I did some performance testing of bulk
inserts/sqlldr of range partitioned tables v.s. non-partitioned tables. I
don't have the benchmarks on hand, but here's what I found. All tests were
done using the direct path inserts (sqlldr direct=true or /*+ APPEND */)
loaded into the the last
partition, it had to do 200 compares and then insert. They have fixed it
and now the use a hash algorythem to determine which partition to insert
data into. It is really fast.
However you will find your biggest pay backs will be in doing selects.
Did you know
Hi all,
I need to insert special charecter into the database through sql loader.
i.e., I have a table with LONG datatype field and data should read:
[Cancellation]
IF ServiceDate = sysdate THEN
Chargepercent(100)
ELSEIF ServiceDate sydate
recipients of list ORACLE-L
[EMAIL PROTECTED]
Sent: Tue, 30 Apr 2002 07:08:51
Hi all,
I need to insert special charecter into the
database through sql loader.
i.e., I have a table with LONG datatype field and
data should read:
[Cancellation]
IF ServiceDate = sysdate
am trying to diagnose a performance difference between two
databases
running the same test. They are similarly configured (same SGA
size,
etc.), and the servers are identical except for the number of
CPUs
(server A has 4, server B has 6).
On database A, INSERT
Paul - How many insert processes did you run on each system? Is the disk
layout identical in terms of spreading across devices?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, April 10, 2002 6:43 PM
To: Multiple recipients of list ORACLE-L
Dennis--
The faster machine had 10 database connections, the slower, 50. Not
all were used in either case. But my comparison is for inserts done by
a single session, i.e., it's not the aggregate insert rate, but a
direct comparison of the same insert statement in a single session on
each server
. Not
all were used in either case. But my comparison is for inserts done by
a single session, i.e., it's not the aggregate insert rate, but a
direct comparison of the same insert statement in a single session on
each server.
As for the disk layout, I don't have that information readily available
recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Thu, 11 Apr 2002 11:28:38 -0800
Dennis--
The faster machine had 10 database connections, the slower, 50. Not
all were used in either case. But my comparison is for inserts done by
a single session, i.e., it's not the aggregate insert rate
.), and the servers are identical except for the number of
CPUs
(server A has 4, server B has 6).
On database A, INSERT performance is about 190 rows/second.
On database B, INSERT performance is over 500 rows/second.
I saw some cache buffers chains, buffer busy, and library
Greetings!
I am trying to diagnose a performance difference between two databases
running the same test. They are similarly configured (same SGA size,
etc.), and the servers are identical except for the number of CPUs
(server A has 4, server B has 6).
On database A, INSERT performance is about
Follow-up question: can someone explain exactly why buffer busy waits
can be due to heavy insert activity when there are insufficient
freelists? I suspect that this may figure into my problem with insert
performance. Thanks!
Paul Baumgartel
.
Anjo.
Paul Baumgartel wrote:
Follow-up question: can someone explain exactly why buffer busy waits
can be due to heavy insert activity when there are insufficient
freelists? I suspect that this may figure into my problem with insert
performance. Thanks!
Paul Baumgartel
Title: RE: Table Insert Lock!!
Hi subra( my ex-pm name),
Hope that ur not pricise in ur ?.
If suppose to keep at maxinum of 1 record at time( like dual), you can restrict this, by
table level trigger of INSERTING.
Sorry if i was u/s wrongly.
Nirmal.
-Original Message-
From
This is code I use and it works. If you see I do not use 'AS' before
select. I am not sure if you need it.
insert /*+ parallel(1, 6) */ into 1
select /*+ parallel(2, 6) */ * from 2;
Shakir
--- paquette stephane [EMAIL PROTECTED] wrote:
Hi,
I'm trying the following insert /*+ append
commit;
Commit complete.
SQL select value
from v$mystat, v$statname
where v$mystat.statistic# = v$statname.statistic#
and v$statname.name = 'redo size'
VALUE
--
117720
SQL insert /*+ append */ into t as select * from
dba_users;
insert /*+ append */ into t as select * from
Hi,
I'm trying the following insert /*+ append */ into t1
as select * from t2;
t1 is created with nologging attribute.
The insert is not using the hint at all.
I can select on t1 (before any commit) which I should
not be able to do if the append hint was used.
Any ways to get the hing used
If you have the Diagnostics Pack, try looking at your session in Top
Sessions.
Beth
-Original Message-
Sent: Wednesday, April 03, 2002 1:06 PM
To: Multiple recipients of list ORACLE-L
Hi DBAs,
I am trying to insert a record thru sql*plus into a table. I am the only
one accessing
03, 2002 10:06 AM
Hi DBAs,
I am trying to insert a record thru sql*plus into a table. I am the only
one accessing database. It just hangs and never inserts. What I can I
look at to help determine why this is happening?
Thanks
Rick
--
Please see the official ORACLE-L FAQ: http
Hi
I have to revoke insert from a table where I am the owner of the Schema. is
it possible. if so? how?.
E.g.
Owner a have a table t1
after inserting 1 row
owner wish to revoke insert for the table t1. because t1 should not have
more than one row.
How to incorporate this. it is 8.1.7
Create your record, then change the tablespace to be read-only.
OR
Don't grant permissions to insert/update/delete the table to anyone.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, March 28
You mention a lock? Are you getting an error message on attempted insert? Is the transaction committed? How about issuing the command 'rollback' ?David A. BarbourOracle DBA, OCPAISD512-414-1002[EMAIL PROTECTED]Sent by: [EMAIL PROTECTED]03/28/2002 04:43 AM PSTPlease respond to ORACLE-L To: Multiple
We use ForAll for insert and it works fine. However, we do not use
prepare_cached or execute. We use bind variables with our static SQL
and insert millions of records and it is fast.
--- Gavin D'mello [EMAIL PROTECTED] wrote:
MessageI'm trying to do a bulk insert using DBI and Oracle for about
If you care to post your perl code, or send it to me offline, I can
take a few minutes to look at it.
-Joe
--- Mohammed Shakir [EMAIL PROTECTED] wrote:
We use ForAll for insert and it works fine. However, we do not use
prepare_cached or execute. We use bind variables with our static
SQL
Title: Message
I'm trying to do a bulk insert using DBI and Oracle for about 248
rows,this is proving to be pretty slow and expensive. Is there anyway where
I cando a bulk insert ? I am using prepare_cached and execute with
parameters.Thanks so much,Gavin
- Original Message
How about doing a:
$dbh-do(q{alter session set sql_trace = true});
in your script before the insert, then checking the trace file
with tkprof.
Jared
On Saturday 02 March 2002 07:33, Gavin D'mello wrote:
MessageI'm trying to do a bulk insert using DBI and Oracle for about 248
rows
Hi ,
this is puzzling me..
i have following table
table name = Sierras.
Columns =
regno,
platfrom,
cost ,
licence_ref
renewal_data
i split this table up into 2:
1. Softwares
cols=
id,
regno,
platfrom,
2. Licences
id,
cost ,
licence_ref,
renewal_data,
i have a third table, a link table
You could create a view across these two tables
to give you the info you need.
Cheers,
Kev.
-Original Message-
Sent: 07 February 2002 14:29
To: Multiple recipients of list ORACLE-L
Hi ,
this is puzzling me..
i have following table
table name = Sierras.
Columns =
regno,
platfrom,
for this??
hope all that makes sense!
regards
IA
insert into link_table (licence_id, software_id)
select l.id, s.id
from softwares s,
licences l,
sierras o
where l.licence_ref = o.licence_ref
and l.renewal_data = o.renewal_data
and s.regno = o.regno
and s.platform
in the old table
sierras.
What query can i write for this??
hope all that makes sense!
regards
IA
insert into link_table (licence_id, software_id)
select l.id, s.id
from softwares s,
licences l,
sierras o
where l.licence_ref = o.licence_ref
and l.renewal_data = o.renewal_data
hello everybody ,
i am on 8.1.6 / NT .
i have a table named images . it's structure is
clip_id int not null,
clip_image blob ,
clip_loc varchar2(100)
i need to insert /update / retrieve a image (GIF/JPEG/TIFF) to/from this
table.
i went thro' the DOCS also . but i don't find any
- Original Message -
i need to insert /update / retrieve a image (GIF/JPEG/TIFF) to/from this
table.
i went thro' the DOCS also . but i don't find any example to do this .
can anyone help me to do this ?
any sample scripts please ?
please refer to chapter 9 Internal Persistent
the revrse process ca be done with a bit of java programming ( javamail
api).
you can collect the incoming mails and then do watever u need with a
database connection
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, January 21, 2002 12:00
:How to insert records into a Database table from an Email ?
Hello All:
I have a situation where emails sent to an Email Id should get inserted
into
a database 1,e some part of the email should get inserted as records in a
particular table. Like for example the Person's Name(who sent
:How to insert records into a Database table from an Email ?
Hello All:
I have a situation where emails sent to an Email Id should get inserted
into
a database 1,e some part of the email should get inserted as records in a
particular table. Like for example the Person's Name(who sent
Hello All:
I have a situation where emails sent to an Email Id should get inserted into
a database 1,e some part of the email should get inserted as records in a
particular table. Like for example the Person's Name(who sent the email)
should get inserted in the Name field of the table, Subject
Hi,
I think of JAVA.
Sinardy
-Original Message-
QURESHI
Sent: 21 January 2002 14:30
To: Multiple recipients of list ORACLE-L
Hello All:
I have a situation where emails sent to an Email Id should get inserted into
a database 1,e some part of the email should get inserted as records
That was me who made that statement about prepared statements being faster than stored
procedures. It was not a general statement.. As my e-mail states, we have done some
testing. Our test included inserts into more than 10 different tables on different
system configurations (Sparc
:
Sent by: rootSubject: Using procedures instead of
coding
update/insert SQL...huh
Hello All
It is not efficient.
We are talking about sending one insert statement against: call procedure,
activate the procedure in the database, parse and pass the parameters, do
the same insert, set return code, deactivate the procedure etc.
The idea behind this method is to isolate various
101 - 200 of 342 matches
Mail list logo