How can we use Forall operation for following progm ...
If we use for it takes times ..I wanted to use bulk bind for faster execution ,,
Can u plz suggest how and where to use forall operator in this following progm -
declare
-
vl_c_event_ct varchar2(1000);
-
vl_c_eventcd varchar2(1000);
-
vl_c_class Varchar2(1000);
-
Cursor c1 is select ACC_NUMBER, START_DATE ,END_DATE from am_test;
-
begin
-
for r1 in c1
-
loop
-
select sum( scs),evn_ID,TR_26
-
into vl_c_event_ct,vl_c_eventcd,vl_c_class from costt_test
-
where ACCOUNT_NUM in (select substr(acc_number,4,10) from am_test) and
-
to_char(CREATED_DTM,'ddmmyyyy') between (to_char(r1.START_DATE,'ddmmyyyy')) and(to_char(r1.END_DATE,'ddmmyyyy'))
-
group by EVENT_TYPE_ID,EVENT_ATTR_26 ;
-
dbms_output.put_line(vl_c_event_ct||' '||vl_c_eventcd||' '||vl_c_class);
-
insert into am_test2 values(vl_c_event_ct ,vl_c_eventcd ,vl_c_class ,r1.ACC_NUMBER ,r1.START_DATE ,r1.END_DATE );
-
end loop ;
-
end;
-
2 1540
Orajit,
Please enclose your posted code in [code] tags (See How to Ask a Question).
This makes it easier for our Experts to read and understand it. Failing to do so creates extra work for the moderators, thus wasting resources, otherwise available to answer the members' questions.
Please use [code] tags in future.
MODERATOR
Check here and here about BULK BIND and FORALL
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Paul Davis |
last post by:
I'd like to overload 'comma' to define a concatenation operator for
integer-like classes. I've got some first ideas, but I'd appreciate a
sanity check. The concatenation operator needs to so...
|
by: joesoap |
last post by:
Hi can anybody please tell me what is wrong with my ostream operator???
this is the output i get using the 3 attached files.
this is the output after i run assignment2
-joesoap
#include...
|
by: Jason |
last post by:
Hello. I am trying to learn how operator overloading works so I wrote
a simple class to help me practice. I understand the basic opertoar
overload like + - / *, but when I try to overload more...
|
by: YUY0x7 |
last post by:
Hi, I am having a bit of trouble with a specialization of operator<<.
Here goes:
class MyStream
{
};
template <typename T>
MyStream& operator<<(MyStream& lhs, T const &)
|
by: Jens.Toerring |
last post by:
Hi,
I have a possibly rather stupid question about the order of evaluation
in a statement like this:
result = foo( x ) - bar( y );
How can I make 100% sure that foo(x) is evaluated before...
|
by: Tor Hovland |
last post by:
I have the following procedure:
TYPE testarray is table of int index by binary_integer;
PROCEDURE testfast(par1 in testarray) is
begin
FORALL i IN par1.FIRST..par1.LAST
insert into dummy...
|
by: Jake Barnes |
last post by:
I saw this sentence:
"The last stage of variable instantiation is to create named properties
of the Variable object that correspond with all the local variables
declared within the function."
...
|
by: raylopez99 |
last post by:
I need an example of a managed overloaded assignment operator for a
reference class, so I can equate two classes A1 and A2, say called
ARefClass, in this manner: A1=A2;. For some strange reason...
|
by: y-man |
last post by:
Hi,
I am trying to get an overloaded operator to work inside the class it
works on. The situation is something like this:
main.cc:
#include "object.hh"
#include "somefile.hh"
object obj,...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |