There is no simple way, What is important for you ... value of the element or the
index of the element in the pl/sql table? Looks like the index of the element is
important for you.
Tell us again what is the problem? is it that you have too many array elements? where
does the time goes
All,
i have this query:
SELECT count(1)
FROM ats.emktg_members t1
WHERE NOT EXISTS ( SELECT 'x'
FROM gcd_data_source_details t2
WHERE t2.universal_id = t1.universal_id
AND t2.data_source_id = 13 )
AND upper(t1.email) NOT LIKE '%TATA.COM';
This query finishes in about 5 minutes. The
It's a bad query that could probably be resolved throuh
an analytic function but I don't normally delve into things
like that before having finished my 2nd coffee. You can
use hints, in particular, there is a hint to force hash join.
On 01/27/2004 06:44:25 AM, S.Sarkar wrote:
All,
i have this
Is the sql really the same query is run from a stored procedure or is it
perhaps using in place of the '%TATA.COM' a plsql variable (which is set
to %TATA.COM)?
At 04:44 AM 1/27/2004, you wrote:
All,
i have this query:
SELECT count(1)
FROM ats.emktg_members t1
WHERE NOT EXISTS ( SELECT 'x'
My following message did not seem to make it to oracle-l.freelists. Let me
try it again.
Guang
-
Hi,
I have the folliwng pl/sql code for oracle 8173. I am wondering if there is
a way to make it faster by not looping each array elements, but doing some
kind of forall opration
did not seem to make it to oracle-l.freelists.
Let me
try it again.
Guang
-
Hi,
I have the folliwng pl/sql code for oracle 8173. I am wondering if
there is
a way to make it faster by not looping each array elements, but doing
some
kind of forall opration to my_package.function?
declare
type
Couldn't the declarations be put into a package? We've done this in order
to maintain values for the life of the session.
Rich
Rich JesseSystem/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-Original Message-
Sent:
On 01/27/2004 02:09:25 PM, Jesse, Rich wrote:
Couldn't the declarations be put into a package? We've done this in
order
to maintain values for the life of the session.
Yes, they could, I didn't see it in this example.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
context switching
between the pl/sql and sql engines for an array. Using forall you'll be
switching context only once whereas using a regular for loop you'll be
switching context for every member of the array.
Regards,
Dave
[EMAIL PROTECTED] wrote:
Declare
type numTbl is table of number index
Sorry I did not make it clear that the number I used here (1, 9, 15,99) are
just examples, the actual element index is a varible and they are not
continuous. Yes, refTbl can be defined into a package. I guess what I am
asking is if there is a way in pl/sql to do something like
-- FORALL array
forall should be used as follows:
forall index in lower_bound..upper_bound
sql statement;
Putting anything other than a sql statement (e.g. a pl/sql block) in a
forall statement defeats its purpose.
If you think about it, forall achieves its performance improvement by
binding arrays
it is the same. '%TATA.COM' is not a variable.
sumant
--- Wolfgang Breitling [EMAIL PROTECTED] wrote:
Is the sql really the same query is run from a stored
procedure or is it
perhaps using in place of the '%TATA.COM' a plsql variable
(which is set
to %TATA.COM)?
At 04:44 AM
My following message did not seem to make it to oracle-l.freelists. Let me
try it again.
Guang
-
Hi,
I have the folliwng pl/sql code for oracle 8173. I am wondering if there is
a way to make it faster by not looping each array elements, but doing some
kind of forall opration
: Sunday, January 25, 2004 10:24 AM
Hi all ,
I have a problem about fetching long variable in PL/SQL.
I encountered with problem in following PL/SQL block.
When I try to fetch long variable , I receive PL/SQL: numeric or
value error ORA-06512.
As I searched in metalink
Hi all ,
I have a problem about fetching long variable in PL/SQL.
I encountered with problem in following PL/SQL block.
When I try to fetch long variable , I receive PL/SQL: numeric or value error
ORA-06512.
As I searched in metalink, it is releated to size of long variable
convert to a lob and use a substr. That might fix the problem.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Sunday, January 25, 2004 10:24 AM
Hi all ,
I have a problem about fetching long variable in PL/SQL.
I encountered with problem
,
I have a problem about fetching long variable in PL/SQL.
I encountered with problem in following PL/SQL block.
When I try to fetch long variable , I receive PL/SQL: numeric or
value error ORA-06512.
As I searched in metalink, it is releated to size of long variable.
Probably
I contined testing with pl/sql testprogram and found some interesting prove
about this 1 gb limit for pga with pat set.
All tests are done on hpux11.11 9.2.0.4
Testprogram
create or replace procedure testarray( psize number ) as
begin
declare
TYPE nAllotment_tabtypIS TABLE OF number
Dear DBAs,
Good Morning. Using PL/SQL procedure I am trying to spool out
Japanese Characters with VARCHR2(3600) size and I am getting this error.
Here is my code. For your information it is Japanese Characters
Spool c:\test.log
Declare
cursor c1 is select
Dear Friends,
Thank you so much. Yes i was able to solve this issue..
FYI ... I used CONVERT function
Hi:
In pl/sql, I want to add chr(10) into a string in every 70th position. The
string can be up to 2000 characters long. The follwoing code works. But is
there an even FASTER way to do this?
Thanks.
Guang
---
declare
pos number := 1;
len number;
buf varchar2(2000);
x varchar2
Hi,
I am trying to spool the result from PL/SQL procedure. At the
end of result I am getting PL/SQL successfully completed.
Could anyone tell me how to avoid that message?.
This is how my sql looks like
set linesize 200
set trimspool
set feedback off
Raj
-Original Message-
Sent: Tuesday, January 06, 2004 3:49 AM
To: Multiple recipients of list ORACLE-L
Hi,
I am trying to spool the result from PL/SQL procedure. At the
end of result I am getting PL/SQL successfully completed.
Could anyone
SET FEEDBACK OFF
Regards,
Charu.
-Original Message-
Behalf Of
Mudhalvan, Moovarkku
Sent: 06 January 2004 14:19
To: Multiple recipients of list ORACLE-L
Hi,
I am trying to spool the result from PL/SQL procedure. At the
end of result I am getting PL/SQL successfully completed
ORACLE-L
Hi,
I am trying to spool the result from PL/SQL procedure. At the
end of result I am getting PL/SQL successfully completed.
Could anyone tell me how to avoid that message?.
This is how my sql looks like
set linesize 200
set trimspool
Hi Mudhalvan ,
set feed off ;
did u try this ? not sure though : )
Regards,
Prem.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Mudhalvan, Moovarkku
Hi,
I am trying to spool the result from PL/SQL procedure. At the
end of result I am
-
From: Mudhalvan, Moovarkku
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Sent: Tue, 06 Jan 2004 00:49:25
Hi,
I am trying to spool the result from PL/SQL
procedure. At the
end of result I am getting PL/SQL successfully
completed.
Could
set feedback off
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Tuesday, January 06, 2004 3:49 AM
To: Multiple recipients of list ORACLE-L
Hi,
I am trying to spool the result from PL/SQL procedure. At the
end of result I am getting PL/SQL
Jared,
Point taken. I should do some testing instead of publish an opinion. I
still do not like the constraction, but that's a matter of
taste.
I have done some testing as well, because I think you were somehow
comparing apples and oranges: function a uses an implicit cursor, whereas
function b
There are times when running a test harness
through a single pl/sql is going to give you
a spurious result because of extra pinning
(of data blocks and library cache material)
may confuse the issue.
Technically, if the implicit code and the explicit
code were written to do exactly the same
]
Subject: Re: RE: large pl/sql table sucking up all memory on a server
I think Unix Kernel parameter limit should help in this case. It can prevent
runaway process from consuming the whole machine resource.
In most unix, there is kernel parameter(or ulimit) that restrict the maximum
That works. I prefer thumb presses, they worked
for the Inquisition and they lasted 500 years...
dr
Cheers
Nuno Souto
[EMAIL PROTECTED]
- Original Message -
I think Ill get a taser and fry the next person who does it. :)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
There are times when running a test harness
through a single pl/sql is going to give you
a spurious result because of extra pinning
(of data blocks and library cache material)
may confuse the issue.
That isn't a factor, as I never use the results
from the first run for that very reason
I wasn't thinking of the boundary conditions,
I was thinking of the totally different mechanisms
that appear because you are running pl/sql rather
than (say) a loop in Pro*C that sends a pure
SQL statement 1,000 times to the database.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
At 09:49 30-12-03 -0800, you wrote:
There are times when running a test harness
through a single pl/sql is going to give you
a spurious result because of extra pinning
(of data blocks and library cache material)
may confuse the issue.
That isn't a factor, as I never
use the results
from
One of our guys used a very large bulk collect into with a forall update. It sucked up
all the swap space on our solaris box and noone could connect to it. So we had to
bounce the server.
I was under the impression that pl/sql tables go into the buffer cache and cannot go
large than its size
the server.
I was under the impression that pl/sql tables go into the buffer cache and cannot go
large than its size? Oracle typically holds your hand with memory usage issues. Are
there any parameter settings I can use that limit the size of pl/sql tables?
Or are they just dynamic arrays
, December 29, 2003 12:00 PM
To: Multiple recipients of list ORACLE-L
One of our guys used a very large bulk collect into with a forall update. It
sucked up all the swap space on our solaris box and noone could connect to
it. So we had to bounce the server.
I was under the impression that pl/sql tables
we dont have that level of granularity. everyone developers out of the same DBA
account(not my call).
any parameter settings to limit the size of pl/sql tables?
From: Jamadagni, Rajendra [EMAIL PROTECTED]
Date: 2003/12/29 Mon PM 12:14:24 EST
To: Multiple recipients of list ORACLE-L [EMAIL
3 million records in a forall statement. we are bringing on temps and you know how
that goes... Im hoping I can set a parameter somewhere to keep anyone from bringing
down a server.
such as 'memory for pl/sql table area limit hit' errors out what he is doing.
i guess not :(
From: Khedr
Ryan,
First off, PL/SQL tables have nothing to do with the buffer cache. The
buffer cache is part of the SGA (shared memory) and is used to buffer
blocks of database datafiles. That's all that will ever be in the buffer
cache.
PL/SQL tables are memory constructs that are allocated from the PGA
of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: large pl/sql table sucking up all memory on a server
Ryan,
First off, PL/SQL tables have nothing to do with the buffer cache. The
buffer cache is part of the SGA (shared memory) and is used to buffer
blocks of database datafiles. That's all
developers out of the
same DBA account(not my call).
any parameter settings to limit the size of pl/sql tables?
From: Jamadagni, Rajendra [EMAIL PROTECTED]
Date: 2003/12/29 Mon PM 12:14:24 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: large pl/sql table sucking up
: Re: RE: large pl/sql table sucking up all memory on a server
we dont have that level of granularity. everyone developers out of the
same DBA account(not my call).
any parameter settings to limit the size of pl/sql tables?
From: Jamadagni, Rajendra [EMAIL PROTECTED]
Date: 2003/12
FYI.
The USPS delivery just (10 minutes ago) arrived with
my copy of Mastering Oracle PL/SQL Practical
Solutions, which I ordered from Book Pool, at:
http://www.bookpool.com/.x/mzttmcaj4i/sm/1590592174
As you can see, its not available yet on Amazon:
http://www.amazon.com/exec/obidos/tg
This is probably old hat for you, but given it's Unix
(Sun) and it's a client process, wouldn't you be able
to use ulimit to stop memory allocation growing past a
certain size? The other thing I'd try is to limit memory
through the resource control in Oracle. But that is
highly version
that level of granularity. everyone developers out of the same DBA
account(not my call).
any parameter settings to limit the size of pl/sql tables?
From: Jamadagni, Rajendra [EMAIL PROTECTED]
Date: 2003/12/29 Mon PM 12:14:24 EST
To: Multiple recipients of list ORACLE-L [EMAIL
I have a function like below (psudo code). If cursor cur1 have multiple
rows, would the code leave the cursor open when this function is called?
So if this function is called 1000 times, I would have 1000 open cursors?
function XYZ(gid in number) return varchar2 is
cursor cur1 is select C1 from
cursor for loops automatically close cursors.
dont use when others then null on code you are putting in an application. if
you have a bug you will have a hard time finding it. Its a fundamental flaw.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent:
Hi
if we assume it is implements this way (see below) there will only be
one cursor since c_gid
is a bind variable and there for the cursor will be sharded from call
to call of the function.
create or replace function XYZ (gid in number) return varchar2 is
cursor cur1(c_gid number) is
To: Multiple recipients of list ORACLE-L
Sent: Sunday, December 28, 2003 12:39
PM
Subject: Re: pl/sql open cursor
question
Hi if we assume it is implements this way
(see below) there will only be one cursor since c_gidis a bind variable
and there for the cursor
Hi:
I thought in the orginal code (cursor cur1 is select C1 from tab1 where ID
= gid;), gid is a parameter passed in so it is already a bind variable. I
don't see any difference to what you proposed. Your method is just make
cur1 take a paramter? Am I wrong here?
Also what happens when your
What I don't understand is the loop construction:
Actually only one (row) is read form the cursor, and then the function is
left with a return. Because it's an unconditional return, the code within
the loop will either execute once, or never. When no data is found
NULL is returned. When an error
dont use when others then null on code you are putting in an
application.
if
you have a bug you will have a hard time finding it. Its a fundamental
flaw.
One place where I have found it justified, is in logon trigger where users
must be able to log on, despite any errors which occur in a
dont use when others then null on code you are putting in an application.
if
you have a bug you will have a hard time finding it. Its a fundamental
flaw.
One place where I have found it justified, is in logon trigger where users
must be able to log on, despite any errors which occur in a logon
Carel,
It might seem that the loop construct would be more expensive, but
it didn't appear that way on my test system. ( 9.2.0.4, RH 8.0 )
function a:
create or replace function a return varchar2
is
begin
for srec in (select dummy from ctest)
loop
return srec.dummy;
end loop;
Does myFunction1 often get called with the same arguments? In your example, the
second argument is never repeated, but in the real thing, would the same second
argument be likely to repeat? If myFunction1 gets the same arguments, will it always
return the same value? If so, then it is a
The first argumant (myID) is a variable that is different every time the
function gets called. The second argument is a hard code number (just as in
my orginal message). So I guess I could not use DETERMINISTIC here. I have
not heard of DETERMINISTIC before but I will take a look of this becuase
what does myfunction1() do?
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 is an art !
-Original
Below is the code for myfunction1 in the package, It calls a bunch of other
functions, such as getBlastMatches, escapeGene, genes.gene2protein and
addItem.
Guang
---
type blastMatch is record (
geneName gene.name%type,
percent number
);
function myfunction1 (seqid in number,
Hi:
Oracle 8173 DB.
I have a package funtion, part of it is doing something like this:
utl_file.put_line(fpn, myFunction1(myID, 1));
utl_file.put_line(fpn, myFunction1(myID, 8));
utl_file.put_line(fpn, myFunction1(myID, 6));
utl_file.put_line(fpn, myFunction1(myID, 35));
can you return multiple values from a modified version of myfunction(1) ?? If so, then
you can replace multiple calls by only one. And no, bulk binds is only within
dml/select statements.
Raj
Rajendra dot Jamadagni
In Austin, Texas
--
Original Message
Date: Tue, 09 Dec 2003 06:14:30 -0800
System Manager:
Where are these positions located geographically?
Me
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday,
please send an email to me,if you're interested.
_
Free email with personality! Over 200 domains!
http://www.MyOwnEmail.com
Looking for friendships,romance and more?
http://www.MyOwnFriends.com
--
Please see the official ORACLE-L FAQ:
System Manager:
Where are these positions located geographically?
Me
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, December 09, 2003 7:44 AM
please send an email to me,if you're interested.
Saturday, November 29, 2003, 10:44:26 PM, Khedr, Waleed ([EMAIL PROTECTED]) wrote:
KW I'm curious why? some testing?
Yes. Testing. I want a Data Pump job to run long enough for
me to be able to play around in interactive mode from
several different clients. I only have 28MB of data, and the
load
an arbitrary delay, say
a half second, or maybe a full second, on each and every
insert operation. Does anyone know offhand whether there's a
built-in PL/SQL procedure to just wait for a specified
period of time? Any suggestions on how I can go about
implementing this trigger?
Best regards
Another way would have been to use not autoextending datafiles and resumable
operations during data load...
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Sunday, November 30, 2003 4:54 PM
Saturday, November 29, 2003, 10:44:26 PM, Khedr,
Sunday, November 30, 2003, 10:34:25 AM, Tanel Poder ([EMAIL PROTECTED]) wrote:
TP Another way would have been to use not autoextending datafiles and resumable
TP operations during data load...
I've actually done something similar, which worked for most
of what I want to test. But now I want to
I know this is going to sound rather crazy, but I want to
write an INSERT trigger that imposes an arbitrary delay, say
a half second, or maybe a full second, on each and every
insert operation. Does anyone know offhand whether there's a
built-in PL/SQL procedure to just wait for a specified
period
offhand whether there's a
built-in PL/SQL procedure to just wait for a specified
period of time? Any suggestions on how I can go about
implementing this trigger?
Best regards,
Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]
Join
to
write an INSERT trigger that imposes an arbitrary delay, say
a half second, or maybe a full second, on each and every
insert operation. Does anyone know offhand whether there's a
built-in PL/SQL procedure to just wait for a specified
period of time? Any suggestions on how I can go about
a half second, or maybe a full second, on each and every
insert operation. Does anyone know offhand whether there's a
built-in PL/SQL procedure to just wait for a specified
period of time? Any suggestions on how I can go about
implementing this trigger?
Best regards,
Jonathan Gennick --- Brighten
a half second, or maybe a full second, on each and every
insert operation. Does anyone know offhand whether there's a
built-in PL/SQL procedure to just wait for a specified
period of time? Any suggestions on how I can go about
implementing this trigger?
Best regards,
Jonathan Gennick
anyone know offhand whether there's a
built-in PL/SQL procedure to just wait for a specified
period of time? Any suggestions on how I can go about
implementing this trigger?
Best regards,
Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * 906.387.1698 * mailto:[EMAIL
Saturday, November 29, 2003, 8:59:34 PM, a whole bunch of
people wrote:
try DBMS_LOCK.SLEEP()
Thanks all. I'll give that a try.
Best regards,
Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]
Join the Oracle-article list and
, or maybe a full second, on each and every
insert operation. Does anyone know offhand whether there's a
built-in PL/SQL procedure to just wait for a specified
period of time? Any suggestions on how I can go about
implementing this trigger?
Best regards,
Jonathan Gennick --- Brighten the corner where
there's a
built-in PL/SQL procedure to just wait for a specified
period of time? Any suggestions on how I can go about
implementing this trigger?
Best regards,
Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]
Join the Oracle
for proactive and reactive query
tuning which can be used as a guideline/report while tuning simple, medium
complex and complex SQL queries and PL/SQL stored procedures? If so, can
you please forward the same to me please? If not, can anybody suggest as to
how to go about doing one? Any help
Jared
Thanks for the response. I've had a play and here are the conclusions: -
1) The cache controlled by session_cached_cursors is entirely separate from
the pl/sql static cursor cache. You can turn the former off by setting
session_cached_cursors to zero, but you can only turn the latter off
has finished. This also happens with
explicit cursors, even if you close them! And it happens whether
session_cached_cursors is set to zero or not. I assume that the cursors are
cached within the session context for the package or procedure since it only
happens for named pl/sql blocks
that with session_cached_cursors = 0, and
a 'commit' following the pl/sql block, the only cursor
appearing in v$open_cursor is the final 'commit'.
HTH
Jared
--
alter session set _close_cached_open_cursors = false;
declare
xyz varchar2(30);
begin
select user into xyz from dual
Hi
Does anyone know whether its possible to control the size of the pl/sql
static cursor cache.
I'm running into ORA-01000: maximum number of open cursors exceeded errors
and part of the problem (apart from the usual developers not closing
explicit cursors) is that _all_ static sql statements
://miracleas.dk in the Technical
Information section) ( Guy Harrison's tuning book
also talks about this parameter. )
good luck!
Barb
--- Lord David [EMAIL PROTECTED] wrote:
Hi
Does anyone know whether its possible to control the
size of the pl/sql
static cursor cache.
I'm running into ORA
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: ORA-1000 and pl/sql cursor cache
Hi
Does anyone know whether its possible to control the size of the pl/sql
static cursor cache.
I'm running into ORA-01000: maximum number of open cursors exceeded errors
and part
Guang,
I agree with your analysis, looping on characters is not the faster you can do,
simply because there is a significant overhead (compared to C code for instance) in a
language such as PL/SQL - which might be perfectly acceptable in some circumstances,
much less so in very repetitive
is not the faster you can do,
simply because there is a significant overhead (compared to C code for instance) in a
language such as PL/SQL - which might be perfectly acceptable in some circumstances,
much less so in very repetitive tasks. 'Native compiling', ie turning PL/SQL in C,
might
Perl is a good tool for text processing. But our program is already written
in pl/sql long time ago and there are intensive db calls in this pl/sql
program. (text processing is only part of it). So I can not change that.
BTW I did a comparison study a while ago for some of our pl/sql packages
Guang,
Well you are almost there ... you need fifo structure namely a pl/sql array
1. create a local pl/sql array to store the delimiter (store the ascii value of the
delimiter to be safe) my_array (varchar2(5))
2. as you find a delimiter insert into the first position in the array
PL/SQL is the fastest thing of them all when it comes to executing
SQL commands, but there are things which simply aren't practical
in 9.2 PL/SQL. Regular expression processing is one of those things.
Fortunately, you can mix the two. Without DBI, perl scripts simply
woudn't be very useful
Would extproc_perl fit well enough, though, until 10g is here?
On Fri, 21 Nov 2003, Mladen Gogala wrote:
PL/SQL is the fastest thing of them all when it comes to executing
SQL commands, but there are things which simply aren't practical
in 9.2 PL/SQL. Regular expression processing is one
Hi:
In my pl/sql program, I want to process each word in a string. The
string is selected from a varchar2(300) column. The delimit that separates
the words is not necessary space character. The definition of the delimit
in this program is set as
1. Any character that is NOT AlphaNumerical (0-9
I don't know about PL/SQL but here is how I would get separate words from a big string:
#!/usr/bin/perl -w
use strict;
my (@ARR);
while () {
chomp;
@ARR = split(/[^0-9a-zA-Z_\.,]/);
foreach (@ARR) {
print $_\n;
}
}
There is something called DBI and it can be used
You have not provided me with anything (I cannot post these things to public
forums because of my email)!
The only thing you said bad code, good code!
I was not impressed the way the code works, this is why I had to research
issue until I found the problem using LIKE.
Of course it was easy for
Khedr, Waleed wrote:
You have not provided me with anything (I cannot post these things to public
forums because of my email)!
Please re-read my posts.
The only thing you said bad code, good code!
How should it be named?
I was not impressed the way the code works, this is why I had to research
Hallo,
I am trying to create this statement but dont get it work. I would like to check if a
field information from table one exists in table 2, and if that exists in table 2,
then procedure test_proc would run,
Please help me with this.
Thanks in advance
Roland
--
Please see the
Yes, you are right, of course. Using large PL/SQL tables and
string manipulation (INSTR,SUBSTR and alike) are known to be
CPU intensive and there is no way around it. The only way
to help an application which uses those functions extensively
is to add a column which extracts portion
Hallo,
I would like to do the following with an sql( pl/sql) statement.
I have table1 and table2 andtable3.
I want to check whether field1 in table1 exists in table3. If so then I want an insert
statement to be run...insert into table3.
If it doesnt find that value then th escript will go
the following with an sql( pl/sql) statement.
I have table1 and table2 andtable3.
I want to check whether field1 in table1 exists in table3. If so then I want an
insert statement to be run...insert into table3.
If it doesnt find that value then th escript will go to table2 and check
In article [EMAIL PROTECTED], Vladimir Begun
[EMAIL PROTECTED] writes
Less number of inexpensive instructions is everytime better (I'm not talking
about lines of code).
Trace it -- 10046/12 + dump instructions using appropriate event.
1 - 100 of 1314 matches
Mail list logo