Advertisement

06.25.2008 at 07:05AM PDT, ID: 23514475 | Points: 500
[x]
Attachment Details

Insert a counter by group

Asked by mmatharu in Oracle 10.x, Oracle Database, PL / SQL

Tags: , ,

I have the following table:  table_temp1
fields: plant, merknr, counter   and the data is as follows
           1105,  1111
           1105,  2222
           1105, 1111
            1105, 2222
What I want to do is have a stored procedure to insert into the counter field, 10 for the first then 20, 30 for each of the plant and merknr... for examlpe:


plant, merknr, counter   and the data is as follows
1105,  1111, 10
1105,  2222, 10
1105, 1111, 20
1105, 2222, 20
Start Free Trial
[+][-]06.25.2008 at 07:11AM PDT, ID: 21865765

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 14-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.25.2008 at 07:24AM PDT, ID: 21865908

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 14-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.25.2008 at 08:57AM PDT, ID: 21867079

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 14-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.25.2008 at 09:07AM PDT, ID: 21867194

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 14-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.25.2008 at 09:58AM PDT, ID: 21867684

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 14-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.25.2008 at 10:03AM PDT, ID: 21867728

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 14-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.27.2008 at 07:05AM PDT, ID: 21883855

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 14-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.27.2008 at 07:27AM PDT, ID: 21884116

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 14-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.27.2008 at 07:45AM PDT, ID: 21884312

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 14-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.27.2008 at 07:54AM PDT, ID: 21884405

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 14-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.11.2008 at 02:00AM PDT, ID: 21980870

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 14-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11.08.2008 at 05:53PM PST, ID: 22914742

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 14-day free trial to view this Administrative Comment or ask the Experts your question.

 
[+][-]11.09.2008 at 07:51PM PST, ID: 22919059

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 14-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20081112-EE-VQP-43 / EE_QW_2_20070628